https://dev5.tile.expert/_fragment?_path=_format%3Dhtml%26_locale%3Den-no%26_controller%3DWebBundle%255CController%255CCommonController%253A%253AtopAction

Method
GET
HTTP Status
200
IP
216.73.216.124
Profiled on
Token
766907

Query Metrics

38 Database Queries
30 Different statements
149.92 ms Query time
0 Invalid entities

Queries

Group similar statements

default connection

#▲ Time Info
1 6.80 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: 
[
  "ascot"
  "game-of-fifteen-boris-tellegen"
  [
    1
    2
    3
    7
    4
  ]
]
View formatted query    View runnable query    Explain query
2 0.31 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: 
[
  "no"
]
View formatted query    View runnable query    Explain query
3 0.32 ms 
SELECT COUNT(i0_.`id`) AS sclr_0 FROM `interior` i0_ WHERE i0_.`status` = 1 AND i0_.collection = ?
Parameters: 
[
  2096587
]
View formatted query    View runnable query    Explain query
4 4.29 ms 
SELECT i0_.`id` AS id_0 FROM `interior` i0_ WHERE (i0_.`url` = ? OR i0_.`file` = ?) AND i0_.collection = ? LIMIT 1
Parameters: 
[
  "game-of-fifteen-boris-tellegen-ascot-2"
  "game-of-fifteen-boris-tellegen-ascot-2"
  2096587
]
View formatted query    View runnable query    Explain query
5 8.60 ms 
SELECT i.id AS iId
            FROM interior i
            LEFT JOIN collection c ON c.id = i.collection
            LEFT JOIN factory f ON f.id = c.factory
            LEFT JOIN list_country lc ON lc.id = f.country
            LEFT JOIN interior_texture it ON it.interior_id = i.id
            LEFT JOIN list_texture lt ON lt.id = it.texture_id

            LEFT JOIN interior_style ist ON ist.interior_id = i.id
            LEFT JOIN list_style lst ON lst.id = ist.style_id

            LEFT JOIN interior_apply iappl ON iappl.interior_id = i.id
            LEFT JOIN list_style lapl ON lapl.id = iappl.apply_id

            LEFT JOIN interior_article ia ON ia.interior_id = i.id
            LEFT JOIN article a ON ia.article_id = a.id AND a.delivery <> 6 AND a.file <> '' AND a.file IS NOT NULL
            LEFT JOIN interior_article_coord iac ON iac.article_id = a.id

            LEFT JOIN interior iaci ON iaci.id = iac.interior_id
            LEFT JOIN article iaca ON iaca.id = iac.article_id AND iaca.delivery <> 6 AND iaca.file <> '' AND iaca.file IS NOT NULL

            LEFT JOIN collection ac ON ac.id = a.collection
            LEFT JOIN factory acf ON acf.id = ac.factory
            LEFT JOIN list_country acfc ON acfc.id = acf.country
            LEFT JOIN list_type alt ON a.type = alt.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_usd > 0
            LEFT JOIN article_color acl ON a.id = acl.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 altx ON altx.id = `at`.texture_id

            LEFT JOIN article_color alcl ON a.id = alcl.article_id
            LEFT JOIN list_color lcl ON lcl.id = alcl.color_id

            LEFT JOIN list_style als ON a.style = als.id
            LEFT JOIN list_color alc ON alc.id = acl.color_id
            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 c.id = 2096587 AND i.status = 1 GROUP BY i.id
Parameters: 
[]
View formatted query    View runnable query    Explain query
6 8.35 ms 
SELECT 
                i.id AS iId,
                i.url AS iUrl,
                i.name AS iName,
                i.alt AS iAlt,
                i.file AS iFile,
                i.status AS iStatus,
                i.file_size_x AS iFileSizeX,
                i.file_size_y AS iFileSizeY,
                i.file_size_z_x AS iFileSizeZX,
                i.file_size_z_y AS iFileSizeZY,
                i.file_size_hd_x AS iFileSizeHdX,
                i.file_size_hd_y AS iFileSizeHdY,
                i.file_size_shd_x AS iFileSizeShdX,
                i.file_size_shd_y AS iFileSizeShdY,
                i.file_size4k_x AS iFileSize4kX,
                i.file_size4k_y AS iFileSize4kY,
                c.id AS cId,
                c.url AS cUrl,
                c.status AS cStatus,
                c.process AS cProcess,
                c.name AS cName,
                c.alternate_name AS cAName,
                c.header AS header,
                c.pr_min_euro AS prMinEuro,
                c.pr_min_euro_de AS prMinEuroDe,
                c.pr_min_euro_fr AS prMinEuroFr,
                c.pr_min_euro_it AS prMinEuroIt,
                c.pr_min_euro_be AS prMinEuroBe,
                c.pr_min_euro_ie AS prMinEuroIe,
                c.pr_min_euro_nl AS prMinEuroNl,
                c.pr_min_euro_es AS prMinEuroEs,
                c.pr_min_rue AS prMinRUB,
                c.pr_min_rue AS prMinRUE,
                c.pr_min_gbp AS prMinGBP,
                c.pr_min_gbe AS prMinGBE,
                c.pr_min_usd AS prMinUSD,
                c.pr_min_use AS prMinUSE,
                c.pr_min_f_usd AS prMinFUSD,
                c.pr_min_f_use AS prMinFUSE,
                c.pr_min_chf AS prMinCHF,
                c.pr_min_che AS prMinCHE,
                c.pr_min_sek AS prMinSEK,
                c.pr_min_see AS prMinSEE,
                c.pr_min_dkk AS prMinDKK,
                c.pr_min_dke AS prMinDKE,
                c.pr_min_nok AS prMinNOK,
                c.pr_min_noe AS prMinNOE,
                c.pr_min_pln AS prMinPLN,
                c.pr_min_ple AS prMinPLE,
                c.pr_min_cad AS prMinCAD,
                c.pr_min_cae AS prMinCAE,
                c.pr_min_f_cad AS prMinFCAD,
                c.pr_min_f_cae AS prMinFCAE,
                f.id AS fId,
                f.url AS fUrl,
                f.status AS fStatus,
                f.name AS fName,
                f.alternate_name AS fAName,
                f.suspended AS fSuspended,
                lc.id AS lcId,
                lc.code AS lcCode,
                lc.alias AS lcAlias,
                lst.id AS lstId,
                lst.alias AS lstAlias,
                lt.id AS ltId,
                lt.alias AS ltAlias,

                lapl.id AS laplId,
                lapl.alias AS laplAlias,


                (SELECT COUNT(ii.idea_id) FROM `idea_interior` ii WHERE `ii`.`interior_id` = `i`.id) AS ideaCount,
                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.price_euro,
                a.price_mq_euro,
                a.price_euro_de,
                a.price_mq_euro_de,
                a.price_euro_at,
                a.price_mq_euro_at,
                a.price_euro_fi,
                a.price_mq_euro_fi,
                a.price_euro_fr,
                a.price_mq_euro_fr,
                a.price_euro_it,
                a.price_mq_euro_it,
                a.price_euro_be,
                a.price_mq_euro_be,
                a.price_euro_ie,
                a.price_mq_euro_ie,
                a.price_euro_nl,
                a.price_mq_euro_nl,
                a.price_euro_es,
                a.price_mq_euro_es,
                a.price_rub,
                a.price_rue,
                a.price_mq_rub,
                a.price_mq_rue,
                a.price_gbp,
                a.price_gbe,
                a.price_mq_gbp,
                a.price_mq_gbe,
                a.price_usd,
                a.price_use,
                a.price_fq_usd,
                a.price_fq_use,
                a.price_mq_use,
                a.price_chf,
                a.price_che,
                a.price_mq_chf,
                a.price_mq_che,
                a.price_sek,
                a.price_see,
                a.price_mq_sek,
                a.price_mq_see,
                a.price_dkk,
                a.price_dke,
                a.price_mq_dkk,
                a.price_mq_dke,
                a.price_nok,
                a.price_noe,
                a.price_mq_nok,
                a.price_mq_noe,
                a.price_pln,
                a.price_ple,
                a.price_mq_pln,
                a.price_mq_ple,
                a.price_cad,
                a.price_cae,
                a.price_fq_cad,
                a.price_fq_cae,
                a.price_mq_cae,
                a.size_x,
                a.size_y,
                a.size_z,
                a.size_gb_x,
                a.size_gb_y,
                a.size_gb_z,
                a.file_size2_x,
                a.file_size2_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.file_edit,
                a.comment_scheme_image,

                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.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,
                ld.alias AS ld_alias,
                ld.name AS ld_name,


                alt.id AS alt_id,
                alt.alias AS alt_alias,
                alt.name AS alt_name,

                lcl.id AS lcl_id,
                lcl.alias AS lcl_alias,
                lcl.name AS lcl_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.name AS lsf_name,
                lsf.alias AS lsf_alias,

                lfc.id AS lfc_id,
                lfc.name AS lfc_name,

                altx.id AS altx_id,
                altx.alias AS altx_alias,
                altx.name AS altx_name,

                als.id AS als_id,
                als.alias AS als_alias,
                als.name AS als_name,

                lsh.id AS lsh_id,
                lsh.alias AS lsh_alias,
                lsh.name AS lsh_name,

                llm.id AS llm_id,
                llm.name AS llm_name,
                llm.alias AS llm_alias,

                lmss.id AS lmss_id,
                lmss.alias AS lmss_alias,
                lmss.name AS lmss_name,

                apd.id AS apd_id,
                apd.amount AS apd_amount,
                apd.amount_ft AS apd_amount_ft,
                apd.fold AS apd_fold,
                apd.price AS apd_price,
                apd.price_euro AS apd_price_euro,
                apd.price_euro_de AS apd_price_euro_de,
                apd.price_euro_at AS apd_price_euro_at,
                apd.price_euro_fi AS apd_price_euro_fi,
                apd.price_euro_fr AS apd_price_euro_fr,
                apd.price_euro_it AS apd_price_euro_it,
                apd.price_euro_be AS apd_price_euro_be,
                apd.price_euro_ie AS apd_price_euro_ie,
                apd.price_euro_nl AS apd_price_euro_nl,
                apd.price_euro_es AS apd_price_euro_es,
                apd.price_rub AS apd_price_rub,
                apd.price_rue AS apd_price_rue,
                apd.price_gbp AS apd_price_gbp,
                apd.price_gbe AS apd_price_gbe,
                apd.price_usd AS apd_price_usd,
                apd.price_use AS apd_price_use,
                apd.price_fq_usd AS apd_price_fq_usd,
                apd.price_fq_use AS apd_price_fq_use,
                apd.price_chf AS apd_price_chf,
                apd.price_che AS apd_price_che,
                apd.price_sek AS apd_price_sek,
                apd.price_see AS apd_price_see,
                apd.price_dkk AS apd_price_dkk,
                apd.price_dke AS apd_price_dke,
                apd.price_nok AS apd_price_nok,
                apd.price_noe AS apd_price_noe,
                apd.price_pln AS apd_price_pln,
                apd.price_ple AS apd_price_ple,
                apd.price_cad AS apd_price_cad,
                apd.price_cae AS apd_price_cae,
                apd.price_fq_cad AS apd_price_fq_cad,
                apd.price_fq_cae AS apd_price_fq_cae,
                ac.id AS ac_id,
                ac.url AS ac_url,
                ac.name AS ac_name,
                ac.alternate_name AS ac_aname,
                ac.status AS ac_status,

                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,

                acfc.id AS acfc_id,
                acfc.code AS acfc_code,
                acfc.alias AS acfc_alias,
                acfc.name AS acfc_name,

                iac.id AS iacId,
                iac.coord_x AS iacCoordX,
                iac.coord_y AS iacCoordY,
                iac.type_pointer AS iacTypePointer,

                iaci.id AS iaciId,
                iaca.id AS iacaId

            
            FROM interior i
            LEFT JOIN collection c ON c.id = i.collection
            LEFT JOIN factory f ON f.id = c.factory
            LEFT JOIN list_country lc ON lc.id = f.country
            LEFT JOIN interior_texture it ON it.interior_id = i.id
            LEFT JOIN list_texture lt ON lt.id = it.texture_id

            LEFT JOIN interior_style ist ON ist.interior_id = i.id
            LEFT JOIN list_style lst ON lst.id = ist.style_id

            LEFT JOIN interior_apply iappl ON iappl.interior_id = i.id
            LEFT JOIN list_style lapl ON lapl.id = iappl.apply_id

            LEFT JOIN interior_article ia ON ia.interior_id = i.id
            LEFT JOIN article a ON ia.article_id = a.id AND a.delivery <> 6 AND a.file <> '' AND a.file IS NOT NULL
            LEFT JOIN interior_article_coord iac ON iac.article_id = a.id

            LEFT JOIN interior iaci ON iaci.id = iac.interior_id
            LEFT JOIN article iaca ON iaca.id = iac.article_id AND iaca.delivery <> 6 AND iaca.file <> '' AND iaca.file IS NOT NULL

            LEFT JOIN collection ac ON ac.id = a.collection
            LEFT JOIN factory acf ON acf.id = ac.factory
            LEFT JOIN list_country acfc ON acfc.id = acf.country
            LEFT JOIN list_type alt ON a.type = alt.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_usd > 0
            LEFT JOIN article_color acl ON a.id = acl.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 altx ON altx.id = `at`.texture_id

            LEFT JOIN article_color alcl ON a.id = alcl.article_id
            LEFT JOIN list_color lcl ON lcl.id = alcl.color_id

            LEFT JOIN list_style als ON a.style = als.id
            LEFT JOIN list_color alc ON alc.id = acl.color_id
            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 c.id = 2096587 AND i.status = 1 AND i.id IN (0,94844,94843,94845,94846)
Parameters: 
[]
View formatted query    View runnable query    Explain query
7 1.14 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: 
[
  "ce121a2c0e60d4937df7611a1b713ec99f17b2a911cea429f0c6e6a4f4362d6f"
]
View formatted query    View runnable query    Explain query
8 1.36 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: 
[
  "ce121a2c0e60d4937df7611a1b713ec99f17b2a911cea429f0c6e6a4f4362d6f"
]
View formatted query    View runnable query    Explain query
9 0.34 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: 
[
  "ce121a2c0e60d4937df7611a1b713ec99f17b2a911cea429f0c6e6a4f4362d6f"
]
View formatted query    View runnable query    Explain query
10 1.86 ms 
SELECT
                i.id,
                i.name AS `i_name`,
                a.id AS `a.id`,
                a.name AS `a.name`,
                a.price_euro AS `a.priceEuro`,
                a.price_mq_euro AS `a.priceMqEuro`,
                a.price_euro_de AS `a.priceEuroDe`,
                a.price_mq_euro_de AS `a.priceMqEuroDe`,
                a.price_euro_at AS `a.priceEuroAt`,
                a.price_mq_euro_at AS `a.priceMqEuroAt`,
                a.price_euro_fi AS `a.priceEuroFi`,
                a.price_mq_euro_fi AS `a.priceMqEuroFi`,
                a.price_euro_fr AS `a.priceEuroFr`,
                a.price_mq_euro_fr AS `a.priceMqEuroFr`,
                a.price_euro_it AS `a.priceEuroIt`,
                a.price_mq_euro_it AS `a.priceMqEuroIt`,
                a.price_euro_ie AS `a.priceEuroIe`,
                a.price_mq_euro_ie AS `a.priceMqEuroIe`,
                a.price_euro_nl AS `a.priceEuroNl`,
                a.price_mq_euro_nl AS `a.priceMqEuroNl`,
                a.price_euro_es AS `a.priceEuroEs`,
                a.price_mq_euro_es AS `a.priceMqEuroEs`,
                a.price_euro_be AS `a.priceEuroBe`,
                a.price_mq_euro_be AS `a.priceMqEuroBe`,
                a.price_rub AS `a.priceRUB`,
                a.price_rue AS `a.priceRUE`,
                a.price_mq_rub AS `a.priceMqRUB`,
                a.price_mq_rue AS `a.priceMqRUE`,
                a.price_gbp AS `a.priceGBP`,
                a.price_gbe AS `a.priceGBE`,
                a.price_mq_gbp AS `a.priceMqGBP`,
                a.price_mq_gbe AS `a.priceMqGBE`,
                a.price_usd AS `a.priceUSD`,
                a.price_use AS `a.priceUSE`,
                a.price_fq_usd AS `a.priceFqUSD`,
                a.price_fq_use AS `a.priceFqUSE`,
                a.price_mq_usd AS `a.priceMqUSD`,
                a.price_mq_use AS `a.priceMqUSE`,
                a.price_chf AS `a.priceCHF`,
                a.price_che AS `a.priceCHE`,
                a.price_mq_chf AS `a.priceMqCHF`,
                a.price_mq_che AS `a.priceMqCHE`,
                a.price_sek AS `a.priceSEK`,
                a.price_see AS `a.priceSEE`,
                a.price_mq_sek AS `a.priceMqSEK`,
                a.price_mq_see AS `a.priceMqSEE`,
                a.price_dkk AS `a.priceDKK`,
                a.price_dke AS `a.priceDKE`,
                a.price_mq_dkk AS `a.priceMqDKK`,
                a.price_mq_dke AS `a.priceMqDKE`,
                a.price_nok AS `a.priceNOK`,
                a.price_noe AS `a.priceNOE`,
                a.price_mq_nok AS `a.priceMqNOK`,
                a.price_mq_noe AS `a.priceMqNOE`,
                a.price_pln AS `a.pricePLN`,
                a.price_ple AS `a.pricePLE`,
                a.price_mq_pln AS `a.priceMqPLN`,
                a.price_mq_ple AS `a.priceMqPLE`,
                a.price_cad AS `a.priceCAD`,
                a.price_cae AS `a.priceCAE`,
                a.price_fq_cad AS `a.priceFqCAD`,
                a.price_fq_cae AS `a.priceFqCAE`,
                a.price_mq_cad AS `a.priceMqCAD`,
                a.price_mq_cae AS `a.priceMqCAE`,
                m.id AS `m.id`,
                m.name AS `m.name`,
                m.alias AS `m.alias`
            FROM
                article a
            LEFT JOIN interior_article ia ON ia.article_id = a.id
            LEFT JOIN interior i ON i.id = ia.interior_id
            LEFT JOIN list_measure m ON m.id = a.measure
            WHERE i.id = '94843' AND a.price_euro > 0 AND a.delivery != 6 AND a.file <> ''  AND m.alias = 'measure_mq' 
            GROUP BY a.id
			ORDER BY a.price_euro ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
11 1.86 ms 
SELECT
                i.id,
                i.name AS `i_name`,
                a.id AS `a.id`,
                a.name AS `a.name`,
                a.price_euro AS `a.priceEuro`,
                a.price_mq_euro AS `a.priceMqEuro`,
                a.price_euro_de AS `a.priceEuroDe`,
                a.price_mq_euro_de AS `a.priceMqEuroDe`,
                a.price_euro_at AS `a.priceEuroAt`,
                a.price_mq_euro_at AS `a.priceMqEuroAt`,
                a.price_euro_fi AS `a.priceEuroFi`,
                a.price_mq_euro_fi AS `a.priceMqEuroFi`,
                a.price_euro_fr AS `a.priceEuroFr`,
                a.price_mq_euro_fr AS `a.priceMqEuroFr`,
                a.price_euro_it AS `a.priceEuroIt`,
                a.price_mq_euro_it AS `a.priceMqEuroIt`,
                a.price_euro_ie AS `a.priceEuroIe`,
                a.price_mq_euro_ie AS `a.priceMqEuroIe`,
                a.price_euro_nl AS `a.priceEuroNl`,
                a.price_mq_euro_nl AS `a.priceMqEuroNl`,
                a.price_euro_es AS `a.priceEuroEs`,
                a.price_mq_euro_es AS `a.priceMqEuroEs`,
                a.price_euro_be AS `a.priceEuroBe`,
                a.price_mq_euro_be AS `a.priceMqEuroBe`,
                a.price_rub AS `a.priceRUB`,
                a.price_rue AS `a.priceRUE`,
                a.price_mq_rub AS `a.priceMqRUB`,
                a.price_mq_rue AS `a.priceMqRUE`,
                a.price_gbp AS `a.priceGBP`,
                a.price_gbe AS `a.priceGBE`,
                a.price_mq_gbp AS `a.priceMqGBP`,
                a.price_mq_gbe AS `a.priceMqGBE`,
                a.price_usd AS `a.priceUSD`,
                a.price_use AS `a.priceUSE`,
                a.price_fq_usd AS `a.priceFqUSD`,
                a.price_fq_use AS `a.priceFqUSE`,
                a.price_mq_usd AS `a.priceMqUSD`,
                a.price_mq_use AS `a.priceMqUSE`,
                a.price_chf AS `a.priceCHF`,
                a.price_che AS `a.priceCHE`,
                a.price_mq_chf AS `a.priceMqCHF`,
                a.price_mq_che AS `a.priceMqCHE`,
                a.price_sek AS `a.priceSEK`,
                a.price_see AS `a.priceSEE`,
                a.price_mq_sek AS `a.priceMqSEK`,
                a.price_mq_see AS `a.priceMqSEE`,
                a.price_dkk AS `a.priceDKK`,
                a.price_dke AS `a.priceDKE`,
                a.price_mq_dkk AS `a.priceMqDKK`,
                a.price_mq_dke AS `a.priceMqDKE`,
                a.price_nok AS `a.priceNOK`,
                a.price_noe AS `a.priceNOE`,
                a.price_mq_nok AS `a.priceMqNOK`,
                a.price_mq_noe AS `a.priceMqNOE`,
                a.price_pln AS `a.pricePLN`,
                a.price_ple AS `a.pricePLE`,
                a.price_mq_pln AS `a.priceMqPLN`,
                a.price_mq_ple AS `a.priceMqPLE`,
                a.price_cad AS `a.priceCAD`,
                a.price_cae AS `a.priceCAE`,
                a.price_fq_cad AS `a.priceFqCAD`,
                a.price_fq_cae AS `a.priceFqCAE`,
                a.price_mq_cad AS `a.priceMqCAD`,
                a.price_mq_cae AS `a.priceMqCAE`,
                m.id AS `m.id`,
                m.name AS `m.name`,
                m.alias AS `m.alias`
            FROM
                article a
            LEFT JOIN interior_article ia ON ia.article_id = a.id
            LEFT JOIN interior i ON i.id = ia.interior_id
            LEFT JOIN list_measure m ON m.id = a.measure
            WHERE i.id = '94843' AND a.price_euro > 0 AND a.delivery != 6 AND a.file <> '' 
            GROUP BY a.id
			ORDER BY a.price_euro ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
12 2.57 ms 
SELECT
                i.id,
                i.name AS `i_name`,
                a.id AS `a.id`,
                a.name AS `a.name`,
                a.price_euro AS `a.priceEuro`,
                a.price_mq_euro AS `a.priceMqEuro`,
                a.price_euro_de AS `a.priceEuroDe`,
                a.price_mq_euro_de AS `a.priceMqEuroDe`,
                a.price_euro_at AS `a.priceEuroAt`,
                a.price_mq_euro_at AS `a.priceMqEuroAt`,
                a.price_euro_fi AS `a.priceEuroFi`,
                a.price_mq_euro_fi AS `a.priceMqEuroFi`,
                a.price_euro_fr AS `a.priceEuroFr`,
                a.price_mq_euro_fr AS `a.priceMqEuroFr`,
                a.price_euro_it AS `a.priceEuroIt`,
                a.price_mq_euro_it AS `a.priceMqEuroIt`,
                a.price_euro_ie AS `a.priceEuroIe`,
                a.price_mq_euro_ie AS `a.priceMqEuroIe`,
                a.price_euro_nl AS `a.priceEuroNl`,
                a.price_mq_euro_nl AS `a.priceMqEuroNl`,
                a.price_euro_es AS `a.priceEuroEs`,
                a.price_mq_euro_es AS `a.priceMqEuroEs`,
                a.price_euro_be AS `a.priceEuroBe`,
                a.price_mq_euro_be AS `a.priceMqEuroBe`,
                a.price_rub AS `a.priceRUB`,
                a.price_rue AS `a.priceRUE`,
                a.price_mq_rub AS `a.priceMqRUB`,
                a.price_mq_rue AS `a.priceMqRUE`,
                a.price_gbp AS `a.priceGBP`,
                a.price_gbe AS `a.priceGBE`,
                a.price_mq_gbp AS `a.priceMqGBP`,
                a.price_mq_gbe AS `a.priceMqGBE`,
                a.price_usd AS `a.priceUSD`,
                a.price_use AS `a.priceUSE`,
                a.price_fq_usd AS `a.priceFqUSD`,
                a.price_fq_use AS `a.priceFqUSE`,
                a.price_mq_usd AS `a.priceMqUSD`,
                a.price_mq_use AS `a.priceMqUSE`,
                a.price_chf AS `a.priceCHF`,
                a.price_che AS `a.priceCHE`,
                a.price_mq_chf AS `a.priceMqCHF`,
                a.price_mq_che AS `a.priceMqCHE`,
                a.price_sek AS `a.priceSEK`,
                a.price_see AS `a.priceSEE`,
                a.price_mq_sek AS `a.priceMqSEK`,
                a.price_mq_see AS `a.priceMqSEE`,
                a.price_dkk AS `a.priceDKK`,
                a.price_dke AS `a.priceDKE`,
                a.price_mq_dkk AS `a.priceMqDKK`,
                a.price_mq_dke AS `a.priceMqDKE`,
                a.price_nok AS `a.priceNOK`,
                a.price_noe AS `a.priceNOE`,
                a.price_mq_nok AS `a.priceMqNOK`,
                a.price_mq_noe AS `a.priceMqNOE`,
                a.price_pln AS `a.pricePLN`,
                a.price_ple AS `a.pricePLE`,
                a.price_mq_pln AS `a.priceMqPLN`,
                a.price_mq_ple AS `a.priceMqPLE`,
                a.price_cad AS `a.priceCAD`,
                a.price_cae AS `a.priceCAE`,
                a.price_fq_cad AS `a.priceFqCAD`,
                a.price_fq_cae AS `a.priceFqCAE`,
                a.price_mq_cad AS `a.priceMqCAD`,
                a.price_mq_cae AS `a.priceMqCAE`,
                m.id AS `m.id`,
                m.name AS `m.name`,
                m.alias AS `m.alias`
            FROM
                article a
            LEFT JOIN interior_article ia ON ia.article_id = a.id
            LEFT JOIN interior i ON i.id = ia.interior_id
            LEFT JOIN list_measure m ON m.id = a.measure
            WHERE i.id = '94844' AND a.price_euro > 0 AND a.delivery != 6 AND a.file <> ''  AND m.alias = 'measure_mq' 
            GROUP BY a.id
			ORDER BY a.price_euro ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
13 3.52 ms 
SELECT
                i.id,
                i.name AS `i_name`,
                a.id AS `a.id`,
                a.name AS `a.name`,
                a.price_euro AS `a.priceEuro`,
                a.price_mq_euro AS `a.priceMqEuro`,
                a.price_euro_de AS `a.priceEuroDe`,
                a.price_mq_euro_de AS `a.priceMqEuroDe`,
                a.price_euro_at AS `a.priceEuroAt`,
                a.price_mq_euro_at AS `a.priceMqEuroAt`,
                a.price_euro_fi AS `a.priceEuroFi`,
                a.price_mq_euro_fi AS `a.priceMqEuroFi`,
                a.price_euro_fr AS `a.priceEuroFr`,
                a.price_mq_euro_fr AS `a.priceMqEuroFr`,
                a.price_euro_it AS `a.priceEuroIt`,
                a.price_mq_euro_it AS `a.priceMqEuroIt`,
                a.price_euro_ie AS `a.priceEuroIe`,
                a.price_mq_euro_ie AS `a.priceMqEuroIe`,
                a.price_euro_nl AS `a.priceEuroNl`,
                a.price_mq_euro_nl AS `a.priceMqEuroNl`,
                a.price_euro_es AS `a.priceEuroEs`,
                a.price_mq_euro_es AS `a.priceMqEuroEs`,
                a.price_euro_be AS `a.priceEuroBe`,
                a.price_mq_euro_be AS `a.priceMqEuroBe`,
                a.price_rub AS `a.priceRUB`,
                a.price_rue AS `a.priceRUE`,
                a.price_mq_rub AS `a.priceMqRUB`,
                a.price_mq_rue AS `a.priceMqRUE`,
                a.price_gbp AS `a.priceGBP`,
                a.price_gbe AS `a.priceGBE`,
                a.price_mq_gbp AS `a.priceMqGBP`,
                a.price_mq_gbe AS `a.priceMqGBE`,
                a.price_usd AS `a.priceUSD`,
                a.price_use AS `a.priceUSE`,
                a.price_fq_usd AS `a.priceFqUSD`,
                a.price_fq_use AS `a.priceFqUSE`,
                a.price_mq_usd AS `a.priceMqUSD`,
                a.price_mq_use AS `a.priceMqUSE`,
                a.price_chf AS `a.priceCHF`,
                a.price_che AS `a.priceCHE`,
                a.price_mq_chf AS `a.priceMqCHF`,
                a.price_mq_che AS `a.priceMqCHE`,
                a.price_sek AS `a.priceSEK`,
                a.price_see AS `a.priceSEE`,
                a.price_mq_sek AS `a.priceMqSEK`,
                a.price_mq_see AS `a.priceMqSEE`,
                a.price_dkk AS `a.priceDKK`,
                a.price_dke AS `a.priceDKE`,
                a.price_mq_dkk AS `a.priceMqDKK`,
                a.price_mq_dke AS `a.priceMqDKE`,
                a.price_nok AS `a.priceNOK`,
                a.price_noe AS `a.priceNOE`,
                a.price_mq_nok AS `a.priceMqNOK`,
                a.price_mq_noe AS `a.priceMqNOE`,
                a.price_pln AS `a.pricePLN`,
                a.price_ple AS `a.pricePLE`,
                a.price_mq_pln AS `a.priceMqPLN`,
                a.price_mq_ple AS `a.priceMqPLE`,
                a.price_cad AS `a.priceCAD`,
                a.price_cae AS `a.priceCAE`,
                a.price_fq_cad AS `a.priceFqCAD`,
                a.price_fq_cae AS `a.priceFqCAE`,
                a.price_mq_cad AS `a.priceMqCAD`,
                a.price_mq_cae AS `a.priceMqCAE`,
                m.id AS `m.id`,
                m.name AS `m.name`,
                m.alias AS `m.alias`
            FROM
                article a
            LEFT JOIN interior_article ia ON ia.article_id = a.id
            LEFT JOIN interior i ON i.id = ia.interior_id
            LEFT JOIN list_measure m ON m.id = a.measure
            WHERE i.id = '94844' AND a.price_euro > 0 AND a.delivery != 6 AND a.file <> '' 
            GROUP BY a.id
			ORDER BY a.price_euro ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
14 2.73 ms 
SELECT
                i.id,
                i.name AS `i_name`,
                a.id AS `a.id`,
                a.name AS `a.name`,
                a.price_euro AS `a.priceEuro`,
                a.price_mq_euro AS `a.priceMqEuro`,
                a.price_euro_de AS `a.priceEuroDe`,
                a.price_mq_euro_de AS `a.priceMqEuroDe`,
                a.price_euro_at AS `a.priceEuroAt`,
                a.price_mq_euro_at AS `a.priceMqEuroAt`,
                a.price_euro_fi AS `a.priceEuroFi`,
                a.price_mq_euro_fi AS `a.priceMqEuroFi`,
                a.price_euro_fr AS `a.priceEuroFr`,
                a.price_mq_euro_fr AS `a.priceMqEuroFr`,
                a.price_euro_it AS `a.priceEuroIt`,
                a.price_mq_euro_it AS `a.priceMqEuroIt`,
                a.price_euro_ie AS `a.priceEuroIe`,
                a.price_mq_euro_ie AS `a.priceMqEuroIe`,
                a.price_euro_nl AS `a.priceEuroNl`,
                a.price_mq_euro_nl AS `a.priceMqEuroNl`,
                a.price_euro_es AS `a.priceEuroEs`,
                a.price_mq_euro_es AS `a.priceMqEuroEs`,
                a.price_euro_be AS `a.priceEuroBe`,
                a.price_mq_euro_be AS `a.priceMqEuroBe`,
                a.price_rub AS `a.priceRUB`,
                a.price_rue AS `a.priceRUE`,
                a.price_mq_rub AS `a.priceMqRUB`,
                a.price_mq_rue AS `a.priceMqRUE`,
                a.price_gbp AS `a.priceGBP`,
                a.price_gbe AS `a.priceGBE`,
                a.price_mq_gbp AS `a.priceMqGBP`,
                a.price_mq_gbe AS `a.priceMqGBE`,
                a.price_usd AS `a.priceUSD`,
                a.price_use AS `a.priceUSE`,
                a.price_fq_usd AS `a.priceFqUSD`,
                a.price_fq_use AS `a.priceFqUSE`,
                a.price_mq_usd AS `a.priceMqUSD`,
                a.price_mq_use AS `a.priceMqUSE`,
                a.price_chf AS `a.priceCHF`,
                a.price_che AS `a.priceCHE`,
                a.price_mq_chf AS `a.priceMqCHF`,
                a.price_mq_che AS `a.priceMqCHE`,
                a.price_sek AS `a.priceSEK`,
                a.price_see AS `a.priceSEE`,
                a.price_mq_sek AS `a.priceMqSEK`,
                a.price_mq_see AS `a.priceMqSEE`,
                a.price_dkk AS `a.priceDKK`,
                a.price_dke AS `a.priceDKE`,
                a.price_mq_dkk AS `a.priceMqDKK`,
                a.price_mq_dke AS `a.priceMqDKE`,
                a.price_nok AS `a.priceNOK`,
                a.price_noe AS `a.priceNOE`,
                a.price_mq_nok AS `a.priceMqNOK`,
                a.price_mq_noe AS `a.priceMqNOE`,
                a.price_pln AS `a.pricePLN`,
                a.price_ple AS `a.pricePLE`,
                a.price_mq_pln AS `a.priceMqPLN`,
                a.price_mq_ple AS `a.priceMqPLE`,
                a.price_cad AS `a.priceCAD`,
                a.price_cae AS `a.priceCAE`,
                a.price_fq_cad AS `a.priceFqCAD`,
                a.price_fq_cae AS `a.priceFqCAE`,
                a.price_mq_cad AS `a.priceMqCAD`,
                a.price_mq_cae AS `a.priceMqCAE`,
                m.id AS `m.id`,
                m.name AS `m.name`,
                m.alias AS `m.alias`
            FROM
                article a
            LEFT JOIN interior_article ia ON ia.article_id = a.id
            LEFT JOIN interior i ON i.id = ia.interior_id
            LEFT JOIN list_measure m ON m.id = a.measure
            WHERE i.id = '94845' AND a.price_euro > 0 AND a.delivery != 6 AND a.file <> ''  AND m.alias = 'measure_mq' 
            GROUP BY a.id
			ORDER BY a.price_euro ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
15 3.57 ms 
SELECT
                i.id,
                i.name AS `i_name`,
                a.id AS `a.id`,
                a.name AS `a.name`,
                a.price_euro AS `a.priceEuro`,
                a.price_mq_euro AS `a.priceMqEuro`,
                a.price_euro_de AS `a.priceEuroDe`,
                a.price_mq_euro_de AS `a.priceMqEuroDe`,
                a.price_euro_at AS `a.priceEuroAt`,
                a.price_mq_euro_at AS `a.priceMqEuroAt`,
                a.price_euro_fi AS `a.priceEuroFi`,
                a.price_mq_euro_fi AS `a.priceMqEuroFi`,
                a.price_euro_fr AS `a.priceEuroFr`,
                a.price_mq_euro_fr AS `a.priceMqEuroFr`,
                a.price_euro_it AS `a.priceEuroIt`,
                a.price_mq_euro_it AS `a.priceMqEuroIt`,
                a.price_euro_ie AS `a.priceEuroIe`,
                a.price_mq_euro_ie AS `a.priceMqEuroIe`,
                a.price_euro_nl AS `a.priceEuroNl`,
                a.price_mq_euro_nl AS `a.priceMqEuroNl`,
                a.price_euro_es AS `a.priceEuroEs`,
                a.price_mq_euro_es AS `a.priceMqEuroEs`,
                a.price_euro_be AS `a.priceEuroBe`,
                a.price_mq_euro_be AS `a.priceMqEuroBe`,
                a.price_rub AS `a.priceRUB`,
                a.price_rue AS `a.priceRUE`,
                a.price_mq_rub AS `a.priceMqRUB`,
                a.price_mq_rue AS `a.priceMqRUE`,
                a.price_gbp AS `a.priceGBP`,
                a.price_gbe AS `a.priceGBE`,
                a.price_mq_gbp AS `a.priceMqGBP`,
                a.price_mq_gbe AS `a.priceMqGBE`,
                a.price_usd AS `a.priceUSD`,
                a.price_use AS `a.priceUSE`,
                a.price_fq_usd AS `a.priceFqUSD`,
                a.price_fq_use AS `a.priceFqUSE`,
                a.price_mq_usd AS `a.priceMqUSD`,
                a.price_mq_use AS `a.priceMqUSE`,
                a.price_chf AS `a.priceCHF`,
                a.price_che AS `a.priceCHE`,
                a.price_mq_chf AS `a.priceMqCHF`,
                a.price_mq_che AS `a.priceMqCHE`,
                a.price_sek AS `a.priceSEK`,
                a.price_see AS `a.priceSEE`,
                a.price_mq_sek AS `a.priceMqSEK`,
                a.price_mq_see AS `a.priceMqSEE`,
                a.price_dkk AS `a.priceDKK`,
                a.price_dke AS `a.priceDKE`,
                a.price_mq_dkk AS `a.priceMqDKK`,
                a.price_mq_dke AS `a.priceMqDKE`,
                a.price_nok AS `a.priceNOK`,
                a.price_noe AS `a.priceNOE`,
                a.price_mq_nok AS `a.priceMqNOK`,
                a.price_mq_noe AS `a.priceMqNOE`,
                a.price_pln AS `a.pricePLN`,
                a.price_ple AS `a.pricePLE`,
                a.price_mq_pln AS `a.priceMqPLN`,
                a.price_mq_ple AS `a.priceMqPLE`,
                a.price_cad AS `a.priceCAD`,
                a.price_cae AS `a.priceCAE`,
                a.price_fq_cad AS `a.priceFqCAD`,
                a.price_fq_cae AS `a.priceFqCAE`,
                a.price_mq_cad AS `a.priceMqCAD`,
                a.price_mq_cae AS `a.priceMqCAE`,
                m.id AS `m.id`,
                m.name AS `m.name`,
                m.alias AS `m.alias`
            FROM
                article a
            LEFT JOIN interior_article ia ON ia.article_id = a.id
            LEFT JOIN interior i ON i.id = ia.interior_id
            LEFT JOIN list_measure m ON m.id = a.measure
            WHERE i.id = '94845' AND a.price_euro > 0 AND a.delivery != 6 AND a.file <> '' 
            GROUP BY a.id
			ORDER BY a.price_euro ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
16 5.74 ms 
SELECT
                i.id,
                i.name AS `i_name`,
                a.id AS `a.id`,
                a.name AS `a.name`,
                a.price_euro AS `a.priceEuro`,
                a.price_mq_euro AS `a.priceMqEuro`,
                a.price_euro_de AS `a.priceEuroDe`,
                a.price_mq_euro_de AS `a.priceMqEuroDe`,
                a.price_euro_at AS `a.priceEuroAt`,
                a.price_mq_euro_at AS `a.priceMqEuroAt`,
                a.price_euro_fi AS `a.priceEuroFi`,
                a.price_mq_euro_fi AS `a.priceMqEuroFi`,
                a.price_euro_fr AS `a.priceEuroFr`,
                a.price_mq_euro_fr AS `a.priceMqEuroFr`,
                a.price_euro_it AS `a.priceEuroIt`,
                a.price_mq_euro_it AS `a.priceMqEuroIt`,
                a.price_euro_ie AS `a.priceEuroIe`,
                a.price_mq_euro_ie AS `a.priceMqEuroIe`,
                a.price_euro_nl AS `a.priceEuroNl`,
                a.price_mq_euro_nl AS `a.priceMqEuroNl`,
                a.price_euro_es AS `a.priceEuroEs`,
                a.price_mq_euro_es AS `a.priceMqEuroEs`,
                a.price_euro_be AS `a.priceEuroBe`,
                a.price_mq_euro_be AS `a.priceMqEuroBe`,
                a.price_rub AS `a.priceRUB`,
                a.price_rue AS `a.priceRUE`,
                a.price_mq_rub AS `a.priceMqRUB`,
                a.price_mq_rue AS `a.priceMqRUE`,
                a.price_gbp AS `a.priceGBP`,
                a.price_gbe AS `a.priceGBE`,
                a.price_mq_gbp AS `a.priceMqGBP`,
                a.price_mq_gbe AS `a.priceMqGBE`,
                a.price_usd AS `a.priceUSD`,
                a.price_use AS `a.priceUSE`,
                a.price_fq_usd AS `a.priceFqUSD`,
                a.price_fq_use AS `a.priceFqUSE`,
                a.price_mq_usd AS `a.priceMqUSD`,
                a.price_mq_use AS `a.priceMqUSE`,
                a.price_chf AS `a.priceCHF`,
                a.price_che AS `a.priceCHE`,
                a.price_mq_chf AS `a.priceMqCHF`,
                a.price_mq_che AS `a.priceMqCHE`,
                a.price_sek AS `a.priceSEK`,
                a.price_see AS `a.priceSEE`,
                a.price_mq_sek AS `a.priceMqSEK`,
                a.price_mq_see AS `a.priceMqSEE`,
                a.price_dkk AS `a.priceDKK`,
                a.price_dke AS `a.priceDKE`,
                a.price_mq_dkk AS `a.priceMqDKK`,
                a.price_mq_dke AS `a.priceMqDKE`,
                a.price_nok AS `a.priceNOK`,
                a.price_noe AS `a.priceNOE`,
                a.price_mq_nok AS `a.priceMqNOK`,
                a.price_mq_noe AS `a.priceMqNOE`,
                a.price_pln AS `a.pricePLN`,
                a.price_ple AS `a.pricePLE`,
                a.price_mq_pln AS `a.priceMqPLN`,
                a.price_mq_ple AS `a.priceMqPLE`,
                a.price_cad AS `a.priceCAD`,
                a.price_cae AS `a.priceCAE`,
                a.price_fq_cad AS `a.priceFqCAD`,
                a.price_fq_cae AS `a.priceFqCAE`,
                a.price_mq_cad AS `a.priceMqCAD`,
                a.price_mq_cae AS `a.priceMqCAE`,
                m.id AS `m.id`,
                m.name AS `m.name`,
                m.alias AS `m.alias`
            FROM
                article a
            LEFT JOIN interior_article ia ON ia.article_id = a.id
            LEFT JOIN interior i ON i.id = ia.interior_id
            LEFT JOIN list_measure m ON m.id = a.measure
            WHERE i.id = '94846' AND a.price_euro > 0 AND a.delivery != 6 AND a.file <> ''  AND m.alias = 'measure_mq' 
            GROUP BY a.id
			ORDER BY a.price_euro ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
17 5.33 ms 
SELECT
                i.id,
                i.name AS `i_name`,
                a.id AS `a.id`,
                a.name AS `a.name`,
                a.price_euro AS `a.priceEuro`,
                a.price_mq_euro AS `a.priceMqEuro`,
                a.price_euro_de AS `a.priceEuroDe`,
                a.price_mq_euro_de AS `a.priceMqEuroDe`,
                a.price_euro_at AS `a.priceEuroAt`,
                a.price_mq_euro_at AS `a.priceMqEuroAt`,
                a.price_euro_fi AS `a.priceEuroFi`,
                a.price_mq_euro_fi AS `a.priceMqEuroFi`,
                a.price_euro_fr AS `a.priceEuroFr`,
                a.price_mq_euro_fr AS `a.priceMqEuroFr`,
                a.price_euro_it AS `a.priceEuroIt`,
                a.price_mq_euro_it AS `a.priceMqEuroIt`,
                a.price_euro_ie AS `a.priceEuroIe`,
                a.price_mq_euro_ie AS `a.priceMqEuroIe`,
                a.price_euro_nl AS `a.priceEuroNl`,
                a.price_mq_euro_nl AS `a.priceMqEuroNl`,
                a.price_euro_es AS `a.priceEuroEs`,
                a.price_mq_euro_es AS `a.priceMqEuroEs`,
                a.price_euro_be AS `a.priceEuroBe`,
                a.price_mq_euro_be AS `a.priceMqEuroBe`,
                a.price_rub AS `a.priceRUB`,
                a.price_rue AS `a.priceRUE`,
                a.price_mq_rub AS `a.priceMqRUB`,
                a.price_mq_rue AS `a.priceMqRUE`,
                a.price_gbp AS `a.priceGBP`,
                a.price_gbe AS `a.priceGBE`,
                a.price_mq_gbp AS `a.priceMqGBP`,
                a.price_mq_gbe AS `a.priceMqGBE`,
                a.price_usd AS `a.priceUSD`,
                a.price_use AS `a.priceUSE`,
                a.price_fq_usd AS `a.priceFqUSD`,
                a.price_fq_use AS `a.priceFqUSE`,
                a.price_mq_usd AS `a.priceMqUSD`,
                a.price_mq_use AS `a.priceMqUSE`,
                a.price_chf AS `a.priceCHF`,
                a.price_che AS `a.priceCHE`,
                a.price_mq_chf AS `a.priceMqCHF`,
                a.price_mq_che AS `a.priceMqCHE`,
                a.price_sek AS `a.priceSEK`,
                a.price_see AS `a.priceSEE`,
                a.price_mq_sek AS `a.priceMqSEK`,
                a.price_mq_see AS `a.priceMqSEE`,
                a.price_dkk AS `a.priceDKK`,
                a.price_dke AS `a.priceDKE`,
                a.price_mq_dkk AS `a.priceMqDKK`,
                a.price_mq_dke AS `a.priceMqDKE`,
                a.price_nok AS `a.priceNOK`,
                a.price_noe AS `a.priceNOE`,
                a.price_mq_nok AS `a.priceMqNOK`,
                a.price_mq_noe AS `a.priceMqNOE`,
                a.price_pln AS `a.pricePLN`,
                a.price_ple AS `a.pricePLE`,
                a.price_mq_pln AS `a.priceMqPLN`,
                a.price_mq_ple AS `a.priceMqPLE`,
                a.price_cad AS `a.priceCAD`,
                a.price_cae AS `a.priceCAE`,
                a.price_fq_cad AS `a.priceFqCAD`,
                a.price_fq_cae AS `a.priceFqCAE`,
                a.price_mq_cad AS `a.priceMqCAD`,
                a.price_mq_cae AS `a.priceMqCAE`,
                m.id AS `m.id`,
                m.name AS `m.name`,
                m.alias AS `m.alias`
            FROM
                article a
            LEFT JOIN interior_article ia ON ia.article_id = a.id
            LEFT JOIN interior i ON i.id = ia.interior_id
            LEFT JOIN list_measure m ON m.id = a.measure
            WHERE i.id = '94846' AND a.price_euro > 0 AND a.delivery != 6 AND a.file <> '' 
            GROUP BY a.id
			ORDER BY a.price_euro ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
18 0.74 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
19 3.65 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 ('С000308740')
Parameters: 
[]
View formatted query    View runnable query    Explain query
20 0.25 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: 
[
  "ce121a2c0e60d4937df7611a1b713ec99f17b2a911cea429f0c6e6a4f4362d6f"
]
View formatted query    View runnable query    Explain query
21 1.37 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: 
[
  "ce121a2c0e60d4937df7611a1b713ec99f17b2a911cea429f0c6e6a4f4362d6f"
]
View formatted query    View runnable query    Explain query
22 0.95 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: 
[
  "ce121a2c0e60d4937df7611a1b713ec99f17b2a911cea429f0c6e6a4f4362d6f"
]
View formatted query    View runnable query    Explain query
23 0.50 ms 
SELECT b0_.`id` AS id_0 FROM `buy_order` b0_ WHERE b0_.`token` = ? AND b0_.`status` <> 12
Parameters: 
[
  "ce121a2c0e60d4937df7611a1b713ec99f17b2a911cea429f0c6e6a4f4362d6f"
]
View formatted query    View runnable query    Explain query
24 2.45 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: 
[
  "ce121a2c0e60d4937df7611a1b713ec99f17b2a911cea429f0c6e6a4f4362d6f"
]
View formatted query    View runnable query    Explain query
25 2.44 ms 
SELECT COUNT(v0_.`id`) AS sclr_0 FROM `visit` v0_ WHERE v0_.`token` = ? AND v0_.`url` <> '/.*catalog.*/'
Parameters: 
[
  "ce121a2c0e60d4937df7611a1b713ec99f17b2a911cea429f0c6e6a4f4362d6f"
]
View formatted query    View runnable query    Explain query
26 2.37 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: 
[
  "ce121a2c0e60d4937df7611a1b713ec99f17b2a911cea429f0c6e6a4f4362d6f"
]
View formatted query    View runnable query    Explain query
27 70.88 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
28 0.31 ms 
SELECT COUNT(f0_.`id`) AS sclr_0 FROM `filters` f0_ LEFT JOIN `factory` f1_ ON f0_.brand = f1_.id LEFT JOIN `filter_params` f2_ ON f0_.param_id = f2_.id WHERE f0_.brand IS NOT NULL AND f0_.`id` <> 10639 AND f1_.`status` = ? AND f2_.`is_enable` = 1 AND f2_.`count` >= 0 AND f1_.`unid` IS NOT NULL AND f1_.`test_access` IS NULL ORDER BY f0_.`name` ASC
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
29 0.29 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
30 2.09 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
31 0.41 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: 
[
  "ce121a2c0e60d4937df7611a1b713ec99f17b2a911cea429f0c6e6a4f4362d6f"
]
View formatted query    View runnable query    Explain query
32 0.36 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: 
[
  "ce121a2c0e60d4937df7611a1b713ec99f17b2a911cea429f0c6e6a4f4362d6f"
]
View formatted query    View runnable query    Explain query
33 0.18 ms 
SELECT b0_.`id` AS id_0 FROM `buy_order` b0_ WHERE b0_.`token` = ? AND b0_.`status` <> 12
Parameters: 
[
  "ce121a2c0e60d4937df7611a1b713ec99f17b2a911cea429f0c6e6a4f4362d6f"
]
View formatted query    View runnable query    Explain query
34 0.21 ms 
SELECT COUNT(v0_.`id`) AS sclr_0 FROM `visit` v0_ WHERE v0_.`token` = ? AND v0_.`url` <> '/.*catalog.*/'
Parameters: 
[
  "ce121a2c0e60d4937df7611a1b713ec99f17b2a911cea429f0c6e6a4f4362d6f"
]
View formatted query    View runnable query    Explain query
35 0.16 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: 
[
  "ce121a2c0e60d4937df7611a1b713ec99f17b2a911cea429f0c6e6a4f4362d6f"
]
View formatted query    View runnable query    Explain query
36 0.37 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
37 0.86 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: 
[
  "ce121a2c0e60d4937df7611a1b713ec99f17b2a911cea429f0c6e6a4f4362d6f"
]
View formatted query    View runnable query    Explain query
38 0.39 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\ListStyle No errors.
WebBundle\Entity\ListTexture No errors.
WebBundle\Entity\ListApply No errors.
WebBundle\Entity\ArticleDetail No errors.
WebBundle\Entity\ListColor 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\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\InteriorArticle 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.

oneC entity manager

No loaded entities.

logs entity manager

No loaded entities.