Query Metrics
32
Database Queries
27
Different statements
4.99 ms
Query time
0
Invalid entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
0.86 ms (0.00%) |
1 |
SELECT a0_.`id` AS id_0, a0_.`code` AS code_1, a0_.`alternate_name` AS alternate_name_2, a0_.`urla` AS urla_3, a1_.`file` AS file_4, a0_.`price_euro` AS price_euro_5, a0_.`price_usd` AS price_usd_6, a0_.`price_prx` AS price_prx_7, a0_.`size_x` AS size_x_8, a0_.`size_y` AS size_y_9, a0_.`size_gb_x` AS size_gb_x_10, a0_.`size_gb_y` AS size_gb_y_11, a0_.`thick` AS thick_12, a0_.`weight` AS weight_13, a1_.`file_size2_x` AS file_size2_x_14, a1_.`file_size2_y` AS file_size2_y_15, l2_.`alias` AS alias_16, l3_.`alias` AS alias_17, l4_.`alias` AS alias_18, l5_.`alias` AS alias_19, l6_.`alias` AS alias_20, l7_.`alias` AS alias_21, c8_.`code` AS code_22, c8_.`name` AS name_23, c8_.`alternate_name` AS alternate_name_24, c8_.`url` AS url_25, f9_.`name` AS name_26, f9_.`url` AS url_27, l10_.`alias` AS alias_28, l11_.`alias` AS alias_29, l12_.`alias` AS alias_30 FROM `article` a0_ LEFT JOIN `list_type` l2_ ON a0_.type = l2_.id LEFT JOIN `list_edge_type` l3_ ON a0_.edge_type = l3_.id LEFT JOIN `list_shape` l4_ ON a0_.shape = l4_.id LEFT JOIN `list_material` l5_ ON a0_.material = l5_.id LEFT JOIN `list_sliding` l6_ ON a0_.sliding = l6_.id LEFT JOIN `list_off_shade` l7_ ON a0_.off_shade = l7_.id LEFT JOIN `list_using` l10_ ON a0_.using = l10_.id LEFT JOIN `collection` c8_ ON a0_.collection = c8_.id LEFT JOIN `list_price` l12_ ON a0_.category_price = l12_.id LEFT JOIN `list_delivery` l13_ ON a0_.delivery = l13_.id LEFT JOIN `article_detail` a1_ ON a0_.id = a1_.article_id LEFT JOIN `factory` f9_ ON c8_.factory = f9_.id LEFT JOIN `list_country` l11_ ON f9_.country = l11_.id WHERE c8_.`id` IS NOT NULL AND l13_.`id` <> 6 AND a0_.`price_euro` > 0 AND c8_.`status` IN (1, 2, 3, 4, 7) AND (c8_.`url` IS NOT NULL AND c8_.`url` <> '') AND f9_.`status` = 1 AND a1_.`file` IS NOT NULL AND a0_.`id` IN (?)
Parameters:
[
[
"154540370"
]
]
|
|
0.56 ms (0.00%) |
5 |
SELECT f2.id, f2.name, f2.old_command, f2.old_id, GROUP_CONCAT(f.id) AS ids, GROUP_CONCAT(f.old_id) AS old_ids FROM `filters` f LEFT JOIN filters f2 ON f.parent_id = f2.id LEFT JOIN filter_params p ON f.param_id = p.id WHERE f.parent_id IS NOT NULL AND p.is_enable = 1 AND p.show_menu != 0 GROUP BY f.parent_id;
Parameters:
[] |
|
0.27 ms (0.00%) |
1 |
SELECT i.id AS iId, i.url AS iUrl, i.name AS iName, i.alt AS iAlt, i.file AS iFile, i.status AS iStatus, i.file_size_x AS iFileSizeX, i.file_size_y AS iFileSizeY, i.file_size_z_x AS iFileSizeZX, i.file_size_z_y AS iFileSizeZY, i.file_size_hd_x AS iFileSizeHdX, i.file_size_hd_y AS iFileSizeHdY, i.file_size_shd_x AS iFileSizeShdX, i.file_size_shd_y AS iFileSizeShdY, i.file_size4k_x AS iFileSize4kX, i.file_size4k_y AS iFileSize4kY, c.id AS cId, c.url AS cUrl, c.status AS cStatus, c.name AS cName, c.alternate_name AS cAName, c.pr_min_euro AS prMinEuro, c.pr_min_euro_de AS prMinEuroDe, c.pr_min_euro_fr AS prMinEuroFr, c.pr_min_euro_it AS prMinEuroIt, c.pr_min_euro_be AS prMinEuroBe, c.pr_min_euro_ie AS prMinEuroIe, c.pr_min_euro_nl AS prMinEuroNl, c.pr_min_euro_es AS prMinEuroEs, c.pr_min_rue AS prMinRUB, c.pr_min_rue AS prMinRUE, c.pr_min_gbp AS prMinGBP, c.pr_min_gbe AS prMinGBE, c.pr_min_usd AS prMinUSD, c.pr_min_use AS prMinUSE, c.pr_min_f_usd AS prMinFUSD, c.pr_min_f_use AS prMinFUSE, c.pr_min_chf AS prMinCHF, c.pr_min_che AS prMinCHE, c.pr_min_sek AS prMinSEK, c.pr_min_see AS prMinSEE, c.pr_min_dkk AS prMinDKK, c.pr_min_dke AS prMinDKE, c.pr_min_nok AS prMinNOK, c.pr_min_noe AS prMinNOE, c.pr_min_pln AS prMinPLN, c.pr_min_ple AS prMinPLE, c.pr_min_cad AS prMinCAD, c.pr_min_cae AS prMinCAE, c.pr_min_f_cad AS prMinEuroFCAD, c.pr_min_f_cae AS prMinEuroFCAE, f.id AS fId, f.url AS fUrl, f.status AS fStatus, f.name AS fName, f.alternate_name AS fAName, f.suspended AS fSuspended, a.id AS itemId, lc.id AS lcId, lc.code AS lcCode, lc.alias AS lcAlias, la.id AS laId, la.alias AS laAlias, lst.id AS lstId, lst.alias AS lstAlias, lt.id AS ltId, lt.alias AS ltAlias, (SELECT COUNT(ii.idea_id) FROM `idea_interior` ii WHERE `ii`.`interior_id` = `i`.id) AS ideaCount FROM interior i LEFT JOIN collection c ON c.id = i.collection LEFT JOIN factory f ON f.id = c.factory LEFT JOIN interior_article iat ON iat.interior_id = i.id LEFT JOIN article a ON a.id = iat.article_id LEFT JOIN list_country lc ON lc.id = f.country LEFT JOIN interior_apply ia ON ia.interior_id = i.id LEFT JOIN list_apply la ON la.id = ia.apply_id LEFT JOIN interior_texture it ON it.interior_id = i.id LEFT JOIN list_texture lt ON lt.id = it.texture_id LEFT JOIN interior_style ist ON ist.interior_id = i.id LEFT JOIN list_style lst ON lst.id = ist.style_id WHERE c.id = 3244923 AND i.status = 1 AND i.id IN (165674)
Parameters:
[] |
|
0.27 ms (0.00%) |
1 |
SELECT l0_.`id` AS id_0, l0_.`name` AS name_1, l0_.`alias` AS alias_2, a1_.`id` AS id_3, a1_.`price_euro` AS price_euro_4, a1_.`price_mq_euro` AS price_mq_euro_5, a1_.`price_euro_de` AS price_euro_de_6, a1_.`price_mq_euro_de` AS price_mq_euro_de_7, a1_.`price_euro_at` AS price_euro_at_8, a1_.`price_mq_euro_at` AS price_mq_euro_at_9, a1_.`price_euro_fi` AS price_euro_fi_10, a1_.`price_mq_euro_fi` AS price_mq_euro_fi_11, a1_.`price_euro_fr` AS price_euro_fr_12, a1_.`price_mq_euro_fr` AS price_mq_euro_fr_13, a1_.`price_euro_it` AS price_euro_it_14, a1_.`price_mq_euro_it` AS price_mq_euro_it_15, a1_.`price_euro_be` AS price_euro_be_16, a1_.`price_mq_euro_be` AS price_mq_euro_be_17, a1_.`price_euro_ie` AS price_euro_ie_18, a1_.`price_mq_euro_ie` AS price_mq_euro_ie_19, a1_.`price_euro_nl` AS price_euro_nl_20, a1_.`price_mq_euro_nl` AS price_mq_euro_nl_21, a1_.`price_euro_es` AS price_euro_es_22, a1_.`price_mq_euro_es` AS price_mq_euro_es_23, a1_.`price_rub` AS price_rub_24, a1_.`price_rue` AS price_rue_25, a1_.`price_mq_rub` AS price_mq_rub_26, a1_.`price_mq_rue` AS price_mq_rue_27, a1_.`price_gbp` AS price_gbp_28, a1_.`price_gbe` AS price_gbe_29, a1_.`price_mq_gbp` AS price_mq_gbp_30, a1_.`price_mq_gbe` AS price_mq_gbe_31, a1_.`price_usd` AS price_usd_32, a1_.`price_use` AS price_use_33, a1_.`price_fq_usd` AS price_fq_usd_34, a1_.`price_fq_use` AS price_fq_use_35, a1_.`price_mq_usd` AS price_mq_usd_36, a1_.`price_mq_use` AS price_mq_use_37, a1_.`price_chf` AS price_chf_38, a1_.`price_che` AS price_che_39, a1_.`price_mq_chf` AS price_mq_chf_40, a1_.`price_mq_che` AS price_mq_che_41, a1_.`price_sek` AS price_sek_42, a1_.`price_see` AS price_see_43, a1_.`price_mq_sek` AS price_mq_sek_44, a1_.`price_mq_see` AS price_mq_see_45, a1_.`price_dkk` AS price_dkk_46, a1_.`price_dke` AS price_dke_47, a1_.`price_mq_dkk` AS price_mq_dkk_48, a1_.`price_mq_dke` AS price_mq_dke_49, a1_.`price_nok` AS price_nok_50, a1_.`price_noe` AS price_noe_51, a1_.`price_mq_nok` AS price_mq_nok_52, a1_.`price_mq_noe` AS price_mq_noe_53, a1_.`price_pln` AS price_pln_54, a1_.`price_ple` AS price_ple_55, a1_.`price_mq_pln` AS price_mq_pln_56, a1_.`price_mq_ple` AS price_mq_ple_57, a1_.`price_cad` AS price_cad_58, a1_.`price_cae` AS price_cae_59, a1_.`price_fq_cad` AS price_fq_cad_60, a1_.`price_fq_cae` AS price_fq_cae_61, a1_.`price_mq_cad` AS price_mq_cad_62, a1_.`price_mq_cae` AS price_mq_cae_63 FROM `article` a1_ LEFT JOIN `article_detail` a2_ ON a1_.id = a2_.article_id LEFT JOIN `list_measure` l0_ ON a1_.measure = l0_.id WHERE a1_.collection = ? AND a1_.`price_euro` > 0 AND a1_.delivery <> 6 AND a2_.`file` IS NOT NULL AND l0_.`alias` = ? ORDER BY a1_.`price_euro` ASC LIMIT 1
Parameters:
[ 3244923 "measure_mq" ] |
|
0.27 ms (0.00%) |
1 |
SELECT c0_.`id` AS id_0, c0_.`unid` AS unid_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, c0_.`url` AS url_6, c0_.`status` AS status_7, c0_.`type` AS type_8, c0_.`typeSet` AS typeSet_9, c0_.`pc_as_m` AS pc_as_m_10, c0_.`publish_date` AS publish_date_11, c0_.`update_date` AS update_date_12, c0_.`archive` AS archive_13, c0_.`pr_min_euro` AS pr_min_euro_14, c0_.`pr_min_euro_de` AS pr_min_euro_de_15, c0_.`pr_min_euro_at` AS pr_min_euro_at_16, c0_.`pr_min_euro_fi` AS pr_min_euro_fi_17, c0_.`pr_min_euro_fr` AS pr_min_euro_fr_18, c0_.`pr_min_euro_it` AS pr_min_euro_it_19, c0_.`pr_min_euro_be` AS pr_min_euro_be_20, c0_.`pr_min_euro_ie` AS pr_min_euro_ie_21, c0_.`pr_min_euro_nl` AS pr_min_euro_nl_22, c0_.`pr_min_euro_es` AS pr_min_euro_es_23, c0_.`pr_min_rub` AS pr_min_rub_24, c0_.`pr_min_rue` AS pr_min_rue_25, c0_.`pr_min_gbp` AS pr_min_gbp_26, c0_.`pr_min_gbe` AS pr_min_gbe_27, c0_.`pr_min_usd` AS pr_min_usd_28, c0_.`pr_min_use` AS pr_min_use_29, c0_.`pr_min_f_usd` AS pr_min_f_usd_30, c0_.`pr_min_f_use` AS pr_min_f_use_31, c0_.`pr_min_chf` AS pr_min_chf_32, c0_.`pr_min_che` AS pr_min_che_33, c0_.`pr_min_sek` AS pr_min_sek_34, c0_.`pr_min_see` AS pr_min_see_35, c0_.`pr_min_dkk` AS pr_min_dkk_36, c0_.`pr_min_dke` AS pr_min_dke_37, c0_.`pr_min_nok` AS pr_min_nok_38, c0_.`pr_min_noe` AS pr_min_noe_39, c0_.`pr_min_pln` AS pr_min_pln_40, c0_.`pr_min_ple` AS pr_min_ple_41, c0_.`pr_min_cad` AS pr_min_cad_42, c0_.`pr_min_cae` AS pr_min_cae_43, c0_.`pr_min_f_cad` AS pr_min_f_cad_44, c0_.`pr_min_f_cae` AS pr_min_f_cae_45, c0_.`pr_min_ed` AS pr_min_ed_46, c0_.`important` AS important_47, c0_.`author` AS author_48, c0_.`author_id` AS author_id_49, c0_.`rating` AS rating_50, c0_.`header` AS header_51, c0_.`settings` AS settings_52, c0_.`fids` AS fids_53, c0_.`portal_unid` AS portal_unid_54, c0_.`accepted_at` AS accepted_at_55, c0_.`accept_state` AS accept_state_56, c0_.`description_edit` AS description_edit_57, c0_.`link_award` AS link_award_58, c0_.`awards` AS awards_59, c0_.`video` AS video_60, c0_.`stated_at` AS stated_at_61, c0_.`state` AS state_62, c0_.`description_state` AS description_state_63, c0_.`body_hide` AS body_hide_64, c0_.`release_year` AS release_year_65, c0_.`site` AS site_66, c0_.`show_main` AS show_main_67, c0_.`glue_url` AS glue_url_68, c0_.`accessible` AS accessible_69, c0_.`delivery_suspended` AS delivery_suspended_70, c0_.`process` AS process_71, c0_.`exhibition` AS exhibition_72, c0_.`test_access` AS test_access_73, c0_.`views` AS views_74, c0_.`comment_unid` AS comment_unid_75, c0_.`accesible_at` AS accesible_at_76, c0_.`created_at` AS created_at_77, c0_.`updated_at` AS updated_at_78, f1_.`id` AS id_79, f1_.`unid` AS unid_80, f1_.`name` AS name_81, f1_.`name_inv` AS name_inv_82, f1_.`url` AS url_83, f1_.`alternate_name` AS alternate_name_84, f1_.`description_ru` AS description_ru_85, f1_.`description_en` AS description_en_86, f1_.`description_it` AS description_it_87, f1_.`description_es` AS description_es_88, f1_.`description_fr` AS description_fr_89, f1_.`description_de` AS description_de_90, f1_.`description_pt` AS description_pt_91, f1_.`description_pl` AS description_pl_92, f1_.`description_nl` AS description_nl_93, f1_.`description_fi` AS description_fi_94, f1_.`description_ua` AS description_ua_95, f1_.`description_sv` AS description_sv_96, f1_.`description_no` AS description_no_97, f1_.`description_da` AS description_da_98, f1_.`description_zh` AS description_zh_99, f1_.`delivery_time` AS delivery_time_100, f1_.`not_regular` AS not_regular_101, f1_.`suspended` AS suspended_102, f1_.`status` AS status_103, f1_.`type` AS type_104, f1_.`discount` AS discount_105, f1_.`discount_date_start` AS discount_date_start_106, f1_.`discount_date_end` AS discount_date_end_107, f1_.`transcription` AS transcription_108, f1_.`cost_delivery` AS cost_delivery_109, f1_.`create_date` AS create_date_110, f1_.`is_accepted` AS is_accepted_111, f1_.`accepted_at` AS accepted_at_112, f1_.`accept_state` AS accept_state_113, f1_.`description_edit` AS description_edit_114, f1_.`stated_at` AS stated_at_115, f1_.`state` AS state_116, f1_.`description_state` AS description_state_117, f1_.`video` AS video_118, f1_.`parser_address` AS parser_address_119, f1_.`accessible` AS accessible_120, f1_.`sound` AS sound_121, f1_.`test_access` AS test_access_122, f1_.`total_ideas` AS total_ideas_123, f1_.`votes_submit` AS votes_submit_124, f1_.`votes_stars` AS votes_stars_125, f1_.`brand_link` AS brand_link_126, f1_.`brand_logo` AS brand_logo_127, f1_.`no_send_portl_message` AS no_send_portl_message_128, l2_.`id` AS id_129, l2_.`code` AS code_130, l2_.`locale` AS locale_131, l2_.`phone_code` AS phone_code_132, l2_.`phone_mask` AS phone_mask_133, l2_.`min_valid_phone_numbers` AS min_valid_phone_numbers_134, l2_.`zip_code_mask` AS zip_code_mask_135, l2_.`percent_vat` AS percent_vat_136, l2_.`name` AS name_137, l2_.`name_en` AS name_en_138, l2_.`alias` AS alias_139, l2_.`sort` AS sort_140, l2_.`count` AS count_141, l2_.`hide` AS hide_142, l2_.`important` AS important_143, l2_.`pay_pal_percent` AS pay_pal_percent_144, l2_.`pay_pal_percent_own` AS pay_pal_percent_own_145, l2_.`vat` AS vat_146, l2_.`pv_type` AS pv_type_147, l2_.`capital_timezone_diff` AS capital_timezone_diff_148, l2_.`capital` AS capital_149, l2_.`free_sample_delivery` AS free_sample_delivery_150, l2_.`units` AS units_151, l3_.`id` AS id_152, l3_.`source` AS source_153, l3_.`ru` AS ru_154, l3_.`en` AS en_155, l3_.`it` AS it_156, l3_.`es` AS es_157, l3_.`fr` AS fr_158, l3_.`de` AS de_159, l3_.`pl` AS pl_160, l3_.`pt` AS pt_161, l3_.`nl` AS nl_162, l3_.`fi` AS fi_163, l3_.`ua` AS ua_164, l3_.`sv` AS sv_165, l3_.`no` AS no_166, l3_.`da` AS da_167, l3_.`cn` AS cn_168, l3_.`zh` AS zh_169, l3_.`created_at` AS created_at_170, l3_.`updated_at` AS updated_at_171, l4_.`id` AS id_172, l4_.`source` AS source_173, l4_.`ru` AS ru_174, l4_.`en` AS en_175, l4_.`it` AS it_176, l4_.`es` AS es_177, l4_.`fr` AS fr_178, l4_.`de` AS de_179, l4_.`pl` AS pl_180, l4_.`pt` AS pt_181, l4_.`nl` AS nl_182, l4_.`fi` AS fi_183, l4_.`ua` AS ua_184, l4_.`sv` AS sv_185, l4_.`no` AS no_186, l4_.`da` AS da_187, l4_.`cn` AS cn_188, l4_.`zh` AS zh_189, l4_.`created_at` AS created_at_190, l4_.`updated_at` AS updated_at_191, l5_.`id` AS id_192, l5_.`source` AS source_193, l5_.`ru` AS ru_194, l5_.`en` AS en_195, l5_.`it` AS it_196, l5_.`es` AS es_197, l5_.`fr` AS fr_198, l5_.`de` AS de_199, l5_.`pl` AS pl_200, l5_.`pt` AS pt_201, l5_.`nl` AS nl_202, l5_.`fi` AS fi_203, l5_.`ua` AS ua_204, l5_.`sv` AS sv_205, l5_.`no` AS no_206, l5_.`da` AS da_207, l5_.`cn` AS cn_208, l5_.`zh` AS zh_209, l5_.`created_at` AS created_at_210, l5_.`updated_at` AS updated_at_211 FROM `collection` c0_ LEFT JOIN `factory` f1_ ON c0_.factory = f1_.id LEFT JOIN `list_country` l2_ ON f1_.country = l2_.id LEFT JOIN `locale_html` l3_ ON c0_.id = l3_.collection_body_id LEFT JOIN `locale_meta` l4_ ON c0_.id = l4_.collection_keywords_id LEFT JOIN `locale_meta` l5_ ON c0_.id = l5_.collection_description_id WHERE f1_.`status` > ? AND f1_.`url` = ? AND c0_.`url` = ?
Parameters:
[ 0 "cerdomus" "othello" ] |
|
0.25 ms (0.00%) |
1 |
SELECT i.id AS iId, i.url AS iUrl, i.name AS iName, i.alt AS iAlt, i.file AS iFile, i.status AS iStatus, i.file_size_x AS iFileSizeX, i.file_size_y AS iFileSizeY, i.file_size_z_x AS iFileSizeZX, i.file_size_z_y AS iFileSizeZY, i.file_size_hd_x AS iFileSizeHdX, i.file_size_hd_y AS iFileSizeHdY, i.file_size_shd_x AS iFileSizeShdX, i.file_size_shd_y AS iFileSizeShdY, i.file_size4k_x AS iFileSize4kX, i.file_size4k_y AS iFileSize4kY, c.id AS cId, c.url AS cUrl, c.status AS cStatus, c.name AS cName, c.alternate_name AS cAName, c.pr_min_euro AS prMinEuro, c.pr_min_euro_de AS prMinEuroDe, c.pr_min_euro_fr AS prMinEuroFr, c.pr_min_euro_it AS prMinEuroIt, c.pr_min_euro_be AS prMinEuroBe, c.pr_min_euro_ie AS prMinEuroIe, c.pr_min_euro_nl AS prMinEuroNl, c.pr_min_euro_es AS prMinEuroEs, c.pr_min_rue AS prMinRUB, c.pr_min_rue AS prMinRUE, c.pr_min_gbp AS prMinGBP, c.pr_min_gbe AS prMinGBE, c.pr_min_usd AS prMinUSD, c.pr_min_use AS prMinUSE, c.pr_min_f_usd AS prMinFUSD, c.pr_min_f_use AS prMinFUSE, c.pr_min_chf AS prMinCHF, c.pr_min_che AS prMinCHE, c.pr_min_sek AS prMinSEK, c.pr_min_see AS prMinSEE, c.pr_min_dkk AS prMinDKK, c.pr_min_dke AS prMinDKE, c.pr_min_nok AS prMinNOK, c.pr_min_noe AS prMinNOE, c.pr_min_pln AS prMinPLN, c.pr_min_ple AS prMinPLE, c.pr_min_cad AS prMinCAD, c.pr_min_cae AS prMinCAE, c.pr_min_f_cad AS prMinEuroFCAD, c.pr_min_f_cae AS prMinEuroFCAE, f.id AS fId, f.url AS fUrl, f.status AS fStatus, f.name AS fName, f.alternate_name AS fAName, f.suspended AS fSuspended, a.id AS itemId, lc.id AS lcId, lc.code AS lcCode, lc.alias AS lcAlias, la.id AS laId, la.alias AS laAlias, lst.id AS lstId, lst.alias AS lstAlias, lt.id AS ltId, lt.alias AS ltAlias, (SELECT COUNT(ii.idea_id) FROM `idea_interior` ii WHERE `ii`.`interior_id` = `i`.id) AS ideaCount FROM interior i LEFT JOIN collection c ON c.id = i.collection LEFT JOIN factory f ON f.id = c.factory LEFT JOIN interior_article iat ON iat.interior_id = i.id LEFT JOIN article a ON a.id = iat.article_id LEFT JOIN list_country lc ON lc.id = f.country LEFT JOIN interior_apply ia ON ia.interior_id = i.id LEFT JOIN list_apply la ON la.id = ia.apply_id LEFT JOIN interior_texture it ON it.interior_id = i.id LEFT JOIN list_texture lt ON lt.id = it.texture_id LEFT JOIN interior_style ist ON ist.interior_id = i.id LEFT JOIN list_style lst ON lst.id = ist.style_id WHERE c.id = 3244923 AND i.status = 1
Parameters:
[] |
|
0.24 ms (0.00%) |
1 |
SELECT COUNT(a0_.`id`) AS sclr_0 FROM `article` a0_ LEFT JOIN `article_detail` a1_ ON a0_.id = a1_.article_id WHERE a0_.collection = ? AND a0_.`price_euro` > 0 AND a0_.delivery <> 6 AND a1_.`file` IS NOT NULL
Parameters:
[
3244923
]
|
|
0.19 ms (0.00%) |
1 |
SELECT a0_.`id` AS id_0, f1_.`name_single_en` AS name_single_en_1, f1_.`name_single_it` AS name_single_it_2, f1_.`name_single_es` AS name_single_es_3, f1_.`name_single_fr` AS name_single_fr_4, f1_.`name_single_de` AS name_single_de_5, f1_.`name_single_pl` AS name_single_pl_6, f1_.`name_single_ua` AS name_single_ua_7, f1_.`name_single_ru` AS name_single_ru_8, f1_.`name_single_sv` AS name_single_sv_9, f1_.`name_single_da` AS name_single_da_10 FROM `article` a0_ LEFT JOIN `collection` c2_ ON a0_.collection = c2_.id LEFT JOIN collection_filters c4_ ON c2_.id = c4_.collection_id LEFT JOIN `filters` f3_ ON f3_.id = c4_.filter_id LEFT JOIN `filter_pages` f1_ ON f3_.page_id = f1_.id INNER JOIN `filter_groups` f5_ ON f3_.group_id = f5_.id AND (f5_.`id` = 419) WHERE a0_.`id` IN (?)
Parameters:
[
[
154540370
]
]
|
|
0.18 ms (0.00%) |
1 |
SELECT a0_.`id` AS id_0 FROM `article` a0_ LEFT JOIN `article_detail` a1_ ON a0_.id = a1_.article_id WHERE a0_.delivery <> 6 AND a0_.collection = ? AND a0_.`price_euro` > 0 AND a1_.`file` IS NOT NULL
Parameters:
[
3244923
]
|
|
0.18 ms (0.00%) |
2 |
SELECT i0_.`id` AS id_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` = ? GROUP BY i0_.`id`
Parameters:
[
"877eefdcd1fcba26849ec85f1e351fdded2786e4c12e95be521cdbac823550b5"
]
|
|
0.15 ms (0.00%) |
1 |
SELECT l0_.`id` AS id_0, l0_.`name` AS name_1, l0_.`alias` AS alias_2, l0_.`sort` AS sort_3, l0_.`count` AS count_4, l0_.`hide` AS hide_5, l0_.`important` AS important_6 FROM `list_material` l0_ ORDER BY l0_.`sort` DESC, l0_.`name` ASC
Parameters:
[] |
|
0.12 ms (0.00%) |
1 |
SELECT c0_.`id` AS id_0, c0_.`rating` AS rating_1 FROM `collection` c0_ WHERE c0_.`id` IN (3244923)
Parameters:
[] |
|
0.12 ms (0.00%) |
1 |
SELECT f2.id, f2.name, f2.old_command, f2.old_id, GROUP_CONCAT(f.id) AS ids, GROUP_CONCAT(f.old_id) AS old_ids FROM `filters` f LEFT JOIN filters f2 ON f.parent_id = f2.id LEFT JOIN filter_params p ON f.param_id = p.id WHERE f.parent_id IS NOT NULL AND p.is_enable = 1 AND p.show_menu_advanced != 0 GROUP BY f.parent_id;
Parameters:
[] |
|
0.11 ms (0.00%) |
1 |
SELECT a0_.`id` AS id_0, f1_.`name` AS name_1 FROM `article` a0_ LEFT JOIN `collection` c2_ ON a0_.collection = c2_.id LEFT JOIN collection_filters c3_ ON c2_.id = c3_.collection_id LEFT JOIN `filters` f1_ ON f1_.id = c3_.filter_id INNER JOIN `filter_groups` f4_ ON f1_.group_id = f4_.id AND (f4_.`id` = 417 AND f1_.`id` <> 10546) WHERE a0_.`id` IN (?)
Parameters:
[
[
154540370
]
]
|
|
0.11 ms (0.00%) |
1 |
SELECT a0_.`id` AS id_0, f1_.`name` AS name_1 FROM `article` a0_ LEFT JOIN `collection` c2_ ON a0_.collection = c2_.id LEFT JOIN collection_filters c3_ ON c2_.id = c3_.collection_id LEFT JOIN `filters` f1_ ON f1_.id = c3_.filter_id INNER JOIN `filter_groups` f4_ ON f1_.group_id = f4_.id AND (f4_.`id` = 420) WHERE a0_.`id` IN (?)
Parameters:
[
[
154540370
]
]
|
|
0.11 ms (0.00%) |
1 |
SELECT DISTINCT a0_.`id` AS id_0, l1_.`alias` AS alias_1 FROM `article` a0_ LEFT JOIN interior_article i3_ ON a0_.id = i3_.article_id LEFT JOIN `interior` i2_ ON i2_.id = i3_.interior_id INNER JOIN interior_apply i4_ ON i2_.id = i4_.interior_id INNER JOIN `list_apply` l1_ ON l1_.id = i4_.apply_id WHERE a0_.`id` IN (?)
Parameters:
[
[
154540370
]
]
|
|
0.10 ms (0.00%) |
1 |
SELECT a0_.`id` AS id_0, l1_.`alias` AS alias_1 FROM `article` a0_ INNER JOIN article_texture a2_ ON a0_.id = a2_.article_id INNER JOIN `list_texture` l1_ ON l1_.id = a2_.texture_id WHERE a0_.`id` IN (?)
Parameters:
[
[
154540370
]
]
|
|
0.10 ms (0.00%) |
1 |
SELECT a0_.`id` AS id_0, l1_.`alias` AS alias_1 FROM `article` a0_ INNER JOIN article_surface a2_ ON a0_.id = a2_.article_id INNER JOIN `list_surface` l1_ ON l1_.id = a2_.surface_id WHERE a0_.`id` IN (?)
Parameters:
[
[
154540370
]
]
|
|
0.10 ms (0.00%) |
1 |
SELECT a0_.`id` AS id_0, l1_.`alias` AS alias_1 FROM `article` a0_ INNER JOIN article_color a2_ ON a0_.id = a2_.article_id INNER JOIN `list_color` l1_ ON l1_.id = a2_.color_id WHERE a0_.`id` IN (?)
Parameters:
[
[
154540370
]
]
|
|
0.10 ms (0.00%) |
1 |
SELECT a0_.`id` AS id_0, l1_.`alias` AS alias_1 FROM `article` a0_ INNER JOIN article_motiv a2_ ON a0_.id = a2_.article_id INNER JOIN `list_motiv` l1_ ON l1_.id = a2_.motiv_id WHERE a0_.`id` IN (?)
Parameters:
[
[
154540370
]
]
|
|
0.10 ms (0.00%) |
1 |
SELECT a0_.`id` AS id_0, l1_.`alias` AS alias_1 FROM `article` a0_ INNER JOIN article_style a2_ ON a0_.id = a2_.article_id INNER JOIN `list_style` l1_ ON l1_.id = a2_.style_id WHERE a0_.`id` IN (?)
Parameters:
[
[
154540370
]
]
|
|
0.10 ms (0.00%) |
1 |
SELECT t0.`id` AS id_1, t0.`name` AS name_2, t0.`alias` AS alias_3, t0.`sort` AS sort_4, t0.`count` AS count_5, t0.`hide` AS hide_6, t0.`important` AS important_7 FROM `list_measure` t0 WHERE t0.`hide` = ?
Parameters:
[
0
]
|
|
0.10 ms (0.00%) |
1 |
SELECT COUNT(i0_.`id`) AS sclr_0 FROM `interior` i0_ WHERE i0_.`status` = 1 AND i0_.collection = ? AND i0_.`id` IN (?)
Parameters:
[ 3244923 [ 165674 ] ] |
|
0.10 ms (0.00%) |
1 |
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:
[
"gi"
]
|
|
0.09 ms (0.00%) |
1 |
SELECT t0.`id` AS id_1, t0.`reviewId` AS reviewId_2, t0.`referenceId` AS referenceId_3, t0.`conversationId` AS conversationId_4, t0.`p_id` AS p_id_5, t0.`sku` AS sku_6, t0.`gtin` AS gtin_7, t0.`mpn` AS mpn_8, t0.`url` AS url_9, t0.`star` AS star_10, t0.`score` AS score_11, t0.`date` AS date_12, t0.`created_at` AS created_at_13, t0.`content` AS content_14, t0.`username` AS username_15, t0.`country` AS country_16, t0.`locale` AS locale_17, t0.`language` AS language_18, t0.`state` AS state_19, t0.`unid_theme` AS unid_theme_20, t0.`send_portal_date` AS send_portal_date_21, t0.`answer` AS answer_22, t0.`manager` AS manager_23, t0.`is_anonymous` AS is_anonymous_24, t0.`is_collection_review` AS is_collection_review_25, t0.article_id AS article_id_26, t0.collection_id AS collection_id_27, t0.order_id AS order_id_28, t0.user_id AS user_id_29 FROM `product_reviews_cache` t0 WHERE t0.collection_id = ? ORDER BY t0.`id` DESC
Parameters:
[
3244923
]
|
|
0.08 ms (0.00%) |
1 |
SELECT COUNT(i0_.`id`) AS sclr_0 FROM `interior` i0_ WHERE i0_.`status` = 1 AND i0_.collection = ?
Parameters:
[
3244923
]
|
|
0.00 ms (0.00%) |
1 |
SELECT COUNT(c0_.`id`) AS sclr_0 FROM `comment_refact` c0_ LEFT JOIN `user` u1_ ON c0_.user_id = u1_.id WHERE c0_.`locale` = ? AND c0_.`category` = ? AND c0_.`commentable_unid` = ? AND (u1_.`foreign_alias` IS NULL OR u1_.`foreign_alias` <> ?)
Parameters:
[ "en" 1 "14797990365833F0FC65BBB147979903" "" ] |
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\Article | No errors. |
| WebBundle\Entity\BuyOrder | No errors. |
| WebBundle\Entity\FilterEntity | No errors. |
| WebBundle\Entity\Idea | No errors. |
| WebBundle\Entity\Interior | No errors. |
| WebBundle\Entity\Publication | No errors. |
| WebBundle\Entity\Visit | No errors. |
| WebBundle\Entity\LastUrlEntity | No errors. |
| WebBundle\Entity\Collection | No errors. |
| WebBundle\Entity\ProductReviewsCache | No errors. |
| WebBundle\Entity\ReviewsCache | No errors. |
| WebBundle\Entity\ListCountry | No errors. |
| WebBundle\Entity\Factory | No errors. |
| WebBundle\Entity\CollectionAlsoViewed | No errors. |
| WebBundle\Entity\InteriorHistory | 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. |
| FlexApp\Entity\ConsultantEntity | No errors. |
| WebBundle\Entity\LocaleHtmlEntity | No errors. |
| WebBundle\Entity\LocaleMetaEntity | No errors. |
| FlexApp\Entity\GeoCountryEntity | No errors. |
| WebBundle\Entity\ListApply | No errors. |
| WebBundle\Entity\ListStyle | No errors. |
| WebBundle\Entity\ListTexture | No errors. |
| WebBundle\Entity\ListMeasure | No errors. |
| WebBundle\Entity\ListMaterial | No errors. |
| WebBundle\Entity\BuyOrderArticle | No errors. |
| FlexApp\Entity\StatsEntity | No errors. |
| FlexApp\Entity\CommentEntity | No errors. |
oneC entity manager
No loaded entities.
logs entity manager
No loaded entities.