https://dev5.tile.expert/en-sk/blog/insights-about-tile-new-arrivals-at-cersaie-2019

Query Metrics

19 Database Queries
17 Different statements
194.13 ms Query time
0 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 23.48 ms
SELECT p0_.`id` AS id_0, p0_.`enable` AS enable_1, p0_.`unid` AS unid_2, p0_.`publish_date` AS publish_date_3, p0_.`update_date` AS update_date_4, p0_.`view` AS view_5, p0_.`hide_countries` AS hide_countries_6, l1_.`id` AS id_7, l1_.`source` AS source_8, l1_.`ru` AS ru_9, l1_.`en` AS en_10, l1_.`it` AS it_11, l1_.`es` AS es_12, l1_.`fr` AS fr_13, l1_.`de` AS de_14, l1_.`pl` AS pl_15, l1_.`pt` AS pt_16, l1_.`nl` AS nl_17, l1_.`fi` AS fi_18, l1_.`ua` AS ua_19, l1_.`sv` AS sv_20, l1_.`no` AS no_21, l1_.`da` AS da_22, l1_.`cn` AS cn_23, l1_.`zh` AS zh_24, l1_.`created_at` AS created_at_25, l1_.`updated_at` AS updated_at_26, l2_.`id` AS id_27, l2_.`source` AS source_28, l2_.`ru` AS ru_29, l2_.`en` AS en_30, l2_.`it` AS it_31, l2_.`es` AS es_32, l2_.`fr` AS fr_33, l2_.`de` AS de_34, l2_.`pl` AS pl_35, l2_.`pt` AS pt_36, l2_.`nl` AS nl_37, l2_.`fi` AS fi_38, l2_.`ua` AS ua_39, l2_.`sv` AS sv_40, l2_.`no` AS no_41, l2_.`da` AS da_42, l2_.`cn` AS cn_43, l2_.`zh` AS zh_44, l2_.`created_at` AS created_at_45, l2_.`updated_at` AS updated_at_46, l3_.`id` AS id_47, l3_.`source` AS source_48, l3_.`ru` AS ru_49, l3_.`en` AS en_50, l3_.`it` AS it_51, l3_.`es` AS es_52, l3_.`fr` AS fr_53, l3_.`de` AS de_54, l3_.`pl` AS pl_55, l3_.`pt` AS pt_56, l3_.`nl` AS nl_57, l3_.`fi` AS fi_58, l3_.`ua` AS ua_59, l3_.`sv` AS sv_60, l3_.`no` AS no_61, l3_.`da` AS da_62, l3_.`cn` AS cn_63, l3_.`zh` AS zh_64, l3_.`created_at` AS created_at_65, l3_.`updated_at` AS updated_at_66, l4_.`id` AS id_67, l4_.`source` AS source_68, l4_.`ru` AS ru_69, l4_.`en` AS en_70, l4_.`it` AS it_71, l4_.`es` AS es_72, l4_.`fr` AS fr_73, l4_.`de` AS de_74, l4_.`pl` AS pl_75, l4_.`pt` AS pt_76, l4_.`nl` AS nl_77, l4_.`fi` AS fi_78, l4_.`ua` AS ua_79, l4_.`sv` AS sv_80, l4_.`no` AS no_81, l4_.`da` AS da_82, l4_.`cn` AS cn_83, l4_.`zh` AS zh_84, l4_.`created_at` AS created_at_85, l4_.`updated_at` AS updated_at_86, l5_.`id` AS id_87, l5_.`source` AS source_88, l5_.`ru` AS ru_89, l5_.`en` AS en_90, l5_.`it` AS it_91, l5_.`es` AS es_92, l5_.`fr` AS fr_93, l5_.`de` AS de_94, l5_.`pl` AS pl_95, l5_.`pt` AS pt_96, l5_.`nl` AS nl_97, l5_.`fi` AS fi_98, l5_.`ua` AS ua_99, l5_.`sv` AS sv_100, l5_.`no` AS no_101, l5_.`da` AS da_102, l5_.`cn` AS cn_103, l5_.`zh` AS zh_104, l5_.`created_at` AS created_at_105, l5_.`updated_at` AS updated_at_106, l6_.`id` AS id_107, l6_.`source` AS source_108, l6_.`ru` AS ru_109, l6_.`en` AS en_110, l6_.`it` AS it_111, l6_.`es` AS es_112, l6_.`fr` AS fr_113, l6_.`de` AS de_114, l6_.`pl` AS pl_115, l6_.`pt` AS pt_116, l6_.`nl` AS nl_117, l6_.`fi` AS fi_118, l6_.`ua` AS ua_119, l6_.`sv` AS sv_120, l6_.`no` AS no_121, l6_.`da` AS da_122, l6_.`cn` AS cn_123, l6_.`zh` AS zh_124, l6_.`created_at` AS created_at_125, l6_.`updated_at` AS updated_at_126, l7_.`id` AS id_127, l7_.`def` AS def_128, l7_.`ru` AS ru_129, l7_.`en` AS en_130, l7_.`it` AS it_131, l7_.`es` AS es_132, l7_.`fr` AS fr_133, l7_.`de` AS de_134, l7_.`pl` AS pl_135, l7_.`pt` AS pt_136, l7_.`nl` AS nl_137, l7_.`fi` AS fi_138, l7_.`ua` AS ua_139, l7_.`sv` AS sv_140, l7_.`no` AS no_141, l7_.`da` AS da_142, l7_.`cn` AS cn_143, l7_.`zh` AS zh_144, l7_.`created_at` AS created_at_145, l7_.`updated_at` AS updated_at_146, p8_.`id` AS id_147, p8_.`token` AS token_148, u9_.`id` AS id_149, u9_.`unid` AS unid_150, u9_.`corporate_unid` AS corporate_unid_151, u9_.`token` AS token_152, u9_.`is_active` AS is_active_153, u9_.`proved` AS proved_154, u9_.`alias` AS alias_155, u9_.`foreign_alias` AS foreign_alias_156, u9_.`lotus_name` AS lotus_name_157, u9_.`password` AS password_158, u9_.`expired` AS expired_159, u9_.`expires_at` AS expires_at_160, u9_.`credentials_expired` AS credentials_expired_161, u9_.`credentials_expire_at` AS credentials_expire_at_162, u9_.`last_ip` AS last_ip_163, u9_.`source` AS source_164, u9_.`social_network` AS social_network_165, u9_.`social_network_id` AS social_network_id_166, u9_.`google_id` AS google_id_167, u9_.`fb_id` AS fb_id_168, u9_.`vk_id` AS vk_id_169, u9_.`ig_id` AS ig_id_170, u9_.`test` AS test_171, u9_.`token_fixed` AS token_fixed_172, u9_.`bid` AS bid_173, u9_.`email` AS email_174, u9_.`salt` AS salt_175, u9_.`review_request_sent` AS review_request_sent_176, u9_.`username` AS username_177, u9_.`roles` AS roles_178, u9_.`enabled` AS enabled_179, u9_.`confirmation_token` AS confirmation_token_180, u9_.`last_login` AS last_login_181, u9_.`password_requested_at` AS password_requested_at_182, u9_.`security_field` AS security_field_183, u9_.`created_at` AS created_at_184, u9_.`is_legal_entity` AS is_legal_entity_185, u9_.`companyName` AS companyName_186, u9_.`vatNumber` AS vatNumber_187, u9_.`lang` AS lang_188, l10_.`id` AS id_189, l10_.`source` AS source_190, l10_.`ru` AS ru_191, l10_.`en` AS en_192, l10_.`it` AS it_193, l10_.`es` AS es_194, l10_.`fr` AS fr_195, l10_.`de` AS de_196, l10_.`pl` AS pl_197, l10_.`pt` AS pt_198, l10_.`nl` AS nl_199, l10_.`fi` AS fi_200, l10_.`ua` AS ua_201, l10_.`sv` AS sv_202, l10_.`no` AS no_203, l10_.`da` AS da_204, l10_.`cn` AS cn_205, l10_.`zh` AS zh_206, l10_.`created_at` AS created_at_207, l10_.`updated_at` AS updated_at_208 FROM `publication` p0_ LEFT JOIN `locale_url` l1_ ON p0_.id = l1_.publication_id LEFT JOIN `locale_html` l2_ ON p0_.id = l2_.publication_body_id LEFT JOIN `locale_title` l3_ ON p0_.id = l3_.publication_id LEFT JOIN `locale_meta` l4_ ON p0_.id = l4_.blog_description_id LEFT JOIN `locale_meta` l5_ ON p0_.id = l5_.blog_keywords_id LEFT JOIN `locale_bool` l6_ ON p0_.id = l6_.blog_show_id LEFT JOIN `locale_preview` l7_ ON p0_.id = l7_.publication_id LEFT JOIN `publication_like` p8_ ON p0_.id = p8_.publication_id LEFT JOIN `user` u9_ ON p0_.author = u9_.id LEFT JOIN `locale_bool` l10_ ON p0_.id = l10_.blog_hide_single_id WHERE l1_.`ru` = ? OR l1_.`en` = ? OR l1_.`it` = ? OR l1_.`es` = ? OR l1_.`fr` = ? OR l1_.`de` = ? OR l1_.`pl` = ? OR l1_.`nl` = ? OR l1_.`fi` = ? OR l1_.`sv` = ?
Parameters:
[
  "insights-about-tile-new-arrivals-at-cersaie-2019"
  "insights-about-tile-new-arrivals-at-cersaie-2019"
  "insights-about-tile-new-arrivals-at-cersaie-2019"
  "insights-about-tile-new-arrivals-at-cersaie-2019"
  "insights-about-tile-new-arrivals-at-cersaie-2019"
  "insights-about-tile-new-arrivals-at-cersaie-2019"
  "insights-about-tile-new-arrivals-at-cersaie-2019"
  "insights-about-tile-new-arrivals-at-cersaie-2019"
  "insights-about-tile-new-arrivals-at-cersaie-2019"
  "insights-about-tile-new-arrivals-at-cersaie-2019"
]
2 13.15 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, e8_.`id` AS id_128, e8_.`enable` AS enable_129, e8_.`name` AS name_130, e8_.`cid` AS cid_131, l9_.`id` AS id_132, l9_.`source` AS source_133, l9_.`ru` AS ru_134, l9_.`en` AS en_135, l9_.`it` AS it_136, l9_.`es` AS es_137, l9_.`fr` AS fr_138, l9_.`de` AS de_139, l9_.`pl` AS pl_140, l9_.`pt` AS pt_141, l9_.`nl` AS nl_142, l9_.`fi` AS fi_143, l9_.`ua` AS ua_144, l9_.`sv` AS sv_145, l9_.`no` AS no_146, l9_.`da` AS da_147, l9_.`cn` AS cn_148, l9_.`zh` AS zh_149, l9_.`created_at` AS created_at_150, l9_.`updated_at` AS updated_at_151 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 `exh_brand` e8_ ON e0_.id = e8_.exh_id LEFT JOIN `locale_bool` l9_ ON e0_.id = l9_.exh_show_id WHERE l1_.`ru` = ? OR l1_.`en` = ? OR l1_.`it` = ? OR l1_.`es` = ? OR l1_.`fr` = ? OR l1_.`de` = ? OR l1_.`pl` = ? OR l1_.`nl` = ? OR l1_.`fi` = ? OR l1_.`sv` = ?
Parameters:
[
  "insights-about-tile-new-arrivals-at-cersaie-2019"
  "insights-about-tile-new-arrivals-at-cersaie-2019"
  "insights-about-tile-new-arrivals-at-cersaie-2019"
  "insights-about-tile-new-arrivals-at-cersaie-2019"
  "insights-about-tile-new-arrivals-at-cersaie-2019"
  "insights-about-tile-new-arrivals-at-cersaie-2019"
  "insights-about-tile-new-arrivals-at-cersaie-2019"
  "insights-about-tile-new-arrivals-at-cersaie-2019"
  "insights-about-tile-new-arrivals-at-cersaie-2019"
  "insights-about-tile-new-arrivals-at-cersaie-2019"
]
3 2.06 ms
UPDATE `exh` SET `view` = `view` + 1  WHERE `id` = 4;
Parameters:
[]
4 0.27 ms
SELECT s0_.`code` AS code_0, s0_.`value` AS value_1, s0_.`link` AS link_2, s0_.`login` AS login_3, s0_.`token` AS token_4 FROM `social_stat` s0_ WHERE s0_.`locale` IS NULL OR s0_.`locale` = ?
Parameters:
[
  "en"
]
5 4.97 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:
[
  "22aeab08c856035c1dbfe1f90ce27f068d1ebb769b3cdb8c686c9445e005c719"
]
6 4.91 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:
[
  "22aeab08c856035c1dbfe1f90ce27f068d1ebb769b3cdb8c686c9445e005c719"
]
7 2.53 ms
SELECT b0_.`id` AS id_0 FROM `buy_order` b0_ WHERE b0_.`token` = ? AND b0_.`status` <> 12
Parameters:
[
  "22aeab08c856035c1dbfe1f90ce27f068d1ebb769b3cdb8c686c9445e005c719"
]
8 3.07 ms
SELECT COUNT(v0_.`id`) AS sclr_0 FROM `visit` v0_ WHERE v0_.`token` = ? AND v0_.`url` <> '/.*catalog.*/'
Parameters:
[
  "22aeab08c856035c1dbfe1f90ce27f068d1ebb769b3cdb8c686c9445e005c719"
]
9 2.91 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:
[
  "22aeab08c856035c1dbfe1f90ce27f068d1ebb769b3cdb8c686c9445e005c719"
]
10 0.78 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 1.46 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:
[
  "22aeab08c856035c1dbfe1f90ce27f068d1ebb769b3cdb8c686c9445e005c719"
]
12 0.19 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.50 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:
[
  "sk"
]
14 109.83 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 (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
  1
  1
  1
]
15 0.31 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 0.26 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 14.50 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 4.25 ms
SELECT `exbtext`.en AS `text`, `excolltext`.en AS `excoll.text`, `imgalt`.en AS `image.alt`, `exb`.id AS `id`, `exb`.enable AS `enable`, `exb`.name AS `name`, `brand`.id AS `bid`, `brand`.name AS `bname`, `brand`.alternate_name AS `full_name`, `brand`.url AS `slug`, `brand`.status AS `brand.status`, `cn`.id AS `cn.id`, `cn`.alias AS `cn.alias`, `cn`.code AS `cn.code`, `cn2`.id AS `cn2.id`, `cn2`.alias AS `cn2.alias`, `cn2`.code AS `cn2.code`, `excoll`.id AS `excoll.id`, `excoll`.name AS `excoll.name`, `excoll`.enable AS `excoll.enable`, `excoll`.formats AS `excoll.formats`, `coll`.id AS `coll.id`, `coll`.name AS `coll.name`, `coll`.url AS `coll.slug`, `coll`.status AS `coll.status`, `line`.id AS `line.id`, `line`.sort AS `line.sort`, `eximg`.id AS `image.id`, `eximg`.sort AS `image.sort`, `eximg`.file_name AS `image.file_name`, `eximg`.height AS `image.height`, `eximg`.width AS `image.width`, `imgf`.filter_id AS `filter.id` FROM exh_brand exb LEFT JOIN factory `brand` ON `brand`.id = `exb`.brand_id LEFT JOIN list_country `cn` ON `cn`.id = `brand`.country LEFT JOIN list_country `cn2` ON `cn2`.id = `exb`.cid LEFT JOIN exh_collection `excoll` ON `excoll`.exh_brand_id = `exb`.id LEFT JOIN collection `coll` ON `coll`.id = `excoll`.coll_id LEFT JOIN locale_html `exbtext` ON `exbtext`.exh_brand_text_id = `exb`.id LEFT JOIN locale_html `excolltext` ON `excolltext`.exh_collection_text_id = `excoll`.id LEFT JOIN exh_line `line` ON `line`.exh_collection_id = `excoll`.id LEFT JOIN exh_image `eximg` ON `eximg`.exh_line_id = `line`.id LEFT JOIN locale_text `imgalt` ON `imgalt`.exh_image_alt = `eximg`.id LEFT JOIN exh_images_filters `imgf` ON `imgf`.exh_image_id = `eximg`.id WHERE exb.id IN (126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,226,227,228,229,230,231,232,233)
Parameters:
[]
19 4.68 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.
WebBundle\Entity\LocaleUrlEntity 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\LocaleTitleEntity No errors.
WebBundle\Entity\LocaleHtmlEntity No errors.
WebBundle\Entity\LocaleMetaEntity No errors.
WebBundle\Entity\LocalePreviewEntity No errors.
FlexApp\Entity\LikesEntity No errors.
FlexApp\Entity\Exhibition\ExhBrandEntity No errors.
WebBundle\Entity\LocaleBoolEntity No errors.
WebBundle\Entity\SocialStat 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.
WebBundle\Entity\LocaleStatusTranslateEntity 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.

oneC entity manager

No loaded entities.

logs entity manager

No loaded entities.