Query Metrics
24
Database Queries
19
Different statements
171.19 ms
Query time
0
Invalid entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 3.20 ms |
SELECT p0_.`id` AS id_0, p0_.`publish_date` AS publish_date_1, p0_.`hide_countries` AS hide_countries_2 FROM `publication` p0_ LEFT JOIN `locale_html` l1_ ON p0_.id = l1_.publication_body_id LEFT JOIN `locale_bool` l2_ ON p0_.id = l2_.blog_show_id LEFT JOIN `locale_bool` l3_ ON p0_.id = l3_.blog_hide_single_id WHERE p0_.`enable` = 1 AND l2_.`en` = 1 AND l1_.`en` <> '' AND l3_.`en` = ? AND p0_.`id` <> ? ORDER BY p0_.`publish_date` ASC
Parameters:
[ 0 2235 ] |
| 2 | 3.18 ms |
SELECT e0_.`id` AS id_0, e0_.`created_at` AS created_at_1 FROM `exh` e0_ LEFT JOIN `locale_html` l1_ ON e0_.id = l1_.exh_text_id LEFT JOIN `locale_bool` l2_ ON e0_.id = l2_.exh_show_id LEFT JOIN `locale_bool` l3_ ON e0_.id = l3_.exh_hide_single_id WHERE e0_.`enable` = 1 AND l2_.`en` = 1 AND l1_.`en` <> '' AND l3_.`en` = ?
Parameters:
[
0
]
|
| 3 | 2.04 ms |
SELECT p.id, p.enable, p.unid, p.view, p.publish_date AS `publishDate`, p.hide_countries AS `hideCountries`, lcurl.en AS `url`, lctitle.en AS `title`, lchtml.en AS `body`, lcssShow.en AS `statusShow`, lchs.en AS `hideSingle`, lcpw.def AS `preview.def`, lcpw.en AS `preview.en`, lcpw.en AS `preview.lc`, COUNT(DISTINCT cmt.id) AS `commentCnt` FROM publication p LEFT JOIN `publication_like` `plike` ON plike.publication_id = p.id LEFT JOIN `locale_url` `lcurl` ON lcurl.publication_id = p.id LEFT JOIN `locale_title` `lctitle` ON lctitle.publication_id = p.id LEFT JOIN `locale_html` `lchtml` ON lchtml.publication_body_id = p.id LEFT JOIN `locale_bool` `lcssShow` ON lcssShow.blog_show_id = p.id LEFT JOIN `locale_bool` `lchs` ON lchs.blog_hide_single_id = p.id LEFT JOIN `locale_preview` `lcpw` ON lcpw.publication_id = p.id LEFT JOIN `comment_refact` `cmt` ON cmt.commentable_unid = p.unid AND cmt.locale = 'en' WHERE p.id IN (2308,2302,2305,2296,2293,2290,2287,2278,2241,2232,2221,2216,2213,2211,2209,2205,2204,2203,2201,2198,2191,2187,2135,2185,2169,2168,2167,2139,2134,2126,2111,2076,1997,1996,1983,1979,1940,1930,1913,1868,1723,1689,1678,1331,98) GROUP BY p.id;
Parameters:
[] |
| 4 | 23.20 ms |
SELECT e0_.`id` AS id_0, e0_.`enable` AS enable_1, e0_.`unid` AS unid_2, e0_.`view` AS view_3, e0_.`created_at` AS created_at_4, e0_.`updated_at` AS updated_at_5, l1_.`id` AS id_6, l1_.`source` AS source_7, l1_.`ru` AS ru_8, l1_.`en` AS en_9, l1_.`it` AS it_10, l1_.`es` AS es_11, l1_.`fr` AS fr_12, l1_.`de` AS de_13, l1_.`pl` AS pl_14, l1_.`pt` AS pt_15, l1_.`nl` AS nl_16, l1_.`fi` AS fi_17, l1_.`ua` AS ua_18, l1_.`sv` AS sv_19, l1_.`no` AS no_20, l1_.`da` AS da_21, l1_.`cn` AS cn_22, l1_.`zh` AS zh_23, l1_.`created_at` AS created_at_24, l1_.`updated_at` AS updated_at_25, l2_.`id` AS id_26, l2_.`source` AS source_27, l2_.`ru` AS ru_28, l2_.`en` AS en_29, l2_.`it` AS it_30, l2_.`es` AS es_31, l2_.`fr` AS fr_32, l2_.`de` AS de_33, l2_.`pl` AS pl_34, l2_.`pt` AS pt_35, l2_.`nl` AS nl_36, l2_.`fi` AS fi_37, l2_.`ua` AS ua_38, l2_.`sv` AS sv_39, l2_.`no` AS no_40, l2_.`da` AS da_41, l2_.`cn` AS cn_42, l2_.`zh` AS zh_43, l2_.`created_at` AS created_at_44, l2_.`updated_at` AS updated_at_45, l3_.`id` AS id_46, l3_.`source` AS source_47, l3_.`ru` AS ru_48, l3_.`en` AS en_49, l3_.`it` AS it_50, l3_.`es` AS es_51, l3_.`fr` AS fr_52, l3_.`de` AS de_53, l3_.`pl` AS pl_54, l3_.`pt` AS pt_55, l3_.`nl` AS nl_56, l3_.`fi` AS fi_57, l3_.`ua` AS ua_58, l3_.`sv` AS sv_59, l3_.`no` AS no_60, l3_.`da` AS da_61, l3_.`cn` AS cn_62, l3_.`zh` AS zh_63, l3_.`created_at` AS created_at_64, l3_.`updated_at` AS updated_at_65, l4_.`id` AS id_66, l4_.`source` AS source_67, l4_.`ru` AS ru_68, l4_.`en` AS en_69, l4_.`it` AS it_70, l4_.`es` AS es_71, l4_.`fr` AS fr_72, l4_.`de` AS de_73, l4_.`pl` AS pl_74, l4_.`pt` AS pt_75, l4_.`nl` AS nl_76, l4_.`fi` AS fi_77, l4_.`ua` AS ua_78, l4_.`sv` AS sv_79, l4_.`no` AS no_80, l4_.`da` AS da_81, l4_.`cn` AS cn_82, l4_.`zh` AS zh_83, l4_.`created_at` AS created_at_84, l4_.`updated_at` AS updated_at_85, l5_.`id` AS id_86, l5_.`source` AS source_87, l5_.`ru` AS ru_88, l5_.`en` AS en_89, l5_.`it` AS it_90, l5_.`es` AS es_91, l5_.`fr` AS fr_92, l5_.`de` AS de_93, l5_.`pl` AS pl_94, l5_.`pt` AS pt_95, l5_.`nl` AS nl_96, l5_.`fi` AS fi_97, l5_.`ua` AS ua_98, l5_.`sv` AS sv_99, l5_.`no` AS no_100, l5_.`da` AS da_101, l5_.`cn` AS cn_102, l5_.`zh` AS zh_103, l5_.`created_at` AS created_at_104, l5_.`updated_at` AS updated_at_105, l6_.`id` AS id_106, l6_.`def` AS def_107, l6_.`ru` AS ru_108, l6_.`en` AS en_109, l6_.`it` AS it_110, l6_.`es` AS es_111, l6_.`fr` AS fr_112, l6_.`de` AS de_113, l6_.`pl` AS pl_114, l6_.`pt` AS pt_115, l6_.`nl` AS nl_116, l6_.`fi` AS fi_117, l6_.`ua` AS ua_118, l6_.`sv` AS sv_119, l6_.`no` AS no_120, l6_.`da` AS da_121, l6_.`cn` AS cn_122, l6_.`zh` AS zh_123, l6_.`created_at` AS created_at_124, l6_.`updated_at` AS updated_at_125, l7_.`id` AS id_126, l7_.`token` AS token_127, u8_.`id` AS id_128, u8_.`unid` AS unid_129, u8_.`corporate_unid` AS corporate_unid_130, u8_.`token` AS token_131, u8_.`is_active` AS is_active_132, u8_.`proved` AS proved_133, u8_.`alias` AS alias_134, u8_.`foreign_alias` AS foreign_alias_135, u8_.`lotus_name` AS lotus_name_136, u8_.`password` AS password_137, u8_.`expired` AS expired_138, u8_.`expires_at` AS expires_at_139, u8_.`credentials_expired` AS credentials_expired_140, u8_.`credentials_expire_at` AS credentials_expire_at_141, u8_.`last_ip` AS last_ip_142, u8_.`source` AS source_143, u8_.`social_network` AS social_network_144, u8_.`social_network_id` AS social_network_id_145, u8_.`google_id` AS google_id_146, u8_.`fb_id` AS fb_id_147, u8_.`vk_id` AS vk_id_148, u8_.`ig_id` AS ig_id_149, u8_.`test` AS test_150, u8_.`token_fixed` AS token_fixed_151, u8_.`bid` AS bid_152, u8_.`email` AS email_153, u8_.`salt` AS salt_154, u8_.`review_request_sent` AS review_request_sent_155, u8_.`username` AS username_156, u8_.`roles` AS roles_157, u8_.`enabled` AS enabled_158, u8_.`confirmation_token` AS confirmation_token_159, u8_.`last_login` AS last_login_160, u8_.`password_requested_at` AS password_requested_at_161, u8_.`security_field` AS security_field_162, u8_.`created_at` AS created_at_163, u8_.`is_legal_entity` AS is_legal_entity_164, u8_.`companyName` AS companyName_165, u8_.`vatNumber` AS vatNumber_166, u8_.`lang` AS lang_167, l9_.`id` AS id_168, l9_.`source` AS source_169, l9_.`ru` AS ru_170, l9_.`en` AS en_171, l9_.`it` AS it_172, l9_.`es` AS es_173, l9_.`fr` AS fr_174, l9_.`de` AS de_175, l9_.`pl` AS pl_176, l9_.`pt` AS pt_177, l9_.`nl` AS nl_178, l9_.`fi` AS fi_179, l9_.`ua` AS ua_180, l9_.`sv` AS sv_181, l9_.`no` AS no_182, l9_.`da` AS da_183, l9_.`cn` AS cn_184, l9_.`zh` AS zh_185, l9_.`created_at` AS created_at_186, l9_.`updated_at` AS updated_at_187, l10_.`id` AS id_188, l10_.`ru` AS ru_189, l10_.`en` AS en_190, l10_.`it` AS it_191, l10_.`es` AS es_192, l10_.`fr` AS fr_193, l10_.`de` AS de_194, l10_.`pl` AS pl_195, l10_.`pt` AS pt_196, l10_.`nl` AS nl_197, l10_.`fi` AS fi_198, l10_.`ua` AS ua_199, l10_.`sv` AS sv_200, l10_.`no` AS no_201, l10_.`da` AS da_202, l10_.`cn` AS cn_203, l10_.`zh` AS zh_204, l10_.`created_at` AS created_at_205, l10_.`updated_at` AS updated_at_206, l11_.`id` AS id_207, l11_.`source` AS source_208, l11_.`ru` AS ru_209, l11_.`en` AS en_210, l11_.`it` AS it_211, l11_.`es` AS es_212, l11_.`fr` AS fr_213, l11_.`de` AS de_214, l11_.`pl` AS pl_215, l11_.`pt` AS pt_216, l11_.`nl` AS nl_217, l11_.`fi` AS fi_218, l11_.`ua` AS ua_219, l11_.`sv` AS sv_220, l11_.`no` AS no_221, l11_.`da` AS da_222, l11_.`cn` AS cn_223, l11_.`zh` AS zh_224, l11_.`created_at` AS created_at_225, l11_.`updated_at` AS updated_at_226 FROM `exh` e0_ LEFT JOIN `locale_url` l1_ ON e0_.id = l1_.exh_id LEFT JOIN `locale_title` l2_ ON e0_.id = l2_.exh_title_id LEFT JOIN `locale_html` l3_ ON e0_.id = l3_.exh_text_id LEFT JOIN `locale_meta` l4_ ON e0_.id = l4_.exh_description_id LEFT JOIN `locale_meta` l5_ ON e0_.id = l5_.exh_keywords_id LEFT JOIN `locale_preview` l6_ ON e0_.id = l6_.exh_id LEFT JOIN `likes` l7_ ON e0_.id = l7_.exh_id LEFT JOIN `user` u8_ ON e0_.author_id = u8_.id LEFT JOIN `locale_bool` l9_ ON e0_.id = l9_.exh_show_id LEFT JOIN `locale_status_translate` l10_ ON e0_.id = l10_.exh_id LEFT JOIN `locale_bool` l11_ ON e0_.id = l11_.exh_hide_single_id WHERE e0_.`id` IN (?)
Parameters:
[
[
16
13
9
5
4
3
2
]
]
|
| 5 | 3.71 ms |
SELECT u0_.`id` AS id_0, u0_.`unid` AS unid_1, u0_.`corporate_unid` AS corporate_unid_2, u0_.`token` AS token_3, u0_.`is_active` AS is_active_4, u0_.`proved` AS proved_5, u0_.`alias` AS alias_6, u0_.`foreign_alias` AS foreign_alias_7, u0_.`lotus_name` AS lotus_name_8, u0_.`password` AS password_9, u0_.`expired` AS expired_10, u0_.`expires_at` AS expires_at_11, u0_.`credentials_expired` AS credentials_expired_12, u0_.`credentials_expire_at` AS credentials_expire_at_13, u0_.`last_ip` AS last_ip_14, u0_.`source` AS source_15, u0_.`social_network` AS social_network_16, u0_.`social_network_id` AS social_network_id_17, u0_.`google_id` AS google_id_18, u0_.`fb_id` AS fb_id_19, u0_.`vk_id` AS vk_id_20, u0_.`ig_id` AS ig_id_21, u0_.`test` AS test_22, u0_.`token_fixed` AS token_fixed_23, u0_.`bid` AS bid_24, u0_.`email` AS email_25, u0_.`salt` AS salt_26, u0_.`review_request_sent` AS review_request_sent_27, u0_.`username` AS username_28, u0_.`roles` AS roles_29, u0_.`enabled` AS enabled_30, u0_.`confirmation_token` AS confirmation_token_31, u0_.`last_login` AS last_login_32, u0_.`password_requested_at` AS password_requested_at_33, u0_.`security_field` AS security_field_34, u0_.`created_at` AS created_at_35, u0_.`is_legal_entity` AS is_legal_entity_36, u0_.`companyName` AS companyName_37, u0_.`vatNumber` AS vatNumber_38, u0_.`lang` AS lang_39 FROM `user` u0_ WHERE u0_.`token` = ? LIMIT 1
Parameters:
[
"c8ebb57b06aa01dd2bf1ea5d9c9dfed6d65f27fdfa42855b12243773f25cf74b"
]
|
| 6 | 0.70 ms |
SELECT COUNT(b0_.`code`) AS sclr_0 FROM `buy_order` b1_ LEFT JOIN `buy_order_article` b0_ ON b1_.id = b0_.buy_order_id WHERE b1_.`token` = ? AND b1_.`status` <> 12
Parameters:
[
"c8ebb57b06aa01dd2bf1ea5d9c9dfed6d65f27fdfa42855b12243773f25cf74b"
]
|
| 7 | 0.66 ms |
SELECT b0_.`id` AS id_0 FROM `buy_order` b0_ WHERE b0_.`token` = ? AND b0_.`status` <> 12
Parameters:
[
"c8ebb57b06aa01dd2bf1ea5d9c9dfed6d65f27fdfa42855b12243773f25cf74b"
]
|
| 8 | 1.14 ms |
SELECT COUNT(v0_.`id`) AS sclr_0 FROM `visit` v0_ WHERE v0_.`token` = ? AND v0_.`url` <> '/.*catalog.*/'
Parameters:
[
"c8ebb57b06aa01dd2bf1ea5d9c9dfed6d65f27fdfa42855b12243773f25cf74b"
]
|
| 9 | 0.64 ms |
SELECT COUNT(i0_.`id`) AS sclr_0 FROM `idea` i1_ INNER JOIN idea_interior i2_ ON i1_.id = i2_.idea_id INNER JOIN `interior` i0_ ON i0_.id = i2_.interior_id WHERE i1_.`token` = ?
Parameters:
[
"c8ebb57b06aa01dd2bf1ea5d9c9dfed6d65f27fdfa42855b12243773f25cf74b"
]
|
| 10 | 3.72 ms |
SELECT b0_.`id` AS id_0, b0_.`name` AS name_1, b0_.`descr` AS descr_2, b0_.`val` AS val_3 FROM `BoolDBSetting` b0_ WHERE b0_.`name` = ?
Parameters:
[
"RTWidget"
]
|
| 11 | 2.71 ms |
SELECT t0.`id` AS id_1, t0.`token` AS token_2, t0.`current_welcome_cons` AS current_welcome_cons_3, t0.`current_country` AS current_country_4, t0.`current_country_by_ip` AS current_country_by_ip_5, t0.`current_locale` AS current_locale_6, t0.`is_interview` AS is_interview_7, t0.`job_seeker_unid` AS job_seeker_unid_8, t0.interview_id AS interview_id_9 FROM `chat_b` t0 WHERE t0.`token` = ? LIMIT 1
Parameters:
[
"c8ebb57b06aa01dd2bf1ea5d9c9dfed6d65f27fdfa42855b12243773f25cf74b"
]
|
| 12 | 2.16 ms |
SELECT b0_.`id` AS id_0, b0_.`name` AS name_1, b0_.`descr` AS descr_2, b0_.`val` AS val_3 FROM `BoolDBSetting` b0_ WHERE b0_.`name` = ?
Parameters:
[
"RTWidget"
]
|
| 13 | 0.38 ms |
SELECT f0_.`id` AS id_0 FROM `geo_country` g1_ LEFT JOIN factory_hide_countries f2_ ON g1_.id = f2_.country_id LEFT JOIN `factory` f0_ ON f0_.id = f2_.factory_id WHERE g1_.`code` = ?
Parameters:
[
"us"
]
|
| 14 | 100.23 ms |
SELECT c0_.`id` AS id_0, c0_.`url` AS url_1, c0_.`code` AS code_2, c0_.`name` AS name_3, c0_.`alternate_name` AS alternate_name_4, c0_.`name_full` AS name_full_5, f1_.`id` AS id_6, f1_.`url` AS url_7, f1_.`unid` AS unid_8, f2_.`id` AS id_9, f1_.`url` AS url_10, f1_.`name` AS name_11, (SELECT COUNT(p3_.`star`) AS sclr_13 FROM `product_reviews_cache` p3_ WHERE p3_.`sku` = c0_.`code`) AS sclr_12, (SELECT SUM(p4_.`star`) AS sclr_15 FROM `product_reviews_cache` p4_ WHERE p4_.`sku` = c0_.`code`) AS sclr_14 FROM `collection` c0_ INNER JOIN `factory` f1_ ON c0_.factory = f1_.id INNER JOIN `filters` f2_ ON f1_.filter = f2_.id INNER JOIN `list_country` l5_ ON f1_.country = l5_.id LEFT JOIN `locale_url` l6_ ON f2_.id = l6_.filter_id LEFT JOIN `filter_pages` f7_ ON f2_.page_id = f7_.id WHERE f1_.filter IS NOT NULL AND c0_.factory <> '' AND f1_.`status` = ? AND f1_.`id` NOT IN (?) AND (c0_.`test_access` IS NULL OR c0_.`test_access` = 0) AND (f1_.`test_access` IS NULL OR f1_.`test_access` = 0) AND c0_.`status` = ? AND c0_.`status` = ? AND f1_.`status` = ? ORDER BY c0_.`id` ASC
Parameters:
[ 1 [ 14 ] 1 1 1 ] |
| 15 | 0.28 ms |
SELECT COUNT(f0_.`id`) AS sclr_0 FROM `filters` f0_ LEFT JOIN `factory` f1_ ON f0_.brand = f1_.id LEFT JOIN `filter_params` f2_ ON f0_.param_id = f2_.id WHERE f0_.brand IS NOT NULL AND f0_.`id` <> 10639 AND f1_.`status` = ? AND f2_.`is_enable` = 1 AND f2_.`count` >= 0 AND f1_.`unid` IS NOT NULL AND f1_.`test_access` IS NULL ORDER BY f0_.`name` ASC
Parameters:
[
1
]
|
| 16 | 5.54 ms |
SELECT lu.en AS slug FROM publication p LEFT JOIN `locale_url` `lu` ON `lu`.publication_id = `p`.id LEFT JOIN `locale_bool` `lp` ON `lp`.blog_show_id = `p`.id LEFT JOIN `locale_status_translate` `lst` ON `lst`.publication_id = `p`.id WHERE p.id = 2232 AND lp.en = 1 AND lst.en = 1;
Parameters:
[] |
| 17 | 2.02 ms |
SELECT f0_.`id` AS id_0, f0_.`old_command` AS old_command_1, f0_.`old_id` AS old_id_2, f0_.`left_menu` AS left_menu_3, f1_.`id` AS id_4, f0_.`important` AS important_5, l2_.`en` AS en_6, f3_.`name_menu_en` AS name_menu_en_7, f4_.`alt_name` AS alt_name_8, f5_.`count` AS count_9, f0_.`id` AS id_10, f0_.`name` AS name_11, f0_.`alt_name` AS alt_name_12, f0_.`left_menu` AS left_menu_13, f0_.`sort` AS sort_14, f0_.`important` AS important_15, f0_.`old_command` AS old_command_16, f0_.`old_id` AS old_id_17, f0_.`sub_key` AS sub_key_18, f0_.`parent_key` AS parent_key_19, f0_.`rank` AS rank_20, f0_.`icon` AS icon_21, f0_.`icon_url` AS icon_url_22, f0_.`logo` AS logo_23, f0_.`logo_url` AS logo_url_24, f0_.`created_at` AS created_at_25, f0_.`updated_at` AS updated_at_26, f6_.`id` AS id_27, f6_.`name` AS name_28, f6_.`alt_name` AS alt_name_29, f6_.`left_menu` AS left_menu_30, f6_.`sort` AS sort_31, f6_.`important` AS important_32, f6_.`old_command` AS old_command_33, f6_.`old_id` AS old_id_34, f6_.`sub_key` AS sub_key_35, f6_.`parent_key` AS parent_key_36, f6_.`rank` AS rank_37, f6_.`icon` AS icon_38, f6_.`icon_url` AS icon_url_39, f6_.`logo` AS logo_40, f6_.`logo_url` AS logo_url_41, f6_.`created_at` AS created_at_42, f6_.`updated_at` AS updated_at_43 FROM `filters` f0_ LEFT JOIN `locale_url` l2_ ON f0_.id = l2_.filter_id LEFT JOIN `filter_pages` f3_ ON f0_.page_id = f3_.id LEFT JOIN `filter_params` f5_ ON f0_.param_id = f5_.id LEFT JOIN `filter_groups` f4_ ON f0_.group_id = f4_.id LEFT JOIN `filters` f6_ ON f0_.country_id = f6_.id LEFT JOIN `filters` f1_ ON f0_.parent_id = f1_.id WHERE f5_.`is_enable` = 1 AND (f5_.`show_menu` = 1 OR f5_.`show_menu_advanced` = 1) AND l2_.`en` IS NOT NULL AND f5_.`count` > 0 AND f4_.`alt_name` IN (?) ORDER BY f0_.`sort` ASC, f0_.`name` ASC
Parameters:
[
[
"effect"
"style"
"samples"
"price"
"color"
"using"
"brand"
]
]
|
| 18 | 1.45 ms |
SELECT c0_.`id` AS id_0, c0_.`special_date_start` AS special_date_start_1, c0_.`special_date_end` AS special_date_end_2, c0_.`is_working` AS is_working_3, c0_.`mode` AS mode_4, c0_.`mode_holiday` AS mode_holiday_5, c0_.`lang` AS lang_6, c0_.`timeZoneName` AS timeZoneName_7, c0_.country_id AS country_id_8, c0_.blog_id AS blog_id_9 FROM `calendar` c0_ WHERE c0_.`special_date_start` <= ? AND c0_.`special_date_end` >= ? AND c0_.`is_working` = ? AND c0_.country_id = ? ORDER BY c0_.`special_date_start` ASC LIMIT 100
Parameters:
[ "2025-09-03" "2025-08-03" 2 840 ] |
| 19 | 5.67 ms |
SELECT c0_.`id` AS id_0, c0_.`special_date_start` AS special_date_start_1, c0_.`special_date_end` AS special_date_end_2, c0_.`is_working` AS is_working_3, c0_.`mode` AS mode_4, c0_.`mode_holiday` AS mode_holiday_5, c0_.`lang` AS lang_6, c0_.`timeZoneName` AS timeZoneName_7, c0_.country_id AS country_id_8, c0_.blog_id AS blog_id_9 FROM `calendar` c0_ WHERE c0_.`special_date_start` <= ? AND c0_.`special_date_end` >= ? AND c0_.`is_working` = ? AND (c0_.country_id IS NULL OR c0_.country_id = 0 OR c0_.country_id = 'en') ORDER BY c0_.`special_date_start` ASC LIMIT 100
Parameters:
[ "2025-09-03" "2025-08-03" 2 ] |
| 20 | 1.90 ms |
SELECT c0_.`id` AS id_0, c0_.`special_date_start` AS special_date_start_1, c0_.`special_date_end` AS special_date_end_2, c0_.`is_working` AS is_working_3, c0_.`mode` AS mode_4, c0_.`mode_holiday` AS mode_holiday_5, c0_.`lang` AS lang_6, c0_.`timeZoneName` AS timeZoneName_7, c0_.country_id AS country_id_8, c0_.blog_id AS blog_id_9 FROM `calendar` c0_ WHERE c0_.`special_date_start` <= ? AND c0_.`special_date_end` >= ? AND c0_.`is_working` = ? AND c0_.country_id = ? ORDER BY c0_.`special_date_start` ASC LIMIT 100
Parameters:
[ "2025-09-03" "2025-08-03" 3 840 ] |
| 21 | 1.71 ms |
SELECT c0_.`id` AS id_0, c0_.`special_date_start` AS special_date_start_1, c0_.`special_date_end` AS special_date_end_2, c0_.`is_working` AS is_working_3, c0_.`mode` AS mode_4, c0_.`mode_holiday` AS mode_holiday_5, c0_.`lang` AS lang_6, c0_.`timeZoneName` AS timeZoneName_7, c0_.country_id AS country_id_8, c0_.blog_id AS blog_id_9 FROM `calendar` c0_ WHERE c0_.`special_date_start` <= ? AND c0_.`special_date_end` >= ? AND c0_.`is_working` = ? AND (c0_.country_id IS NULL OR c0_.country_id = 0 OR c0_.country_id = 'en') ORDER BY c0_.`special_date_start` ASC LIMIT 100
Parameters:
[ "2025-09-03" "2025-08-03" 3 ] |
| 22 | 3.79 ms |
SELECT COUNT(c0_.`id`) AS sclr_0 FROM `comment_refact` c0_ WHERE c0_.`locale` = ? AND c0_.`commentable_unid` = ?
Parameters:
[ null "008F3B7DBA846FCEC32577DA007AAF3D" ] |
| 23 | 0.22 ms |
SELECT COUNT(c0_.`id`) AS sclr_0 FROM `comment_refact` c0_ WHERE c0_.`locale` = ? AND c0_.`commentable_unid` = ?
Parameters:
[ null "008F3B7DBA846FCEC32577DA007AAF3D" ] |
| 24 | 0.96 ms |
SELECT b0_.`id` AS id_0, b0_.`name` AS name_1, b0_.`descr` AS descr_2, b0_.`val` AS val_3 FROM `BoolDBSetting` b0_ WHERE b0_.`name` = ?
Parameters:
[
"RTWidget"
]
|
oneC connection
No database queries were performed.
logs connection
No database queries were performed.
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| oneC | doctrine.dbal.oneC_connection |
| logs | doctrine.dbal.logs_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| oneC | doctrine.orm.oneC_entity_manager |
| logs | doctrine.orm.logs_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
default entity manager
| Class | Mapping errors |
|---|---|
| WebBundle\Entity\User | No errors. |
| WebBundle\Entity\Publication | No errors. |
| FlexApp\Entity\Exhibition\ExhEntity | No errors. |
| FlexApp\Entity\ChatB | No errors. |
| FlexApp\Entity\ChatBMessage | No errors. |
| FlexApp\Entity\BoolDBSetting | No errors. |
| FlexApp\Entity\Widget | No errors. |
| FlexApp\Entity\CountryAndLangSpecificDataEntity | No errors. |
| WebBundle\Entity\ListCountry | No errors. |
| FlexApp\Entity\ConsultantEntity | No errors. |
| WebBundle\Entity\LocaleUrlEntity | No errors. |
| WebBundle\Entity\LocaleTitleEntity | No errors. |
| WebBundle\Entity\LocaleHtmlEntity | No errors. |
| WebBundle\Entity\LocaleMetaEntity | No errors. |
| WebBundle\Entity\LocalePreviewEntity | No errors. |
| FlexApp\Entity\LikesEntity | No errors. |
| WebBundle\Entity\LocaleBoolEntity | No errors. |
| WebBundle\Entity\LocaleStatusTranslateEntity | No errors. |
| FlexApp\Entity\GeoCountryEntity | No errors. |
| WebBundle\Entity\Collection | No errors. |
| WebBundle\Entity\FilterEntity | No errors. |
| WebBundle\Entity\Article | No errors. |
| WebBundle\Entity\Visit | No errors. |
| WebBundle\Entity\Idea | No errors. |
| WebBundle\Entity\BuyOrder | No errors. |
| WebBundle\Entity\OrderAddress | No errors. |
| WebBundle\Entity\ListEmail | No errors. |
| WebBundle\Entity\OrderHistory | No errors. |
| WebBundle\Entity\OrderPayment | No errors. |
| WebBundle\Entity\CurrencyRate | No errors. |
| WebBundle\Entity\ListVat | No errors. |
| WebBundle\Entity\WarehouseEntity | No errors. |
| WebBundle\Entity\BuyOrderArticle | No errors. |
| WebBundle\Entity\BuyOrderManager | No errors. |
| FlexApp\Entity\InterviewEntity | No errors. |
| WebBundle\Entity\Factory | No errors. |
| WebBundle\Entity\TransExEntity | No errors. |
| WebBundle\Entity\Participant | No errors. |
| WebBundle\Entity\FactoryUser | No errors. |
| WebBundle\Entity\PublicationLike | No errors. |
| FlexApp\Entity\Exhibition\ExhBrandEntity | No errors. |
| FlexApp\Entity\AttachmentEntity | No errors. |
| WebBundle\Entity\ListState | No errors. |
| WebBundle\Entity\StaticPageEntity | No errors. |
| WebBundle\Entity\TransEntity | No errors. |
| FlexApp\Entity\Exhibition\ExhCollectionEntity | No errors. |
| FlexApp\Entity\GeoLocaleNameEntity | No errors. |
| FlexApp\Entity\GeoRegionEntity | No errors. |
| WebBundle\Entity\ListPrice | No errors. |
| WebBundle\Entity\Interior | No errors. |
| WebBundle\Entity\CheckList | No errors. |
| WebBundle\Entity\FilterPageEntity | No errors. |
| WebBundle\Entity\FilterParamEntity | No errors. |
| WebBundle\Entity\FilterGroupEntity | No errors. |
| WebBundle\Entity\LocaleTextEntity | No errors. |
| FlexApp\Entity\Exhibition\ExhImageEntity | No errors. |
| FlexApp\Entity\Collection\CollectionEntity | No errors. |
| WebBundle\Entity\ListType | No errors. |
| WebBundle\Entity\ListMeasure | No errors. |
| WebBundle\Entity\ListSurface | No errors. |
| WebBundle\Entity\ListPRStatus | No errors. |
| WebBundle\Entity\ListEdgeType | No errors. |
| WebBundle\Entity\ListUsing | No errors. |
| WebBundle\Entity\ListShape | No errors. |
| WebBundle\Entity\ListMaterial | No errors. |
| WebBundle\Entity\ListDelivery | No errors. |
| WebBundle\Entity\ListSliding | No errors. |
| WebBundle\Entity\ListOffShade | No errors. |
| WebBundle\Entity\ListStyle | No errors. |
| WebBundle\Entity\ListColor | No errors. |
| WebBundle\Entity\ListFactoryColor | No errors. |
| WebBundle\Entity\ListTexture | No errors. |
| WebBundle\Entity\ListStoneTexture | No errors. |
| WebBundle\Entity\ArticlePriceDiscount | No errors. |
| WebBundle\Entity\InteriorArticle | No errors. |
| WebBundle\Entity\InteriorArticleLogging | No errors. |
| WebBundle\Entity\ListRepeatDraw | No errors. |
| WebBundle\Entity\ListMotiv | No errors. |
| WebBundle\Entity\ListMeasureSize | No errors. |
| WebBundle\Entity\SampleEntity | No errors. |
| WebBundle\Entity\ListSink | No errors. |
| WebBundle\Entity\ListMethLaying | No errors. |
| WebBundle\Entity\ArticleDetail | No errors. |
| WebBundle\Entity\ListDraw | No errors. |
| WebBundle\Entity\InteriorHistory | No errors. |
| FlexApp\Entity\Mailing | No errors. |
| WebBundle\Entity\BuyOrderDelivery | No errors. |
| WebBundle\Entity\ListEmailGroup | No errors. |
| WebBundle\Entity\ProductReviewsCache | No errors. |
| WebBundle\Entity\BuyOrderArticleHoliday | No errors. |
| WebBundle\Entity\Calendar | No errors. |
| FlexApp\Entity\CommentEntity | No errors. |
oneC entity manager
No loaded entities.
logs entity manager
No loaded entities.