Query Metrics
42
Database Queries
25
Different statements
262.84 ms
Query time
0
Invalid entities
Grouped Statements
default connection
Time▼ | Count | Info |
---|---|---|
211.72 ms (0.00%) |
2 |
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 ] |
10.42 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 FROM `collection` c0_ INNER JOIN `factory` f1_ ON c0_.factory = f1_.id INNER JOIN `list_country` l2_ ON f1_.country = l2_.id WHERE f1_.`url` = ? AND c0_.`url` = ? AND c0_.`status` IN (?) AND (c0_.`test_access` IS NULL OR c0_.`test_access` = 0) AND (f1_.`test_access` IS NULL OR f1_.`test_access` = 0) LIMIT 1
Parameters:
[ "gigacer" "tele" [ 1 2 3 7 4 ] ] |
7.11 ms (0.00%) |
1 |
SELECT a.id, a.code, a.name, a.not_sample, a.alternate_name, REPLACE(a.file, "~q~", "'") AS FILE, a.express_sample, a.variant_image, a.size_x, a.size_y, a.size_z, a.file_size2_x, a.file_size2_y, a.file_size3_x, a.file_size3_y, a.file_size8_x, a.file_size8_y, a.type_constraint, a.packaging_count, a.packaging_count_ft, a.packaging_count_pc, a.price_prx, a.pallet, a.pallet_ft, a.min_order, a.m2one_ps, a.multiple_pallet, a.urla, a.background_white, a.border_grey, a.image_setting, a.file_w, a.file_h, a.file_w4000, a.file_h4000, a.scheme, a.rotate, a.file_rotation, a.file_edit, a.comment_scheme_image, a.description_en, ad.id AS ad_id, ad.file AS ad_file, ad.picture_in_title AS ad_picture_in_title, ad.gtin AS ad_gtin, ad.file_size1_x AS ad_file_size1_x, ad.file_size1_y AS ad_file_size1_y, ad.file_size2_x AS ad_file_size2_x, ad.file_size2_y AS ad_file_size2_y, ad.file_size3_x AS ad_file_size3_x, ad.file_size3_y AS ad_file_size3_y, ad.file_size8_x AS ad_file_size8_x, ad.file_size8_y AS ad_file_size8_y, ad.file_size500_x AS ad_file_size500_x, ad.file_size500_y AS ad_file_size500_y, ad.file_size740_x AS ad_file_size740_x, ad.file_size740_y AS ad_file_size740_y, ad.file_size1_x AS ad_file_size1_x, ad.file_size1_y AS ad_file_size1_y, ad.description_en AS ad_description_en, ad.comment AS ad_comment, ad.file_edit AS ad_file_edit, ad.image_setting AS ad_image_setting, ad.file_w AS ad_file_w, ad.file_h AS ad_file_h, ad.file_w4000 AS ad_file_w4000, ad.file_h4000 AS ad_file_h4000, ad.comment_scheme_image AS ad_comment_scheme_image, ad.variant_image AS ad_variant_image, ad.file_rotation AS ad_file_rotation, ad.rotate AS ad_rotate, ad.type_painting AS ad_type_painting, ad.big_size_scheme AS ad_big_size_scheme, ld.id AS ld_id, lt.id AS lt_id, lt.alias AS lt_alias, lt.name AS lt_name, lms.id AS lms_id, lms.alias AS lms_alias, lms.name AS lms_name, lmt.id AS lmt_id, lmt.alias AS lmt_alias, lmt.name AS lmt_name, lsf.id AS lsf_id, lsf.alias AS lsf_alias, lsf.name AS lsf_name, lfc.id AS lfc_id, ltx.id AS ltx_id, ltx.alias AS ltx_alias, ltx.name AS ltx_name, ls.id AS ls_id, ls.alias AS ls_alias, ls.name AS ls_name, lsh.id AS lsh_id, lsh.alias AS lsh_alias, lsh.name AS lsh_name, llm.id AS llm_id, llm.alias AS llm_alias, llm.name AS llm_name, lmss.id AS lmss_id, lmss.alias AS lmss_alias, apd.id AS apd_id, apd.amount AS apd_amount, apd.amount_ft AS apd_amount_ft, apd.fold AS apd_fold, acl.id AS acl_id, acl.url AS acl_url, acl.name AS acl_name, acl.alternate_name AS acl_aname, acl.status AS acl_status, acl.process AS acl_process, acl.settings AS acl_settings, acf.id AS acf_id, acf.url AS acf_url, acf.name AS acf_name, acf.alternate_name AS acf_aname, acf.status AS acf_status, acf.suspended AS acf_suspended, acf.stated_at AS acf_stated_at, a.price_euro_de AS a_price_euro_de, a.price_mq_euro_de AS a_price_mq_euro_de, apd.price_euro_de AS apd_price_euro_de, acl.pr_min_euro_de AS acl_pr_min_euro_de, lt.id AS lt_id, aii.id AS aii_id, aii.file AS aii_file, aii.name AS aii_name, aii.status AS aii_status, aii.url AS aii_url, aii.file_size_x AS aii_file_size_x, aii.file_size_y AS aii_file_size_y, (SELECT COUNT(ii.idea_id) FROM `idea_interior` ii WHERE `ii`.`interior_id` = `aii`.id) AS ideaCount, aii_istls.id AS aii_istls_id, aii_istls.alias AS aii_istls_alias, aii_istlt.id AS aii_istlt_id, aii_istlt.alias AS aii_istlt_alias, iacl.id AS iacl_id, iacl.url AS iacl_url, iacl.name AS iacl_name, iacl.alternate_name AS iacl_aname, iacl.status AS iacl_status, iacl.process AS iacl_process, iacl.rating AS iacl_rating, iacl.settings AS iacl_settings, iacl.accessible AS iacl_accessible, iacf.id AS iacf_id, iacf.url AS iacf_url, iacf.name AS iacf_name, iacf.alternate_name AS iacf_aname, iacf.suspended AS iacf_suspended, iacf.status AS iacf_status, iacf.stated_at AS iacf_stated_at, iacflc.id AS iacflc_id, iacflc.code AS iacflc_code, iacflc.alias AS iacflc_alias, iacflc.name AS iacflc_name, iacl.pr_min_euro_de AS iacl_pr_min_euro_de, lcnt.id AS lcnt_id, lcnt.code AS lcnt_code, lcnt.alias AS lcnt_alias, lc.id AS lc_id, lc.name AS lc_name, lc.alias AS lc_alias FROM article a LEFT JOIN list_type lt ON a.type = lt.id LEFT JOIN list_delivery ld ON a.delivery = ld.id LEFT JOIN list_measure lms ON a.measure = lms.id LEFT JOIN list_material lmt ON a.material = lmt.id LEFT JOIN list_surface lsf ON a.surface = lsf.id LEFT JOIN article_price_discount apd ON a.id = apd.article AND apd.price_euro_de > 0 LEFT JOIN article_color ac ON a.id = ac.article_id LEFT JOIN list_color lc ON lc.id = ac.color_id LEFT JOIN article_factory_color afc ON a.id = afc.article_id LEFT JOIN list_factory_color lfc ON lfc.id = afc.factory_color_id LEFT JOIN article_texture at ON a.id = at.article_id LEFT JOIN list_texture ltx ON ltx.id = at.texture_id LEFT JOIN list_style ls ON a.style = ls.id LEFT JOIN collection acl ON acl.id = a.collection LEFT JOIN factory acf ON acf.id = acl.factory LEFT JOIN list_country lcnt ON lcnt.id = acf.country LEFT JOIN article_motiv alm ON a.id = alm.article_id LEFT JOIN list_motiv llm ON llm.id = alm.motiv_id LEFT JOIN list_shape lsh ON lsh.id = a.shape LEFT JOIN list_measure_size lmss ON a.measurement_size = lmss.id LEFT JOIN article_detail ad ON ad.article_id = a.id LEFT JOIN interior_article iarts ON iarts.article_id = a.id AND a.delivery <> 6 LEFT JOIN interior aii ON aii.id = iarts.interior_id AND a.delivery <> 6 AND aii.collection IS NOT NULL AND a.collection=aii.collection LEFT JOIN collection iacl ON iacl.id = aii.collection LEFT JOIN factory iacf ON iacf.id = iacl.factory LEFT JOIN list_country iacflc ON iacflc.id = iacf.country LEFT JOIN interior_style ist ON ist.interior_id = aii.id LEFT JOIN list_style aii_istls ON aii_istls.id = ist.style_id LEFT JOIN interior_texture istt ON istt.interior_id = aii.id LEFT JOIN list_texture aii_istlt ON aii_istlt.id = istt.texture_id WHERE a.collection IS NOT NULL AND (a.price_euro > 0 OR a.delivery = 6) AND ld.id <> 6 AND ad.file IS NOT NULL AND a.collection = '3250943' AND a.id IN ('0','630365658','630365653','630365643') ORDER BY lfc.name ASC, lt.sort DESC, a.size_x DESC, a.size_y DESC, apd.price_euro DESC, apd.amount DESC, a.scheme ASC, lc.id, lms.id, a.thick, a.id DESC
Parameters:
[] |
4.58 ms (0.00%) |
1 |
SELECT a.id, a.code, a.name, a.not_sample, a.alternate_name, REPLACE(a.file, "~q~", "'") AS FILE, a.express_sample, a.variant_image, a.size_x, a.size_y, a.size_z, a.file_size2_x, a.file_size2_y, a.file_size3_x, a.file_size3_y, a.file_size8_x, a.file_size8_y, a.type_constraint, a.packaging_count, a.packaging_count_ft, a.packaging_count_pc, a.price_prx, a.pallet, a.pallet_ft, a.min_order, a.m2one_ps, a.multiple_pallet, a.urla, a.background_white, a.border_grey, a.image_setting, a.file_w, a.file_h, a.file_w4000, a.file_h4000, a.scheme, a.rotate, a.file_rotation, a.file_edit, a.comment_scheme_image, a.description_en, ad.id AS ad_id, ad.file AS ad_file, ad.picture_in_title AS ad_picture_in_title, ad.gtin AS ad_gtin, ad.file_size1_x AS ad_file_size1_x, ad.file_size1_y AS ad_file_size1_y, ad.file_size2_x AS ad_file_size2_x, ad.file_size2_y AS ad_file_size2_y, ad.file_size3_x AS ad_file_size3_x, ad.file_size3_y AS ad_file_size3_y, ad.file_size8_x AS ad_file_size8_x, ad.file_size8_y AS ad_file_size8_y, ad.file_size500_x AS ad_file_size500_x, ad.file_size500_y AS ad_file_size500_y, ad.file_size740_x AS ad_file_size740_x, ad.file_size740_y AS ad_file_size740_y, ad.file_size1_x AS ad_file_size1_x, ad.file_size1_y AS ad_file_size1_y, ad.description_en AS ad_description_en, ad.comment AS ad_comment, ad.file_edit AS ad_file_edit, ad.image_setting AS ad_image_setting, ad.file_w AS ad_file_w, ad.file_h AS ad_file_h, ad.file_w4000 AS ad_file_w4000, ad.file_h4000 AS ad_file_h4000, ad.comment_scheme_image AS ad_comment_scheme_image, ad.variant_image AS ad_variant_image, ad.file_rotation AS ad_file_rotation, ad.rotate AS ad_rotate, ad.type_painting AS ad_type_painting, ad.big_size_scheme AS ad_big_size_scheme, ld.id AS ld_id, lt.id AS lt_id, lt.alias AS lt_alias, lt.name AS lt_name, lms.id AS lms_id, lms.alias AS lms_alias, lms.name AS lms_name, lmt.id AS lmt_id, lmt.alias AS lmt_alias, lmt.name AS lmt_name, lsf.id AS lsf_id, lsf.alias AS lsf_alias, lsf.name AS lsf_name, lfc.id AS lfc_id, ltx.id AS ltx_id, ltx.alias AS ltx_alias, ltx.name AS ltx_name, ls.id AS ls_id, ls.alias AS ls_alias, ls.name AS ls_name, lsh.id AS lsh_id, lsh.alias AS lsh_alias, lsh.name AS lsh_name, llm.id AS llm_id, llm.alias AS llm_alias, llm.name AS llm_name, lmss.id AS lmss_id, lmss.alias AS lmss_alias, apd.id AS apd_id, apd.amount AS apd_amount, apd.amount_ft AS apd_amount_ft, apd.fold AS apd_fold, acl.id AS acl_id, acl.url AS acl_url, acl.name AS acl_name, acl.alternate_name AS acl_aname, acl.status AS acl_status, acl.process AS acl_process, acl.settings AS acl_settings, acf.id AS acf_id, acf.url AS acf_url, acf.name AS acf_name, acf.alternate_name AS acf_aname, acf.status AS acf_status, acf.suspended AS acf_suspended, acf.stated_at AS acf_stated_at, a.price_euro_de AS a_price_euro_de, a.price_mq_euro_de AS a_price_mq_euro_de, apd.price_euro_de AS apd_price_euro_de, acl.pr_min_euro_de AS acl_pr_min_euro_de, lcnt.id AS lcnt_id, lcnt.code AS lcnt_code, lcnt.alias AS lcnt_alias, lc.id AS lc_id, lc.name AS lc_name, lc.alias AS lc_alias FROM article a LEFT JOIN list_type lt ON a.type = lt.id LEFT JOIN list_delivery ld ON a.delivery = ld.id LEFT JOIN list_measure lms ON a.measure = lms.id LEFT JOIN list_material lmt ON a.material = lmt.id LEFT JOIN list_surface lsf ON a.surface = lsf.id LEFT JOIN article_price_discount apd ON a.id = apd.article AND apd.price_euro_de > 0 LEFT JOIN article_color ac ON a.id = ac.article_id LEFT JOIN list_color lc ON lc.id = ac.color_id LEFT JOIN article_factory_color afc ON a.id = afc.article_id LEFT JOIN list_factory_color lfc ON lfc.id = afc.factory_color_id LEFT JOIN article_texture at ON a.id = at.article_id LEFT JOIN list_texture ltx ON ltx.id = at.texture_id LEFT JOIN list_style ls ON a.style = ls.id LEFT JOIN collection acl ON acl.id = a.collection LEFT JOIN factory acf ON acf.id = acl.factory LEFT JOIN list_country lcnt ON lcnt.id = acf.country LEFT JOIN article_motiv alm ON a.id = alm.article_id LEFT JOIN list_motiv llm ON llm.id = alm.motiv_id LEFT JOIN list_shape lsh ON lsh.id = a.shape LEFT JOIN list_measure_size lmss ON a.measurement_size = lmss.id LEFT JOIN article_detail ad ON ad.article_id = a.id WHERE a.collection IS NOT NULL AND (a.price_euro > 0 OR a.delivery = 6) AND ld.id <> 6 AND ad.file IS NOT NULL AND a.collection = '3250943' AND a.id IN ('630365633','630365638','630365648','630365653','630365643','630365658') ORDER BY lfc.name ASC, lt.sort DESC, a.size_x DESC, a.size_y DESC, apd.price_euro DESC, apd.amount DESC, a.scheme ASC, lc.id, lms.id, a.thick, a.id DESC
Parameters:
[] |
4.47 ms (0.00%) |
1 |
SELECT a.id FROM article a LEFT JOIN list_type lt ON a.type = lt.id LEFT JOIN list_delivery ld ON a.delivery = ld.id LEFT JOIN list_measure lms ON a.measure = lms.id LEFT JOIN list_material lmt ON a.material = lmt.id LEFT JOIN list_surface lsf ON a.surface = lsf.id LEFT JOIN article_price_discount apd ON a.id = apd.article AND apd.price_euro_de > 0 LEFT JOIN article_color ac ON a.id = ac.article_id LEFT JOIN article_factory_color afc ON a.id = afc.article_id LEFT JOIN list_factory_color lfc ON lfc.id = afc.factory_color_id LEFT JOIN article_texture at ON a.id = at.article_id LEFT JOIN list_texture ltx ON ltx.id = at.texture_id LEFT JOIN list_style ls ON a.style = ls.id LEFT JOIN list_color lc ON lc.id = ac.color_id LEFT JOIN collection acl ON acl.id = a.collection LEFT JOIN factory acf ON acf.id = acl.factory LEFT JOIN list_country lcnt ON lcnt.id = acf.country LEFT JOIN article_motiv alm ON a.id = alm.article_id LEFT JOIN list_motiv llm ON llm.id = alm.motiv_id LEFT JOIN list_shape lsh ON lsh.id = a.shape LEFT JOIN article_detail ad ON ad.article_id = a.id WHERE a.collection IS NOT NULL AND (a.price_euro > 0 OR ld.id = 6) AND ld.id <> 6 AND ad.file IS NOT NULL AND a.collection = '3250943' GROUP BY a.id ORDER BY lfc.name ASC, lt.sort DESC, a.size_x DESC, a.size_y DESC, apd.price_euro DESC, apd.amount DESC, a.scheme ASC, lc.id, lms.id, a.thick, a.id DESC LIMIT 200000 OFFSET 0
Parameters:
[] |
4.38 ms (0.00%) |
2 |
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, l2_.`de` AS de_8, f3_.`name_menu_de` AS name_menu_de_9, f4_.`alt_name` AS alt_name_10, f5_.`count` AS count_11, f0_.`id` AS id_12, f0_.`name` AS name_13, f0_.`alt_name` AS alt_name_14, f0_.`left_menu` AS left_menu_15, f0_.`sort` AS sort_16, f0_.`important` AS important_17, f0_.`old_command` AS old_command_18, f0_.`old_id` AS old_id_19, f0_.`sub_key` AS sub_key_20, f0_.`parent_key` AS parent_key_21, f0_.`rank` AS rank_22, f0_.`icon` AS icon_23, f0_.`icon_url` AS icon_url_24, f0_.`logo` AS logo_25, f0_.`logo_url` AS logo_url_26, f0_.`created_at` AS created_at_27, f0_.`updated_at` AS updated_at_28, f6_.`id` AS id_29, f6_.`name` AS name_30, f6_.`alt_name` AS alt_name_31, f6_.`left_menu` AS left_menu_32, f6_.`sort` AS sort_33, f6_.`important` AS important_34, f6_.`old_command` AS old_command_35, f6_.`old_id` AS old_id_36, f6_.`sub_key` AS sub_key_37, f6_.`parent_key` AS parent_key_38, f6_.`rank` AS rank_39, f6_.`icon` AS icon_40, f6_.`icon_url` AS icon_url_41, f6_.`logo` AS logo_42, f6_.`logo_url` AS logo_url_43, f6_.`created_at` AS created_at_44, f6_.`updated_at` AS updated_at_45 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" ] ] |
2.90 ms (0.00%) |
2 |
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:
[
"a8f02828f51e1a8394ba579cab19c29c534fc276a0521032f2b167078096d6bd"
]
|
2.07 ms (0.00%) |
2 |
SELECT COUNT(v0_.`id`) AS sclr_0 FROM `visit` v0_ WHERE v0_.`token` = ? AND v0_.`url` <> '/.*catalog.*/'
Parameters:
[
"a8f02828f51e1a8394ba579cab19c29c534fc276a0521032f2b167078096d6bd"
]
|
1.98 ms (0.00%) |
3 |
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 `list_measure` l0_ ON a1_.measure = l0_.id WHERE a1_.`id` = ? AND l0_.`alias` = ? LIMIT 1
Parameters:
[ 630365653 "measure_mq" ] |
1.89 ms (0.00%) |
3 |
SELECT a0_.`id` AS id_0, b1_.`amount` AS amount_1, b2_.`name` AS name_2, b2_.`status` AS status_3, b2_.`bank_transfer_requested` AS bank_transfer_requested_4 FROM `buy_order` b2_ LEFT JOIN `buy_order_article` b1_ ON b2_.id = b1_.buy_order_id LEFT JOIN `article` a0_ ON b1_.article_id = a0_.id WHERE b2_.`status` IN (1, 2, 3) AND a0_.`id` <> '' AND b2_.`token` = ? AND b2_.`status` <> 12 ORDER BY b1_.`amount` DESC
Parameters:
[
"a8f02828f51e1a8394ba579cab19c29c534fc276a0521032f2b167078096d6bd"
]
|
1.73 ms (0.00%) |
3 |
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"
]
|
1.53 ms (0.00%) |
2 |
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:
[
"a8f02828f51e1a8394ba579cab19c29c534fc276a0521032f2b167078096d6bd"
]
|
1.26 ms (0.00%) |
3 |
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 `list_measure` l0_ ON a1_.measure = l0_.id WHERE a1_.`id` = ? LIMIT 1
Parameters:
[
630365653
]
|
1.00 ms (0.00%) |
1 |
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:
[
"a8f02828f51e1a8394ba579cab19c29c534fc276a0521032f2b167078096d6bd"
]
|
0.82 ms (0.00%) |
1 |
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:
[
"a8f02828f51e1a8394ba579cab19c29c534fc276a0521032f2b167078096d6bd"
]
|
0.72 ms (0.00%) |
2 |
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
]
|
0.68 ms (0.00%) |
2 |
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:
[
"a8f02828f51e1a8394ba579cab19c29c534fc276a0521032f2b167078096d6bd"
]
|
0.66 ms (0.00%) |
1 |
SELECT t0.`id` AS id_1, t0.`enable` AS enable_2, t0.`unid` AS unid_3, t0.`publish_date` AS publish_date_4, t0.`update_date` AS update_date_5, t0.`view` AS view_6, t0.`hide_countries` AS hide_countries_7, t0.author AS author_8, t9.`id` AS id_10, t9.`source` AS source_11, t9.`ru` AS ru_12, t9.`en` AS en_13, t9.`it` AS it_14, t9.`es` AS es_15, t9.`fr` AS fr_16, t9.`de` AS de_17, t9.`pl` AS pl_18, t9.`pt` AS pt_19, t9.`nl` AS nl_20, t9.`fi` AS fi_21, t9.`ua` AS ua_22, t9.`sv` AS sv_23, t9.`no` AS no_24, t9.`da` AS da_25, t9.`cn` AS cn_26, t9.`zh` AS zh_27, t9.`created_at` AS created_at_28, t9.`updated_at` AS updated_at_29, t9.email_title_id AS email_title_id_30, t9.publication_id AS publication_id_31, t9.static_page_title_id AS static_page_title_id_32, t9.exh_title_id AS exh_title_id_33, t9.filter_name_single_id AS filter_name_single_id_34, t9.filter_name_many_id AS filter_name_many_id_35, t9.filter_name_menu_id AS filter_name_menu_id_36, t37.`id` AS id_38, t37.`source` AS source_39, t37.`ru` AS ru_40, t37.`en` AS en_41, t37.`it` AS it_42, t37.`es` AS es_43, t37.`fr` AS fr_44, t37.`de` AS de_45, t37.`pl` AS pl_46, t37.`pt` AS pt_47, t37.`nl` AS nl_48, t37.`fi` AS fi_49, t37.`ua` AS ua_50, t37.`sv` AS sv_51, t37.`no` AS no_52, t37.`da` AS da_53, t37.`cn` AS cn_54, t37.`zh` AS zh_55, t37.`created_at` AS created_at_56, t37.`updated_at` AS updated_at_57, t37.email_body_id AS email_body_id_58, t37.publication_body_id AS publication_body_id_59, t37.static_page_body_id AS static_page_body_id_60, t37.collection_body_id AS collection_body_id_61, t37.trans_val_id AS trans_val_id_62, t37.exh_text_id AS exh_text_id_63, t37.exh_brand_text_id AS exh_brand_text_id_64, t37.exh_collection_text_id AS exh_collection_text_id_65, t37.filter_html_id AS filter_html_id_66, t67.`id` AS id_68, t67.`source` AS source_69, t67.`ru` AS ru_70, t67.`en` AS en_71, t67.`it` AS it_72, t67.`es` AS es_73, t67.`fr` AS fr_74, t67.`de` AS de_75, t67.`pl` AS pl_76, t67.`pt` AS pt_77, t67.`nl` AS nl_78, t67.`fi` AS fi_79, t67.`ua` AS ua_80, t67.`sv` AS sv_81, t67.`no` AS no_82, t67.`da` AS da_83, t67.`cn` AS cn_84, t67.`zh` AS zh_85, t67.`created_at` AS created_at_86, t67.`updated_at` AS updated_at_87, t67.publication_id AS publication_id_88, t67.filter_id AS filter_id_89, t67.exh_id AS exh_id_90, t91.`id` AS id_92, t91.`def` AS def_93, t91.`ru` AS ru_94, t91.`en` AS en_95, t91.`it` AS it_96, t91.`es` AS es_97, t91.`fr` AS fr_98, t91.`de` AS de_99, t91.`pl` AS pl_100, t91.`pt` AS pt_101, t91.`nl` AS nl_102, t91.`fi` AS fi_103, t91.`ua` AS ua_104, t91.`sv` AS sv_105, t91.`no` AS no_106, t91.`da` AS da_107, t91.`cn` AS cn_108, t91.`zh` AS zh_109, t91.`created_at` AS created_at_110, t91.`updated_at` AS updated_at_111, t91.publication_id AS publication_id_112, t91.exh_id AS exh_id_113, t114.`id` AS id_115, t114.`source` AS source_116, t114.`ru` AS ru_117, t114.`en` AS en_118, t114.`it` AS it_119, t114.`es` AS es_120, t114.`fr` AS fr_121, t114.`de` AS de_122, t114.`pl` AS pl_123, t114.`pt` AS pt_124, t114.`nl` AS nl_125, t114.`fi` AS fi_126, t114.`ua` AS ua_127, t114.`sv` AS sv_128, t114.`no` AS no_129, t114.`da` AS da_130, t114.`cn` AS cn_131, t114.`zh` AS zh_132, t114.`created_at` AS created_at_133, t114.`updated_at` AS updated_at_134, t114.static_page_title_id AS static_page_title_id_135, t114.static_page_keywords_id AS static_page_keywords_id_136, t114.static_page_description_id AS static_page_description_id_137, t114.collection_keywords_id AS collection_keywords_id_138, t114.collection_description_id AS collection_description_id_139, t114.blog_keywords_id AS blog_keywords_id_140, t114.blog_description_id AS blog_description_id_141, t114.exh_keywords_id AS exh_keywords_id_142, t114.exh_description_id AS exh_description_id_143, t144.`id` AS id_145, t144.`source` AS source_146, t144.`ru` AS ru_147, t144.`en` AS en_148, t144.`it` AS it_149, t144.`es` AS es_150, t144.`fr` AS fr_151, t144.`de` AS de_152, t144.`pl` AS pl_153, t144.`pt` AS pt_154, t144.`nl` AS nl_155, t144.`fi` AS fi_156, t144.`ua` AS ua_157, t144.`sv` AS sv_158, t144.`no` AS no_159, t144.`da` AS da_160, t144.`cn` AS cn_161, t144.`zh` AS zh_162, t144.`created_at` AS created_at_163, t144.`updated_at` AS updated_at_164, t144.static_page_title_id AS static_page_title_id_165, t144.static_page_keywords_id AS static_page_keywords_id_166, t144.static_page_description_id AS static_page_description_id_167, t144.collection_keywords_id AS collection_keywords_id_168, t144.collection_description_id AS collection_description_id_169, t144.blog_keywords_id AS blog_keywords_id_170, t144.blog_description_id AS blog_description_id_171, t144.exh_keywords_id AS exh_keywords_id_172, t144.exh_description_id AS exh_description_id_173, t174.`id` AS id_175, t174.`source` AS source_176, t174.`ru` AS ru_177, t174.`en` AS en_178, t174.`it` AS it_179, t174.`es` AS es_180, t174.`fr` AS fr_181, t174.`de` AS de_182, t174.`pl` AS pl_183, t174.`pt` AS pt_184, t174.`nl` AS nl_185, t174.`fi` AS fi_186, t174.`ua` AS ua_187, t174.`sv` AS sv_188, t174.`no` AS no_189, t174.`da` AS da_190, t174.`cn` AS cn_191, t174.`zh` AS zh_192, t174.`created_at` AS created_at_193, t174.`updated_at` AS updated_at_194, t174.blog_show_id AS blog_show_id_195, t174.blog_hide_single_id AS blog_hide_single_id_196, t174.static_page_status_show_id AS static_page_status_show_id_197, t174.static_page_comment_show_id AS static_page_comment_show_id_198, t174.filter_html_show_id AS filter_html_show_id_199, t174.exh_show_id AS exh_show_id_200, t174.exh_hide_single_id AS exh_hide_single_id_201, t202.`id` AS id_203, t202.`ru` AS ru_204, t202.`en` AS en_205, t202.`it` AS it_206, t202.`es` AS es_207, t202.`fr` AS fr_208, t202.`de` AS de_209, t202.`pl` AS pl_210, t202.`pt` AS pt_211, t202.`nl` AS nl_212, t202.`fi` AS fi_213, t202.`ua` AS ua_214, t202.`sv` AS sv_215, t202.`no` AS no_216, t202.`da` AS da_217, t202.`cn` AS cn_218, t202.`zh` AS zh_219, t202.`created_at` AS created_at_220, t202.`updated_at` AS updated_at_221, t202.publication_id AS publication_id_222, t202.exh_id AS exh_id_223, t224.`id` AS id_225, t224.`source` AS source_226, t224.`ru` AS ru_227, t224.`en` AS en_228, t224.`it` AS it_229, t224.`es` AS es_230, t224.`fr` AS fr_231, t224.`de` AS de_232, t224.`pl` AS pl_233, t224.`pt` AS pt_234, t224.`nl` AS nl_235, t224.`fi` AS fi_236, t224.`ua` AS ua_237, t224.`sv` AS sv_238, t224.`no` AS no_239, t224.`da` AS da_240, t224.`cn` AS cn_241, t224.`zh` AS zh_242, t224.`created_at` AS created_at_243, t224.`updated_at` AS updated_at_244, t224.blog_show_id AS blog_show_id_245, t224.blog_hide_single_id AS blog_hide_single_id_246, t224.static_page_status_show_id AS static_page_status_show_id_247, t224.static_page_comment_show_id AS static_page_comment_show_id_248, t224.filter_html_show_id AS filter_html_show_id_249, t224.exh_show_id AS exh_show_id_250, t224.exh_hide_single_id AS exh_hide_single_id_251 FROM `publication` t0 LEFT JOIN `locale_title` t9 ON t9.publication_id = t0.id LEFT JOIN `locale_html` t37 ON t37.publication_body_id = t0.id LEFT JOIN `locale_url` t67 ON t67.publication_id = t0.id LEFT JOIN `locale_preview` t91 ON t91.publication_id = t0.id LEFT JOIN `locale_meta` t114 ON t114.blog_keywords_id = t0.id LEFT JOIN `locale_meta` t144 ON t144.blog_description_id = t0.id LEFT JOIN `locale_bool` t174 ON t174.blog_show_id = t0.id LEFT JOIN `locale_status_translate` t202 ON t202.publication_id = t0.id LEFT JOIN `locale_bool` t224 ON t224.blog_hide_single_id = t0.id WHERE t0.`id` = ?
Parameters:
[
2232
]
|
0.57 ms (0.00%) |
2 |
SELECT b0_.`id` AS id_0 FROM `buy_order` b0_ WHERE b0_.`token` = ? AND b0_.`status` <> 12
Parameters:
[
"a8f02828f51e1a8394ba579cab19c29c534fc276a0521032f2b167078096d6bd"
]
|
0.57 ms (0.00%) |
1 |
SELECT t0.`id` AS id_1, t0.`code` AS code_2, t0.`name` AS name_3, t0.`alternate_name` AS alternate_name_4, t0.`urla` AS urla_5, t0.`file` AS file_6, t0.`size_x` AS size_x_7, t0.`size_y` AS size_y_8, t0.`size_gb_x` AS size_gb_x_9, t0.`size_gb_y` AS size_gb_y_10, t0.`size_tessera` AS size_tessera_11, t0.`file_size1_x` AS file_size1_x_12, t0.`file_size1_y` AS file_size1_y_13, t0.`file_size2_x` AS file_size2_x_14, t0.`file_size2_y` AS file_size2_y_15, t0.`file_size3_x` AS file_size3_x_16, t0.`file_size3_y` AS file_size3_y_17, t0.`file_size500_x` AS file_size500_x_18, t0.`file_size500_y` AS file_size500_y_19, t0.`file_size740_x` AS file_size740_x_20, t0.`file_size740_y` AS file_size740_y_21, t0.`file_size8_x` AS file_size8_x_22, t0.`file_size8_y` AS file_size8_y_23, t0.`pallet` AS pallet_24, t0.`pallet_ft` AS pallet_ft_25, t0.`type_constraint` AS type_constraint_26, t0.`multiple_pallet` AS multiple_pallet_27, t0.`min_order` AS min_order_28, t0.`price_euro` AS price_euro_29, t0.`price_mq_euro` AS price_mq_euro_30, t0.`price_euro_de` AS price_euro_de_31, t0.`price_mq_euro_de` AS price_mq_euro_de_32, t0.`price_euro_at` AS price_euro_at_33, t0.`price_mq_euro_at` AS price_mq_euro_at_34, t0.`price_euro_fi` AS price_euro_fi_35, t0.`price_mq_euro_fi` AS price_mq_euro_fi_36, t0.`price_euro_fr` AS price_euro_fr_37, t0.`price_mq_euro_fr` AS price_mq_euro_fr_38, t0.`price_euro_it` AS price_euro_it_39, t0.`price_mq_euro_it` AS price_mq_euro_it_40, t0.`price_euro_be` AS price_euro_be_41, t0.`price_mq_euro_be` AS price_mq_euro_be_42, t0.`price_euro_ie` AS price_euro_ie_43, t0.`price_mq_euro_ie` AS price_mq_euro_ie_44, t0.`price_euro_nl` AS price_euro_nl_45, t0.`price_mq_euro_nl` AS price_mq_euro_nl_46, t0.`price_euro_es` AS price_euro_es_47, t0.`price_mq_euro_es` AS price_mq_euro_es_48, t0.`price_rub` AS price_rub_49, t0.`price_rue` AS price_rue_50, t0.`price_mq_rub` AS price_mq_rub_51, t0.`price_mq_rue` AS price_mq_rue_52, t0.`price_gbp` AS price_gbp_53, t0.`price_gbe` AS price_gbe_54, t0.`price_mq_gbp` AS price_mq_gbp_55, t0.`price_mq_gbe` AS price_mq_gbe_56, t0.`price_usd` AS price_usd_57, t0.`price_use` AS price_use_58, t0.`price_fq_usd` AS price_fq_usd_59, t0.`price_fq_use` AS price_fq_use_60, t0.`price_mq_usd` AS price_mq_usd_61, t0.`price_mq_use` AS price_mq_use_62, t0.`price_chf` AS price_chf_63, t0.`price_che` AS price_che_64, t0.`price_mq_chf` AS price_mq_chf_65, t0.`price_mq_che` AS price_mq_che_66, t0.`price_sek` AS price_sek_67, t0.`price_see` AS price_see_68, t0.`price_mq_sek` AS price_mq_sek_69, t0.`price_mq_see` AS price_mq_see_70, t0.`price_dkk` AS price_dkk_71, t0.`price_dke` AS price_dke_72, t0.`price_mq_dkk` AS price_mq_dkk_73, t0.`price_mq_dke` AS price_mq_dke_74, t0.`price_nok` AS price_nok_75, t0.`price_noe` AS price_noe_76, t0.`price_mq_nok` AS price_mq_nok_77, t0.`price_mq_noe` AS price_mq_noe_78, t0.`price_pln` AS price_pln_79, t0.`price_ple` AS price_ple_80, t0.`price_mq_pln` AS price_mq_pln_81, t0.`price_mq_ple` AS price_mq_ple_82, t0.`price_cad` AS price_cad_83, t0.`price_cae` AS price_cae_84, t0.`price_fq_cad` AS price_fq_cad_85, t0.`price_fq_cae` AS price_fq_cae_86, t0.`price_mq_cad` AS price_mq_cad_87, t0.`price_mq_cae` AS price_mq_cae_88, t0.`thick` AS thick_89, t0.`weight` AS weight_90, t0.`packaging_count` AS packaging_count_91, t0.`packaging_count_ft` AS packaging_count_ft_92, t0.`packaging_count_pc` AS packaging_count_pc_93, t0.`m2one_ps` AS m2one_ps_94, t0.`description_ru` AS description_ru_95, t0.`description_en` AS description_en_96, t0.`description_it` AS description_it_97, t0.`description_es` AS description_es_98, t0.`description_fr` AS description_fr_99, t0.`description_de` AS description_de_100, t0.`description_pt` AS description_pt_101, t0.`description_pl` AS description_pl_102, t0.`description_nl` AS description_nl_103, t0.`description_fi` AS description_fi_104, t0.`description_ua` AS description_ua_105, t0.`description_sv` AS description_sv_106, t0.`description_no` AS description_no_107, t0.`description_da` AS description_da_108, t0.`description_cn` AS description_cn_109, t0.`scheme` AS scheme_110, t0.`sale_date` AS sale_date_111, t0.`thin_granite` AS thin_granite_112, t0.`glazed_granite` AS glazed_granite_113, t0.`pei` AS pei_114, t0.`is_grouped` AS is_grouped_115, t0.`is_rotate` AS is_rotate_116, t0.`price_prx` AS price_prx_117, t0.`background_white` AS background_white_118, t0.`border_grey` AS border_grey_119, t0.`is_edit` AS is_edit_120, t0.`edited_at` AS edited_at_121, t0.`comment` AS comment_122, t0.`file_edit` AS file_edit_123, t0.`image_setting` AS image_setting_124, t0.`file_w` AS file_w_125, t0.`file_h` AS file_h_126, t0.`file_w4000` AS file_w4000_127, t0.`file_h4000` AS file_h4000_128, t0.`size_z` AS size_z_129, t0.`size_gb_z` AS size_gb_z_130, t0.`repeat_number` AS repeat_number_131, t0.`size_big` AS size_big_132, t0.`delivery_suspended` AS delivery_suspended_133, t0.`poddon_x` AS poddon_x_134, t0.`poddon_y` AS poddon_y_135, t0.`poddon_z` AS poddon_z_136, t0.`module` AS module_137, t0.`tessera_size_x` AS tessera_size_x_138, t0.`tessera_size_y` AS tessera_size_y_139, t0.`tessera_size_z` AS tessera_size_z_140, t0.`poddon_count` AS poddon_count_141, t0.`poddon_weight` AS poddon_weight_142, t0.`added_to_cart` AS added_to_cart_143, t0.`sold_out` AS sold_out_144, t0.`sold_out_vol` AS sold_out_vol_145, t0.`swimming_pool` AS swimming_pool_146, t0.`can_select_substrate` AS can_select_substrate_147, t0.`designer` AS designer_148, t0.`designer_id` AS designer_id_149, t0.`mosaic_effect` AS mosaic_effect_150, t0.`not_sample` AS not_sample_151, t0.`express_sample` AS express_sample_152, t0.`description_edit` AS description_edit_153, t0.`comment_scheme_image` AS comment_scheme_image_154, t0.`variant_image` AS variant_image_155, t0.`square` AS square_156, t0.`fix_big_size` AS fix_big_size_157, t0.`overflow_sink` AS overflow_sink_158, t0.`drain_size_sink` AS drain_size_sink_159, t0.`faucet_hole_sink` AS faucet_hole_sink_160, t0.`rotate` AS rotate_161, t0.`dyed_in_mass` AS dyed_in_mass_162, t0.`durability_class` AS durability_class_163, t0.`is_comment_ru` AS is_comment_ru_164, t0.`file_rotation` AS file_rotation_165, t0.`created_at` AS created_at_166, t0.`updated_at` AS updated_at_167, t0.collection AS collection_168, t0.newCollection AS newCollection_169, t0.type AS type_170, t0.measure AS measure_171, t0.surface AS surface_172, t0.pr_status AS pr_status_173, t0.category_price AS category_price_174, t0.edge_type AS edge_type_175, t0.using AS using_176, t0.shape AS shape_177, t0.material AS material_178, t0.delivery AS delivery_179, t0.sliding AS sliding_180, t0.off_shade AS off_shade_181, t0.style AS style_182, t0.repeat_draw AS repeat_draw_183, t0.measurement_size AS measurement_size_184, t185.`id` AS id_186, t185.`del` AS del_187, t185.`size_x_one` AS size_x_one_188, t185.`size_y_one` AS size_y_one_189, t185.`type_one` AS type_one_190, t185.`amount_one` AS amount_one_191, t185.`size_x_two` AS size_x_two_192, t185.`size_y_two` AS size_y_two_193, t185.`type_two` AS type_two_194, t185.`amount_two` AS amount_two_195, t185.item_id AS item_id_196, t185.item_one AS item_one_197, t185.item_two AS item_two_198, t0.installation_type AS installation_type_199, t0.meth_laying AS meth_laying_200, t201.`id` AS id_202, t201.`picture_in_title` AS picture_in_title_203, t201.`gtin` AS gtin_204, t201.`file` AS file_205, t201.`file_size1_x` AS file_size1_x_206, t201.`file_size1_y` AS file_size1_y_207, t201.`file_size2_x` AS file_size2_x_208, t201.`file_size2_y` AS file_size2_y_209, t201.`file_size3_x` AS file_size3_x_210, t201.`file_size3_y` AS file_size3_y_211, t201.`file_size8_x` AS file_size8_x_212, t201.`file_size8_y` AS file_size8_y_213, t201.`file_size500_x` AS file_size500_x_214, t201.`file_size500_y` AS file_size500_y_215, t201.`file_size740_x` AS file_size740_x_216, t201.`file_size740_y` AS file_size740_y_217, t201.`description_ru` AS description_ru_218, t201.`description_en` AS description_en_219, t201.`description_it` AS description_it_220, t201.`description_es` AS description_es_221, t201.`description_fr` AS description_fr_222, t201.`description_de` AS description_de_223, t201.`description_pt` AS description_pt_224, t201.`description_pl` AS description_pl_225, t201.`description_nl` AS description_nl_226, t201.`description_fi` AS description_fi_227, t201.`description_ua` AS description_ua_228, t201.`description_sv` AS description_sv_229, t201.`description_no` AS description_no_230, t201.`description_da` AS description_da_231, t201.`description_edit` AS description_edit_232, t201.`comment` AS comment_233, t201.`file_edit` AS file_edit_234, t201.`image_setting` AS image_setting_235, t201.`file_w` AS file_w_236, t201.`file_h` AS file_h_237, t201.`file_w4000` AS file_w4000_238, t201.`file_h4000` AS file_h4000_239, t201.`comment_scheme_image` AS comment_scheme_image_240, t201.`variant_image` AS variant_image_241, t201.`file_rotation` AS file_rotation_242, t201.`rotate` AS rotate_243, t201.`type_painting` AS type_painting_244, t201.`big_size_scheme` AS big_size_scheme_245, t201.article_id AS article_id_246, t0.draw AS draw_247 FROM `article` t0 LEFT JOIN `sample` t185 ON t185.item_id = t0.id LEFT JOIN `article_detail` t201 ON t201.article_id = t0.id WHERE t0.`urla` = ? AND t0.collection = ? LIMIT 1
Parameters:
[ "tele-primavera-60x120" 3250943 ] |
0.52 ms (0.00%) |
2 |
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:
[] |
0.41 ms (0.00%) |
1 |
SELECT t0.`id` AS id_1, t0.`token` AS token_2, t0.`name` AS name_3, t0.`create_date` AS create_date_4, t0.`update_date` AS update_date_5, t0.`process` AS process_6, t0.user_id AS user_id_7 FROM `idea` t0 WHERE t0.`token` = ? ORDER BY t0.`update_date` DESC
Parameters:
[
"a8f02828f51e1a8394ba579cab19c29c534fc276a0521032f2b167078096d6bd"
]
|
0.29 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:
[
3250943
]
|
0.28 ms (0.00%) |
1 |
SELECT p0_.`id` AS id_0, p0_.`reviewId` AS reviewId_1, p0_.`referenceId` AS referenceId_2, p0_.`conversationId` AS conversationId_3, p0_.`p_id` AS p_id_4, p0_.`sku` AS sku_5, p0_.`gtin` AS gtin_6, p0_.`mpn` AS mpn_7, p0_.`url` AS url_8, p0_.`star` AS star_9, p0_.`score` AS score_10, p0_.`date` AS date_11, p0_.`created_at` AS created_at_12, p0_.`content` AS content_13, p0_.`username` AS username_14, p0_.`country` AS country_15, p0_.`locale` AS locale_16, p0_.`language` AS language_17, p0_.`state` AS state_18, p0_.`unid_theme` AS unid_theme_19, p0_.`send_portal_date` AS send_portal_date_20, p0_.`answer` AS answer_21, p0_.`manager` AS manager_22, p0_.`is_anonymous` AS is_anonymous_23, p0_.`is_collection_review` AS is_collection_review_24 FROM `product_reviews_cache` p0_ WHERE p0_.`sku` IN ('С000536146')
Parameters:
[] |
0.27 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:
[
"de"
]
|
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\FilterEntity | No errors. |
WebBundle\Entity\SampleEntity | No errors. |
WebBundle\Entity\BuyOrder | No errors. |
WebBundle\Entity\ListCountry | No errors. |
WebBundle\Entity\Publication | No errors. |
WebBundle\Entity\Idea | No errors. |
WebBundle\Entity\Article | No errors. |
WebBundle\Entity\Collection | No errors. |
WebBundle\Entity\Interior | No errors. |
WebBundle\Entity\LastUrlEntity | No errors. |
WebBundle\Entity\ProductReviewsCache | No errors. |
WebBundle\Entity\ReviewsCache | No errors. |
WebBundle\Entity\CurrencyRate | 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. |
FlexApp\Entity\GeoCountryEntity | No errors. |
WebBundle\Entity\ArticleDetail | No errors. |
WebBundle\Entity\ListDelivery | No errors. |
WebBundle\Entity\ListMeasure | No errors. |
WebBundle\Entity\ListMaterial | No errors. |
WebBundle\Entity\ArticlePriceDiscount | No errors. |
WebBundle\Entity\ListFactoryColor | No errors. |
WebBundle\Entity\ListTexture | No errors. |
WebBundle\Entity\ListStyle | No errors. |
WebBundle\Entity\ListSurface | No errors. |
WebBundle\Entity\ListType | No errors. |
WebBundle\Entity\ListMotiv | No errors. |
WebBundle\Entity\ListShape | No errors. |
WebBundle\Entity\ListMeasureSize | No errors. |
WebBundle\Entity\ListColor | No errors. |
FlexApp\Entity\Collection\CollectionEntity | No errors. |
WebBundle\Entity\ListPRStatus | No errors. |
WebBundle\Entity\ListPrice | No errors. |
WebBundle\Entity\ListEdgeType | No errors. |
WebBundle\Entity\ListUsing | No errors. |
WebBundle\Entity\ListSliding | No errors. |
WebBundle\Entity\ListOffShade | No errors. |
WebBundle\Entity\ListRepeatDraw | No errors. |
WebBundle\Entity\ListSink | No errors. |
WebBundle\Entity\ListMethLaying | No errors. |
WebBundle\Entity\ListDraw | No errors. |
WebBundle\Entity\ListStoneTexture | No errors. |
WebBundle\Entity\InteriorArticle | No errors. |
WebBundle\Entity\InteriorArticleLogging | No errors. |
WebBundle\Entity\LocaleTitleEntity | No errors. |
WebBundle\Entity\ListEmail | No errors. |
WebBundle\Entity\StaticPageEntity | No errors. |
FlexApp\Entity\Exhibition\ExhEntity | No errors. |
WebBundle\Entity\LocaleHtmlEntity | No errors. |
WebBundle\Entity\TransEntity | No errors. |
FlexApp\Entity\Exhibition\ExhBrandEntity | No errors. |
FlexApp\Entity\Exhibition\ExhCollectionEntity | No errors. |
WebBundle\Entity\LocaleUrlEntity | No errors. |
WebBundle\Entity\LocalePreviewEntity | No errors. |
WebBundle\Entity\LocaleMetaEntity | No errors. |
WebBundle\Entity\LocaleBoolEntity | No errors. |
WebBundle\Entity\LocaleStatusTranslateEntity | No errors. |
WebBundle\Entity\PublicationLike | No errors. |
WebBundle\Entity\OrderAddress | No errors. |
WebBundle\Entity\OrderHistory | No errors. |
WebBundle\Entity\OrderPayment | No errors. |
WebBundle\Entity\ListVat | No errors. |
WebBundle\Entity\Visit | No errors. |
WebBundle\Entity\WarehouseEntity | No errors. |
WebBundle\Entity\BuyOrderArticle | No errors. |
WebBundle\Entity\BuyOrderManager | No errors. |
FlexApp\Entity\InterviewEntity | No errors. |
WebBundle\Entity\TransExEntity | No errors. |
WebBundle\Entity\Participant | No errors. |
WebBundle\Entity\FactoryUser | 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\Mailing | No errors. |
WebBundle\Entity\BuyOrderDelivery | No errors. |
WebBundle\Entity\ListState | No errors. |
WebBundle\Entity\CheckList | No errors. |
WebBundle\Entity\ListApply | No errors. |
WebBundle\Entity\ListBrandParser | No errors. |
FlexApp\Entity\AttachmentEntity | No errors. |
FlexApp\Entity\GeoLocaleNameEntity | No errors. |
FlexApp\Entity\GeoRegionEntity | No errors. |
FlexApp\Entity\Collection\CollectionAwardEntity | No errors. |
FlexApp\Entity\Collection\CollectionSettingEntity | No errors. |
FlexApp\Entity\Collection\CollectionHeaderEntity | No errors. |
FlexApp\Entity\UtilsStatusEntity | No errors. |
FlexApp\Entity\FactoryEntity | No errors. |
FlexApp\Entity\PriceEntity | No errors. |
FlexApp\Entity\StaticContent\CollectionStaticContentEntity | No errors. |
FlexApp\Entity\DesignerEntity | No errors. |
FlexApp\Entity\StaticContent\VideoStaticContentEntity | No errors. |
WebBundle\Entity\ListEmailGroup | No errors. |
FlexApp\Entity\LikesEntity | No errors. |
WebBundle\Entity\TransGroupsEntity | No errors. |
FlexApp\Entity\Exhibition\ExhLineEntity | No errors. |
WebBundle\Entity\BuyOrderArticleHoliday | No errors. |
oneC entity manager
No loaded entities.
logs entity manager
No loaded entities.