https://dev5.tile.expert/en-ca/tile/brennero/mineral/a/momi-mosaicomineraliron3030

Method
GET
HTTP Status
200
IP
52.167.144.159
Profiled on
Token
4ea995

Query Metrics

44 Database Queries
26 Different statements
236.96 ms Query time
0 Invalid entities

Queries

Group similar statements

default connection

#▲ Time Info
1 14.74 ms 
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: 
[
  "brennero"
  "mineral"
  [
    1
    2
    3
    7
    4
  ]
]
View formatted query    View runnable query    Explain query
2 0.25 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: 
[
  "ca"
]
View formatted query    View runnable query    Explain query
3 0.30 ms 
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: 
[
  3247777
]
View formatted query    View runnable query    Explain query
4 0.32 ms 
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 > 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 = '3247777' 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: 
[]
View formatted query    View runnable query    Explain query
5 8.59 ms 
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_cad AS a_price_cad, a.price_mq_cad AS a_price_mq_cad, a.price_fq_cad AS a_price_fq_cad, a.price_cae AS a_price_cae, a.price_mq_cae AS a_price_mq_cae, a.price_fq_cae AS a_price_fq_cae, apd.price_cad AS apd_price_cad, apd.price_fq_cad AS apd_price_fq_cad, apd.price_cae AS apd_price_cae, apd.price_fq_cae AS apd_price_fq_cae, acl.pr_min_cad AS acl_pr_min_cad, acl.pr_min_cae AS acl_pr_min_cae, acl.pr_min_f_usd AS acl_pr_min_f_usd, acl.pr_min_f_use AS acl_pr_min_f_use, 
                
                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 > 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 = '3247777' AND a.id IN ('367438631','367438563','367438543','367438592','367438589','367438582','367438641','367438618','367438591','367438603','367438623','367438605','367438635','367438566','367438559','367438611','367438660','367438579','367438555','367438594','367438578','367438650','367438599','367438541','367438612') 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: 
[]
View formatted query    View runnable query    Explain query
6 0.30 ms 
SELECT t0.`id` AS id_1, t0.`currency` AS currency_2, t0.`val` AS val_3 FROM `currency_rate` t0 WHERE t0.`currency` = ? LIMIT 1
Parameters: 
[
  "CAD"
]
View formatted query    View runnable query    Explain query
7 0.47 ms 
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: 
[
  "momi-mosaicomineraliron3030"
  3247777
]
View formatted query    View runnable query    Explain query
8 7.55 ms 
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_cad AS a_price_cad, a.price_mq_cad AS a_price_mq_cad, a.price_fq_cad AS a_price_fq_cad, a.price_cae AS a_price_cae, a.price_mq_cae AS a_price_mq_cae, a.price_fq_cae AS a_price_fq_cae, apd.price_cad AS apd_price_cad, apd.price_fq_cad AS apd_price_fq_cad, apd.price_cae AS apd_price_cae, apd.price_fq_cae AS apd_price_fq_cae, acl.pr_min_cad AS acl_pr_min_cad, acl.pr_min_cae AS acl_pr_min_cae, acl.pr_min_f_usd AS acl_pr_min_f_usd, acl.pr_min_f_use AS acl_pr_min_f_use, 
                
                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_cad AS iacl_pr_min_cad,  iacl.pr_min_cae AS iacl_pr_min_cae,  iacl.pr_min_f_usd AS iacl_pr_min_f_usd,  iacl.pr_min_f_use AS iacl_pr_min_f_use, 
                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 > 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 = '3247777' AND a.id IN ('0','367438603','367438618','367438591','367438623','367438605') 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: 
[]
View formatted query    View runnable query    Explain query
9 1.09 ms 
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: 
[
  "e66dedf6c8088514db125feb24240a2f5b3984e773e01180713e4f3df766457a"
]
View formatted query    View runnable query    Explain query
10 1.01 ms 
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: 
[
  "e66dedf6c8088514db125feb24240a2f5b3984e773e01180713e4f3df766457a"
]
View formatted query    View runnable query    Explain query
11 0.18 ms 
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: 
[
  "e66dedf6c8088514db125feb24240a2f5b3984e773e01180713e4f3df766457a"
]
View formatted query    View runnable query    Explain query
12 0.32 ms 
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: 
[
  367438618
  "measure_mq"
]
View formatted query    View runnable query    Explain query
13 0.64 ms 
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: 
[
  367438591
  "measure_mq"
]
View formatted query    View runnable query    Explain query
14 0.39 ms 
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: 
[
  367438603
  "measure_mq"
]
View formatted query    View runnable query    Explain query
15 0.40 ms 
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: 
[
  367438603
]
View formatted query    View runnable query    Explain query
16 0.53 ms 
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: 
[
  367438623
  "measure_mq"
]
View formatted query    View runnable query    Explain query
17 0.34 ms 
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: 
[
  367438623
]
View formatted query    View runnable query    Explain query
18 0.56 ms 
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: 
[
  367438605
  "measure_mq"
]
View formatted query    View runnable query    Explain query
19 1.03 ms 
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
]
View formatted query    View runnable query    Explain query
20 0.28 ms 
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 ('С000447280')
Parameters: 
[]
View formatted query    View runnable query    Explain query
21 2.08 ms 
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: 
[
  "e66dedf6c8088514db125feb24240a2f5b3984e773e01180713e4f3df766457a"
]
View formatted query    View runnable query    Explain query
22 1.69 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: 
[
  "e66dedf6c8088514db125feb24240a2f5b3984e773e01180713e4f3df766457a"
]
View formatted query    View runnable query    Explain query
23 0.77 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: 
[
  "e66dedf6c8088514db125feb24240a2f5b3984e773e01180713e4f3df766457a"
]
View formatted query    View runnable query    Explain query
24 0.57 ms 
SELECT b0_.`id` AS id_0 FROM `buy_order` b0_ WHERE b0_.`token` = ? AND b0_.`status` <> 12
Parameters: 
[
  "e66dedf6c8088514db125feb24240a2f5b3984e773e01180713e4f3df766457a"
]
View formatted query    View runnable query    Explain query
25 0.48 ms 
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: 
[
  "e66dedf6c8088514db125feb24240a2f5b3984e773e01180713e4f3df766457a"
]
View formatted query    View runnable query    Explain query
26 4.02 ms 
SELECT COUNT(v0_.`id`) AS sclr_0 FROM `visit` v0_ WHERE v0_.`token` = ? AND v0_.`url` <> '/.*catalog.*/'
Parameters: 
[
  "e66dedf6c8088514db125feb24240a2f5b3984e773e01180713e4f3df766457a"
]
View formatted query    View runnable query    Explain query
27 3.21 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: 
[
  "e66dedf6c8088514db125feb24240a2f5b3984e773e01180713e4f3df766457a"
]
View formatted query    View runnable query    Explain query
28 104.48 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
]
View formatted query    View runnable query    Explain query
29 0.25 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
]
View formatted query    View runnable query    Explain query
30 0.20 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: 
[]
View formatted query    View runnable query    Explain query
31 1.32 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"
  ]
]
View formatted query    View runnable query    Explain query
32 0.19 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: 
[
  "e66dedf6c8088514db125feb24240a2f5b3984e773e01180713e4f3df766457a"
]
View formatted query    View runnable query    Explain query
33 0.10 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: 
[
  "e66dedf6c8088514db125feb24240a2f5b3984e773e01180713e4f3df766457a"
]
View formatted query    View runnable query    Explain query
34 0.09 ms 
SELECT b0_.`id` AS id_0 FROM `buy_order` b0_ WHERE b0_.`token` = ? AND b0_.`status` <> 12
Parameters: 
[
  "e66dedf6c8088514db125feb24240a2f5b3984e773e01180713e4f3df766457a"
]
View formatted query    View runnable query    Explain query
35 0.48 ms 
SELECT COUNT(v0_.`id`) AS sclr_0 FROM `visit` v0_ WHERE v0_.`token` = ? AND v0_.`url` <> '/.*catalog.*/'
Parameters: 
[
  "e66dedf6c8088514db125feb24240a2f5b3984e773e01180713e4f3df766457a"
]
View formatted query    View runnable query    Explain query
36 0.12 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: 
[
  "e66dedf6c8088514db125feb24240a2f5b3984e773e01180713e4f3df766457a"
]
View formatted query    View runnable query    Explain query
37 0.20 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"
]
View formatted query    View runnable query    Explain query
38 0.81 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: 
[
  "e66dedf6c8088514db125feb24240a2f5b3984e773e01180713e4f3df766457a"
]
View formatted query    View runnable query    Explain query
39 0.21 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"
]
View formatted query    View runnable query    Explain query
40 73.35 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
]
View formatted query    View runnable query    Explain query
41 0.22 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
]
View formatted query    View runnable query    Explain query
42 0.20 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: 
[]
View formatted query    View runnable query    Explain query
43 1.37 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"
  ]
]
View formatted query    View runnable query    Explain query
44 1.27 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"
]
View formatted query    View runnable query    Explain query

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.