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

Method
GET
HTTP Status
200
IP
216.73.216.124
Profiled on
Token
4cd54f

Query Metrics

357 Database Queries
67 Different statements
446.80 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

default connection

Time▼ Count Info
69.84 ms
(0.00%) 		30 
SELECT a0_.`id` AS id_0, a0_.`code` AS code_1, a0_.`alternate_name` AS alternate_name_2, a0_.`urla` AS urla_3, a1_.`file` AS file_4, a0_.`price_euro` AS price_euro_5, a0_.`price_usd` AS price_usd_6, a0_.`price_prx` AS price_prx_7, a0_.`size_x` AS size_x_8, a0_.`size_y` AS size_y_9, a0_.`size_gb_x` AS size_gb_x_10, a0_.`size_gb_y` AS size_gb_y_11, a0_.`thick` AS thick_12, a0_.`weight` AS weight_13, a1_.`file_size2_x` AS file_size2_x_14, a1_.`file_size2_y` AS file_size2_y_15, l2_.`alias` AS alias_16, l3_.`alias` AS alias_17, l4_.`alias` AS alias_18, l5_.`alias` AS alias_19, l6_.`alias` AS alias_20, l7_.`alias` AS alias_21, c8_.`code` AS code_22, c8_.`name` AS name_23, c8_.`alternate_name` AS alternate_name_24, c8_.`url` AS url_25, f9_.`name` AS name_26, f9_.`url` AS url_27, l10_.`alias` AS alias_28, l11_.`alias` AS alias_29, l12_.`alias` AS alias_30 FROM `article` a0_ LEFT JOIN `list_type` l2_ ON a0_.type = l2_.id LEFT JOIN `list_edge_type` l3_ ON a0_.edge_type = l3_.id LEFT JOIN `list_shape` l4_ ON a0_.shape = l4_.id LEFT JOIN `list_material` l5_ ON a0_.material = l5_.id LEFT JOIN `list_sliding` l6_ ON a0_.sliding = l6_.id LEFT JOIN `list_off_shade` l7_ ON a0_.off_shade = l7_.id LEFT JOIN `list_using` l10_ ON a0_.using = l10_.id LEFT JOIN `collection` c8_ ON a0_.collection = c8_.id LEFT JOIN `list_price` l12_ ON a0_.category_price = l12_.id LEFT JOIN `list_delivery` l13_ ON a0_.delivery = l13_.id LEFT JOIN `article_detail` a1_ ON a0_.id = a1_.article_id LEFT JOIN `factory` f9_ ON c8_.factory = f9_.id LEFT JOIN `list_country` l11_ ON f9_.country = l11_.id WHERE c8_.`id` IS NOT NULL AND l13_.`id` <> 6 AND a0_.`price_euro` > 0 AND c8_.`status` IN (1, 2, 3, 4, 7) AND (c8_.`url` IS NOT NULL AND c8_.`url` <> '') AND f9_.`status` = 1 AND a1_.`file` IS NOT NULL AND a0_.`id` IN (?)
Parameters: 
[
  [
    "32149416"
  ]
]
View formatted query    View runnable query    Explain query
40.02 ms
(0.00%) 		29 
SELECT a0_.`id` AS id_0, l1_.`alias` AS alias_1 FROM `article` a0_ INNER JOIN article_color a2_ ON a0_.id = a2_.article_id INNER JOIN `list_color` l1_ ON l1_.id = a2_.color_id WHERE a0_.`id` IN (?)
Parameters: 
[
  [
    32149416
  ]
]
View formatted query    View runnable query    Explain query
37.73 ms
(0.00%) 		29 
SELECT a0_.`id` AS id_0, l1_.`alias` AS alias_1 FROM `article` a0_ INNER JOIN article_texture a2_ ON a0_.id = a2_.article_id INNER JOIN `list_texture` l1_ ON l1_.id = a2_.texture_id WHERE a0_.`id` IN (?)
Parameters: 
[
  [
    32149416
  ]
]
View formatted query    View runnable query    Explain query
33.35 ms
(0.00%) 		29 
SELECT a0_.`id` AS id_0, f1_.`name_single_en` AS name_single_en_1, f1_.`name_single_it` AS name_single_it_2, f1_.`name_single_es` AS name_single_es_3, f1_.`name_single_fr` AS name_single_fr_4, f1_.`name_single_de` AS name_single_de_5, f1_.`name_single_pl` AS name_single_pl_6, f1_.`name_single_ua` AS name_single_ua_7, f1_.`name_single_ru` AS name_single_ru_8, f1_.`name_single_sv` AS name_single_sv_9, f1_.`name_single_da` AS name_single_da_10 FROM `article` a0_ LEFT JOIN `collection` c2_ ON a0_.collection = c2_.id LEFT JOIN collection_filters c4_ ON c2_.id = c4_.collection_id LEFT JOIN `filters` f3_ ON f3_.id = c4_.filter_id LEFT JOIN `filter_pages` f1_ ON f3_.page_id = f1_.id INNER JOIN `filter_groups` f5_ ON f3_.group_id = f5_.id AND (f5_.`id` = 419) WHERE a0_.`id` IN (?)
Parameters: 
[
  [
    32149416
  ]
]
View formatted query    View runnable query    Explain query
33.17 ms
(0.00%) 		29 
SELECT a0_.`id` AS id_0, l1_.`alias` AS alias_1 FROM `article` a0_ INNER JOIN article_style a2_ ON a0_.id = a2_.article_id INNER JOIN `list_style` l1_ ON l1_.id = a2_.style_id WHERE a0_.`id` IN (?)
Parameters: 
[
  [
    32149416
  ]
]
View formatted query    View runnable query    Explain query
30.01 ms
(0.00%) 		2 
SELECT t0.`id` AS id_1, t0.`unid` AS unid_2, t0.`code` AS code_3, t0.`name` AS name_4, t0.`alternate_name` AS alternate_name_5, t0.`name_full` AS name_full_6, t0.`url` AS url_7, t0.`status` AS status_8, t0.`type` AS type_9, t0.`typeSet` AS typeSet_10, t0.`pc_as_m` AS pc_as_m_11, t0.`publish_date` AS publish_date_12, t0.`update_date` AS update_date_13, t0.`archive` AS archive_14, t0.`pr_min_euro` AS pr_min_euro_15, t0.`pr_min_euro_de` AS pr_min_euro_de_16, t0.`pr_min_euro_at` AS pr_min_euro_at_17, t0.`pr_min_euro_fi` AS pr_min_euro_fi_18, t0.`pr_min_euro_fr` AS pr_min_euro_fr_19, t0.`pr_min_euro_it` AS pr_min_euro_it_20, t0.`pr_min_euro_be` AS pr_min_euro_be_21, t0.`pr_min_euro_ie` AS pr_min_euro_ie_22, t0.`pr_min_euro_nl` AS pr_min_euro_nl_23, t0.`pr_min_euro_es` AS pr_min_euro_es_24, t0.`pr_min_rub` AS pr_min_rub_25, t0.`pr_min_rue` AS pr_min_rue_26, t0.`pr_min_gbp` AS pr_min_gbp_27, t0.`pr_min_gbe` AS pr_min_gbe_28, t0.`pr_min_usd` AS pr_min_usd_29, t0.`pr_min_use` AS pr_min_use_30, t0.`pr_min_f_usd` AS pr_min_f_usd_31, t0.`pr_min_f_use` AS pr_min_f_use_32, t0.`pr_min_chf` AS pr_min_chf_33, t0.`pr_min_che` AS pr_min_che_34, t0.`pr_min_sek` AS pr_min_sek_35, t0.`pr_min_see` AS pr_min_see_36, t0.`pr_min_dkk` AS pr_min_dkk_37, t0.`pr_min_dke` AS pr_min_dke_38, t0.`pr_min_nok` AS pr_min_nok_39, t0.`pr_min_noe` AS pr_min_noe_40, t0.`pr_min_pln` AS pr_min_pln_41, t0.`pr_min_ple` AS pr_min_ple_42, t0.`pr_min_cad` AS pr_min_cad_43, t0.`pr_min_cae` AS pr_min_cae_44, t0.`pr_min_f_cad` AS pr_min_f_cad_45, t0.`pr_min_f_cae` AS pr_min_f_cae_46, t0.`pr_min_ed` AS pr_min_ed_47, t0.`important` AS important_48, t0.`author` AS author_49, t0.`author_id` AS author_id_50, t0.`rating` AS rating_51, t0.`header` AS header_52, t0.`settings` AS settings_53, t0.`fids` AS fids_54, t0.`portal_unid` AS portal_unid_55, t0.`accepted_at` AS accepted_at_56, t0.`accept_state` AS accept_state_57, t0.`description_edit` AS description_edit_58, t0.`link_award` AS link_award_59, t0.`awards` AS awards_60, t0.`video` AS video_61, t0.`stated_at` AS stated_at_62, t0.`state` AS state_63, t0.`description_state` AS description_state_64, t0.`body_hide` AS body_hide_65, t0.`release_year` AS release_year_66, t0.`site` AS site_67, t0.`show_main` AS show_main_68, t0.`glue_url` AS glue_url_69, t0.`accessible` AS accessible_70, t0.`delivery_suspended` AS delivery_suspended_71, t0.`process` AS process_72, t0.`exhibition` AS exhibition_73, t0.`test_access` AS test_access_74, t0.`views` AS views_75, t0.`comment_unid` AS comment_unid_76, t0.`accesible_at` AS accesible_at_77, t0.`created_at` AS created_at_78, t0.`updated_at` AS updated_at_79, t0.factory AS factory_80, t0.category_price AS category_price_81, t82.`id` AS id_83, t82.`source` AS source_84, t82.`ru` AS ru_85, t82.`en` AS en_86, t82.`it` AS it_87, t82.`es` AS es_88, t82.`fr` AS fr_89, t82.`de` AS de_90, t82.`pl` AS pl_91, t82.`pt` AS pt_92, t82.`nl` AS nl_93, t82.`fi` AS fi_94, t82.`ua` AS ua_95, t82.`sv` AS sv_96, t82.`no` AS no_97, t82.`da` AS da_98, t82.`cn` AS cn_99, t82.`zh` AS zh_100, t82.`created_at` AS created_at_101, t82.`updated_at` AS updated_at_102, t82.email_body_id AS email_body_id_103, t82.publication_body_id AS publication_body_id_104, t82.static_page_body_id AS static_page_body_id_105, t82.collection_body_id AS collection_body_id_106, t82.trans_val_id AS trans_val_id_107, t82.exh_text_id AS exh_text_id_108, t82.exh_brand_text_id AS exh_brand_text_id_109, t82.exh_collection_text_id AS exh_collection_text_id_110, t82.filter_html_id AS filter_html_id_111, t112.`id` AS id_113, t112.`source` AS source_114, t112.`ru` AS ru_115, t112.`en` AS en_116, t112.`it` AS it_117, t112.`es` AS es_118, t112.`fr` AS fr_119, t112.`de` AS de_120, t112.`pl` AS pl_121, t112.`pt` AS pt_122, t112.`nl` AS nl_123, t112.`fi` AS fi_124, t112.`ua` AS ua_125, t112.`sv` AS sv_126, t112.`no` AS no_127, t112.`da` AS da_128, t112.`cn` AS cn_129, t112.`zh` AS zh_130, t112.`created_at` AS created_at_131, t112.`updated_at` AS updated_at_132, t112.static_page_title_id AS static_page_title_id_133, t112.static_page_keywords_id AS static_page_keywords_id_134, t112.static_page_description_id AS static_page_description_id_135, t112.collection_keywords_id AS collection_keywords_id_136, t112.collection_description_id AS collection_description_id_137, t112.blog_keywords_id AS blog_keywords_id_138, t112.blog_description_id AS blog_description_id_139, t112.exh_keywords_id AS exh_keywords_id_140, t112.exh_description_id AS exh_description_id_141, t142.`id` AS id_143, t142.`source` AS source_144, t142.`ru` AS ru_145, t142.`en` AS en_146, t142.`it` AS it_147, t142.`es` AS es_148, t142.`fr` AS fr_149, t142.`de` AS de_150, t142.`pl` AS pl_151, t142.`pt` AS pt_152, t142.`nl` AS nl_153, t142.`fi` AS fi_154, t142.`ua` AS ua_155, t142.`sv` AS sv_156, t142.`no` AS no_157, t142.`da` AS da_158, t142.`cn` AS cn_159, t142.`zh` AS zh_160, t142.`created_at` AS created_at_161, t142.`updated_at` AS updated_at_162, t142.static_page_title_id AS static_page_title_id_163, t142.static_page_keywords_id AS static_page_keywords_id_164, t142.static_page_description_id AS static_page_description_id_165, t142.collection_keywords_id AS collection_keywords_id_166, t142.collection_description_id AS collection_description_id_167, t142.blog_keywords_id AS blog_keywords_id_168, t142.blog_description_id AS blog_description_id_169, t142.exh_keywords_id AS exh_keywords_id_170, t142.exh_description_id AS exh_description_id_171 FROM `collection` t0 LEFT JOIN `locale_html` t82 ON t82.collection_body_id = t0.id LEFT JOIN `locale_meta` t112 ON t112.collection_keywords_id = t0.id LEFT JOIN `locale_meta` t142 ON t142.collection_description_id = t0.id WHERE t0.factory = ?
Parameters: 
[
  75
]
View formatted query    View runnable query    Explain query
28.70 ms
(0.00%) 		29 
SELECT a0_.`id` AS id_0, l1_.`alias` AS alias_1 FROM `article` a0_ INNER JOIN article_surface a2_ ON a0_.id = a2_.article_id INNER JOIN `list_surface` l1_ ON l1_.id = a2_.surface_id WHERE a0_.`id` IN (?)
Parameters: 
[
  [
    32149416
  ]
]
View formatted query    View runnable query    Explain query
27.74 ms
(0.00%) 		29 
SELECT a0_.`id` AS id_0, l1_.`alias` AS alias_1 FROM `article` a0_ INNER JOIN article_motiv a2_ ON a0_.id = a2_.article_id INNER JOIN `list_motiv` l1_ ON l1_.id = a2_.motiv_id WHERE a0_.`id` IN (?)
Parameters: 
[
  [
    32149416
  ]
]
View formatted query    View runnable query    Explain query
23.76 ms
(0.00%) 		29 
SELECT a0_.`id` AS id_0, f1_.`name` AS name_1 FROM `article` a0_ LEFT JOIN `collection` c2_ ON a0_.collection = c2_.id LEFT JOIN collection_filters c3_ ON c2_.id = c3_.collection_id LEFT JOIN `filters` f1_ ON f1_.id = c3_.filter_id INNER JOIN `filter_groups` f4_ ON f1_.group_id = f4_.id AND (f4_.`id` = 420) WHERE a0_.`id` IN (?)
Parameters: 
[
  [
    32149416
  ]
]
View formatted query    View runnable query    Explain query
17.99 ms
(0.00%) 		1 
SELECT f.id, f.rank AS `rank`, f.alt_name AS `altName`, f.old_command AS `sphinxName`, f.old_id AS `sphinxId`, htmlshow.de AS `isHtmlShow`, fp.name_menu_de AS `nameMenu`, fp.name_many_de AS `nameMany`, fp.name_single_de AS `nameSingle`, fp.html_de AS `html`, fp.description_de AS `description`, metadesc.de AS `metaDescriptionName`, par.count AS `count`, par.code AS `code`, par.is_enable AS `isEnable`, gr.id AS `groupId`, gr.alt_name AS `groupAltName`, gpname.de AS `groupName`, url.de AS `slug`, url.ru AS `slug.ru`, url.en AS `slug.en`, url.it AS `slug.it`, url.es AS `slug.es`, url.fr AS `slug.fr`, url.de AS `slug.de`, url.pl AS `slug.pl`, url.nl AS `slug.nl`, url.fi AS `slug.fi`, url.sv AS `slug.sv`, b.id AS `brandId`, b.status AS `brandStatus`, b.stated_at AS `brandStatedAt`, b.type AS `brandType`, b.name AS `brandName`, f.logo AS `brandLogo`, f.logo_url AS `brandLogoUrl`, b.sound AS `brandSound`, b.video AS `brandVideo`, cn.id AS `countryId`, cnfp.name_single_de AS `countryName`, cnurl.de AS `countrySlug`, cnpar.code AS `countryCode` FROM filters f LEFT JOIN filter_pages fp ON fp.id = f.page_id LEFT JOIN filter_params par ON par.id = f.param_id LEFT JOIN filter_groups gr ON gr.id = f.group_id LEFT JOIN locale_text gpname ON gpname.filter_group_name = gr.id LEFT JOIN locale_text metadesc ON metadesc.filter_name_for_meta_descr_id = f.id LEFT JOIN locale_url url ON url.filter_id = f.id LEFT JOIN locale_bool htmlshow ON htmlshow.filter_html_show_id = f.id LEFT JOIN factory b ON b.id = f.brand LEFT JOIN filters cn ON cn.id = f.country_id LEFT JOIN filter_pages cnfp ON cnfp.id = cn.page_id LEFT JOIN locale_url cnurl ON cnurl.filter_id = cn.id LEFT JOIN filter_params cnpar ON cnpar.id = cn.param_id WHERE url.ru = :slug OR url.en = :slug OR url.it = :slug OR url.es = :slug OR url.fr = :slug OR url.de = :slug OR url.pl = :slug OR url.nl = :slug OR url.fi = :slug OR url.sv = :slug
Parameters: 
[
  "slug" => "marazzi"
]
View formatted query    View runnable query    Explain query
17.61 ms
(0.00%) 		29 
SELECT DISTINCT a0_.`id` AS id_0, l1_.`alias` AS alias_1 FROM `article` a0_ LEFT JOIN interior_article i3_ ON a0_.id = i3_.article_id LEFT JOIN `interior` i2_ ON i2_.id = i3_.interior_id INNER JOIN interior_apply i4_ ON i2_.id = i4_.interior_id INNER JOIN `list_apply` l1_ ON l1_.id = i4_.apply_id WHERE a0_.`id` IN (?)
Parameters: 
[
  [
    32149416
  ]
]
View formatted query    View runnable query    Explain query
16.53 ms
(0.00%) 		29 
SELECT a0_.`id` AS id_0, f1_.`name` AS name_1 FROM `article` a0_ LEFT JOIN `collection` c2_ ON a0_.collection = c2_.id LEFT JOIN collection_filters c3_ ON c2_.id = c3_.collection_id LEFT JOIN `filters` f1_ ON f1_.id = c3_.filter_id INNER JOIN `filter_groups` f4_ ON f1_.group_id = f4_.id AND (f4_.`id` = 417 AND f1_.`id` <> 10546) WHERE a0_.`id` IN (?)
Parameters: 
[
  [
    32149416
  ]
]
View formatted query    View runnable query    Explain query
4.99 ms
(0.00%) 		6 
SELECT
    f2.id,
    f2.name,
    f2.old_command,
    f2.old_id,
    GROUP_CONCAT(f.id) AS ids,
    GROUP_CONCAT(f.old_id) AS old_ids
FROM
    `filters` f
LEFT JOIN filters f2 ON
    f.parent_id = f2.id
LEFT JOIN filter_params p ON
    f.param_id = p.id
WHERE
    f.parent_id IS NOT NULL AND p.is_enable = 1  AND p.show_menu != 0  
GROUP BY
    f.parent_id;
Parameters: 
[]
View formatted query    View runnable query    Explain query
4.73 ms
(0.00%) 		1 
SELECT
                i.id AS iId,
                i.url AS iUrl,
                i.name AS iName,
                i.alt AS iAlt,
                i.file AS iFile,
                i.status AS iStatus,
                i.file_size_x AS iFileSizeX,
                i.file_size_y AS iFileSizeY,
                i.file_size_z_x AS iFileSizeZX,
                i.file_size_z_y AS iFileSizeZY,
                i.file_size_hd_x AS iFileSizeHdX,
                i.file_size_hd_y AS iFileSizeHdY,
                i.file_size_shd_x AS iFileSizeShdX,
                i.file_size_shd_y AS iFileSizeShdY,
                i.file_size4k_x AS iFileSize4kX,
                i.file_size4k_y AS iFileSize4kY,
                c.id AS cId,
                c.url AS cUrl,
                c.status AS cStatus,
                c.name AS cName,
                c.alternate_name AS cAName,
                c.pr_min_euro AS prMinEuro,
                c.pr_min_euro_de AS prMinEuroDe,
                c.pr_min_euro_fr AS prMinEuroFr,
                c.pr_min_euro_it AS prMinEuroIt,
                c.pr_min_euro_be AS prMinEuroBe,
                c.pr_min_euro_ie AS prMinEuroIe,
                c.pr_min_euro_nl AS prMinEuroNl,
                c.pr_min_euro_es AS prMinEuroEs,
                c.pr_min_rue AS prMinRUB,
                c.pr_min_rue AS prMinRUE,
                c.pr_min_gbp AS prMinGBP,
                c.pr_min_gbe AS prMinGBE,
                c.pr_min_usd AS prMinUSD,
                c.pr_min_use AS prMinUSE,
                c.pr_min_f_usd AS prMinFUSD,
                c.pr_min_f_use AS prMinFUSE,
                c.pr_min_chf AS prMinCHF,
                c.pr_min_che AS prMinCHE,
                c.pr_min_sek AS prMinSEK,
                c.pr_min_see AS prMinSEE,
                c.pr_min_dkk AS prMinDKK,
                c.pr_min_dke AS prMinDKE,
                c.pr_min_nok AS prMinNOK,
                c.pr_min_noe AS prMinNOE,
                c.pr_min_pln AS prMinPLN,
                c.pr_min_ple AS prMinPLE,
                c.pr_min_cad AS prMinCAD,
                c.pr_min_cae AS prMinCAE,
                c.pr_min_f_cad AS prMinEuroFCAD,
                c.pr_min_f_cae AS prMinEuroFCAE,
                f.id AS fId,
                f.url AS fUrl,
                f.status AS fStatus,
                f.name AS fName,
                f.alternate_name AS fAName,
                f.suspended AS fSuspended,
                a.id AS itemId,
                lc.id AS lcId,
                lc.code AS lcCode,
                lc.alias AS lcAlias,
                la.id AS laId,
                la.alias AS laAlias,
                lst.id AS lstId,
                lst.alias AS lstAlias,
                lt.id AS ltId,
                lt.alias AS ltAlias,
                (SELECT COUNT(ii.idea_id) FROM `idea_interior` ii WHERE `ii`.`interior_id` = `i`.id) AS ideaCount
            FROM interior i
            LEFT JOIN collection c ON c.id = i.collection
            LEFT JOIN factory f ON f.id = c.factory
            LEFT JOIN interior_article iat ON iat.interior_id = i.id
            LEFT JOIN article a ON a.id = iat.article_id
            LEFT JOIN list_country lc ON lc.id = f.country
            LEFT JOIN interior_apply ia ON ia.interior_id = i.id
            LEFT JOIN list_apply la ON la.id = ia.apply_id
            LEFT JOIN interior_texture it ON it.interior_id = i.id
            LEFT JOIN list_texture lt ON lt.id = it.texture_id
            LEFT JOIN interior_style ist ON ist.interior_id = i.id
            LEFT JOIN list_style lst ON lst.id = ist.style_id
            WHERE c.id = 3246445 AND i.status = 1
         AND i.id IN (177464, 177465, 177466)
Parameters: 
[]
View formatted query    View runnable query    Explain query
3.75 ms
(0.00%) 		1 
SELECT p0_.`id` AS id_0, p0_.`reviewId` AS reviewId_1, p0_.`referenceId` AS referenceId_2, p0_.`conversationId` AS conversationId_3, p0_.`p_id` AS p_id_4, p0_.`sku` AS sku_5, p0_.`gtin` AS gtin_6, p0_.`mpn` AS mpn_7, p0_.`url` AS url_8, p0_.`star` AS star_9, p0_.`score` AS score_10, p0_.`date` AS date_11, p0_.`created_at` AS created_at_12, p0_.`content` AS content_13, p0_.`username` AS username_14, p0_.`country` AS country_15, p0_.`locale` AS locale_16, p0_.`language` AS language_17, p0_.`state` AS state_18, p0_.`unid_theme` AS unid_theme_19, p0_.`send_portal_date` AS send_portal_date_20, p0_.`answer` AS answer_21, p0_.`manager` AS manager_22, p0_.`is_anonymous` AS is_anonymous_23, p0_.`is_collection_review` AS is_collection_review_24 FROM `product_reviews_cache` p0_ WHERE p0_.`sku` IN ('С000263099', 'С000499733', 'С000261896', 'С000392716', 'С000418872', 'С000408852', 'С000360341', 'С000368687', 'С000418934', 'С000263478', 'С000261840', 'С000363954', 'С000368748', 'С000408765', 'С000401593', 'С000408757', 'С000503378', 'С000360387', 'С000398091', 'С000401568', 'С000398141', 'С000401622', 'С000398152', 'С000516403', 'С000408878', 'С000401687', 'С000401549', 'С000401994', 'С000401989', 'С000456531', 'С000509502', 'С000470729', 'С000533564', 'С000402051', 'С000507537', 'С000481400', 'С000464314', 'С000451499', 'С000474031', 'С000503394', 'С000464294', 'С000477695', 'С000495982', 'С000514192', 'С000477688', 'С000498288', 'С000507515', 'С000500026', 'С000496939', 'С000530773', 'С000481407', 'С000509167', 'С000529632', 'С000489790', 'С000493094', 'С000489767', 'С000489761', 'С000578779', 'С000470762', 'С000503138', 'С000517309', 'С000506435', 'С000481380', 'С000496312', 'С000532296', 'С000531395', 'С000477677', 'С000587047', 'С000493113', 'С000477729', 'С000565494', 'С000487929', 'С000392648', 'С000539991', 'С000487911', 'С000500476', 'С000487915', 'С000365130', 'С000501372', 'С000546113', 'С000533889', 'С000511168', 'С000523028', 'С000502312', 'С000263136', 'С000493074', 'С000487891', 'С000524618', 'С000504524', 'С000496857', 'С000549610', 'С000596012', 'С000526074', 'С000565495', 'С000572115', 'С000547495', 'С000565492', 'С000553649', 'С000607826', 'С000578816', 'С000565496', 'С000496701', 'С000547649', 'С000398128', 'С000605086', 'С000578817', 'С000502546', 'С000538417', 'С000536876', 'С000578818', 'С000585923', 'С000549611', 'С000602115', 'С000605320', 'С000541936', 'С000565493', 'С000578819', 'С000524856', 'С000565337', 'С000616728', 'С000584779', 'С000605298', 'С000609693', 'С000594877', 'С000586184', 'С000586193', 'С000500566', 'С000542012', 'С000532898', 'С000586217', 'С000619870', 'С000609694', 'С000586206', 'С000529570', 'С000586226', 'С000539956', 'С000609695')
Parameters: 
[]
View formatted query    View runnable query    Explain query
3.72 ms
(0.00%) 		1 
SELECT
                i.id AS iId,
                i.url AS iUrl,
                i.name AS iName,
                i.alt AS iAlt,
                i.file AS iFile,
                i.status AS iStatus,
                i.file_size_x AS iFileSizeX,
                i.file_size_y AS iFileSizeY,
                i.file_size_z_x AS iFileSizeZX,
                i.file_size_z_y AS iFileSizeZY,
                i.file_size_hd_x AS iFileSizeHdX,
                i.file_size_hd_y AS iFileSizeHdY,
                i.file_size_shd_x AS iFileSizeShdX,
                i.file_size_shd_y AS iFileSizeShdY,
                i.file_size4k_x AS iFileSize4kX,
                i.file_size4k_y AS iFileSize4kY,
                c.id AS cId,
                c.url AS cUrl,
                c.status AS cStatus,
                c.name AS cName,
                c.alternate_name AS cAName,
                c.pr_min_euro AS prMinEuro,
                c.pr_min_euro_de AS prMinEuroDe,
                c.pr_min_euro_fr AS prMinEuroFr,
                c.pr_min_euro_it AS prMinEuroIt,
                c.pr_min_euro_be AS prMinEuroBe,
                c.pr_min_euro_ie AS prMinEuroIe,
                c.pr_min_euro_nl AS prMinEuroNl,
                c.pr_min_euro_es AS prMinEuroEs,
                c.pr_min_rue AS prMinRUB,
                c.pr_min_rue AS prMinRUE,
                c.pr_min_gbp AS prMinGBP,
                c.pr_min_gbe AS prMinGBE,
                c.pr_min_usd AS prMinUSD,
                c.pr_min_use AS prMinUSE,
                c.pr_min_f_usd AS prMinFUSD,
                c.pr_min_f_use AS prMinFUSE,
                c.pr_min_chf AS prMinCHF,
                c.pr_min_che AS prMinCHE,
                c.pr_min_sek AS prMinSEK,
                c.pr_min_see AS prMinSEE,
                c.pr_min_dkk AS prMinDKK,
                c.pr_min_dke AS prMinDKE,
                c.pr_min_nok AS prMinNOK,
                c.pr_min_noe AS prMinNOE,
                c.pr_min_pln AS prMinPLN,
                c.pr_min_ple AS prMinPLE,
                c.pr_min_cad AS prMinCAD,
                c.pr_min_cae AS prMinCAE,
                c.pr_min_f_cad AS prMinEuroFCAD,
                c.pr_min_f_cae AS prMinEuroFCAE,
                f.id AS fId,
                f.url AS fUrl,
                f.status AS fStatus,
                f.name AS fName,
                f.alternate_name AS fAName,
                f.suspended AS fSuspended,
                a.id AS itemId,
                lc.id AS lcId,
                lc.code AS lcCode,
                lc.alias AS lcAlias,
                la.id AS laId,
                la.alias AS laAlias,
                lst.id AS lstId,
                lst.alias AS lstAlias,
                lt.id AS ltId,
                lt.alias AS ltAlias,
                (SELECT COUNT(ii.idea_id) FROM `idea_interior` ii WHERE `ii`.`interior_id` = `i`.id) AS ideaCount
            FROM interior i
            LEFT JOIN collection c ON c.id = i.collection
            LEFT JOIN factory f ON f.id = c.factory
            LEFT JOIN interior_article iat ON iat.interior_id = i.id
            LEFT JOIN article a ON a.id = iat.article_id
            LEFT JOIN list_country lc ON lc.id = f.country
            LEFT JOIN interior_apply ia ON ia.interior_id = i.id
            LEFT JOIN list_apply la ON la.id = ia.apply_id
            LEFT JOIN interior_texture it ON it.interior_id = i.id
            LEFT JOIN list_texture lt ON lt.id = it.texture_id
            LEFT JOIN interior_style ist ON ist.interior_id = i.id
            LEFT JOIN list_style lst ON lst.id = ist.style_id
            WHERE c.id = 3246455 AND i.status = 1
         AND i.id IN (176592, 176591)
Parameters: 
[]
View formatted query    View runnable query    Explain query
3.65 ms
(0.00%) 		2 
SELECT t0.`id` AS id_1, t0.`reviewId` AS reviewId_2, t0.`referenceId` AS referenceId_3, t0.`conversationId` AS conversationId_4, t0.`p_id` AS p_id_5, t0.`sku` AS sku_6, t0.`gtin` AS gtin_7, t0.`mpn` AS mpn_8, t0.`url` AS url_9, t0.`star` AS star_10, t0.`score` AS score_11, t0.`date` AS date_12, t0.`created_at` AS created_at_13, t0.`content` AS content_14, t0.`username` AS username_15, t0.`country` AS country_16, t0.`locale` AS locale_17, t0.`language` AS language_18, t0.`state` AS state_19, t0.`unid_theme` AS unid_theme_20, t0.`send_portal_date` AS send_portal_date_21, t0.`answer` AS answer_22, t0.`manager` AS manager_23, t0.`is_anonymous` AS is_anonymous_24, t0.`is_collection_review` AS is_collection_review_25, t0.article_id AS article_id_26, t0.collection_id AS collection_id_27, t0.order_id AS order_id_28, t0.user_id AS user_id_29 FROM `product_reviews_cache` t0 WHERE t0.collection_id IN (?)
Parameters: 
[
  [
    165484
    170874
    170876
    170877
    170878
    170879
    170880
    172679
    172680
    172682
    172683
    172684
    174492
    174590
    174660
    177932
    200760
    211099
    531754
    1629475
    1629479
    1651231
    1742318
    1744442
    1861195
    1863366
    1881051
    3244539
    3244696
    3244705
    3244706
    3244707
    3244715
    3244716
    3244717
    3244718
    3244777
    3245337
    3245338
    3245339
    3245371
    3245372
    3245390
    3245392
    3245423
    3245424
    3245426
    3245427
    3245534
    3245535
    3245536
    3245537
    3245568
    3245569
    3246169
    3246170
    3246344
    3246345
    3246346
    3246347
    3246443
    3246444
    3246445
    3246446
    3246447
    3246448
    3246455
    3246456
    3246457
    3246458
    3246669
    3246670
    3246671
    3246672
    3246673
    3246973
    3246974
    3246975
    3247859
    3247860
    3247861
    3247862
    3247863
    3248044
    3248242
    3248243
    3248244
    3248245
    3248246
    3248247
    3248248
    3248249
    3248250
    3248251
    3248406
    3248407
    3248408
    3248409
    3248410
    3248518
    3248519
    3248520
    3248521
    3248624
    3248625
    3248626
    3248627
    3248628
    3248757
    3248758
    3248759
    3248760
    3248761
    3248866
    3248867
    3248868
    3248869
    3248870
    3248942
    3248943
    3248944
    3248945
    3248946
    3249002
    3249003
    3249004
    3249005
    3249006
    3249007
    3249099
    3249112
    3249126
    3249130
    3249131
    3249132
    3249167
    3249206
    3249211
    3249215
    3249217
    3249236
    3249237
    3249252
    3249283
    3249288
    3249289
    3249350
    3249361
    3249407
    3249436
    3249437
    3249482
    3249539
    3249540
    3249543
    3249584
    3249600
    3249643
    3249645
    3249729
    3249783
    3249790
    3249815
    3249828
    3250097
    3250102
    3250271
    3250411
    3250571
    3250701
    3250721
    3250761
    3251043
    3251186
    3251424
    3251427
    3251572
    3251575
    3252070
    3252073
    3252076
    3252196
    3252202
    3252478
    3252481
    3252943
    3254287
    3254425
    3254656
    3254668
    3254896
    3255445
    3255451
    3255454
    3255532
    3255535
    3256021
    3256033
    3256156
    3256159
    3256225
  ]
]
View formatted query    View runnable query    Explain query
3.20 ms
(0.00%) 		1 
SELECT
                i.id AS iId,
                i.url AS iUrl,
                i.name AS iName,
                i.alt AS iAlt,
                i.file AS iFile,
                i.status AS iStatus,
                i.file_size_x AS iFileSizeX,
                i.file_size_y AS iFileSizeY,
                i.file_size_z_x AS iFileSizeZX,
                i.file_size_z_y AS iFileSizeZY,
                i.file_size_hd_x AS iFileSizeHdX,
                i.file_size_hd_y AS iFileSizeHdY,
                i.file_size_shd_x AS iFileSizeShdX,
                i.file_size_shd_y AS iFileSizeShdY,
                i.file_size4k_x AS iFileSize4kX,
                i.file_size4k_y AS iFileSize4kY,
                c.id AS cId,
                c.url AS cUrl,
                c.status AS cStatus,
                c.name AS cName,
                c.alternate_name AS cAName,
                c.pr_min_euro AS prMinEuro,
                c.pr_min_euro_de AS prMinEuroDe,
                c.pr_min_euro_fr AS prMinEuroFr,
                c.pr_min_euro_it AS prMinEuroIt,
                c.pr_min_euro_be AS prMinEuroBe,
                c.pr_min_euro_ie AS prMinEuroIe,
                c.pr_min_euro_nl AS prMinEuroNl,
                c.pr_min_euro_es AS prMinEuroEs,
                c.pr_min_rue AS prMinRUB,
                c.pr_min_rue AS prMinRUE,
                c.pr_min_gbp AS prMinGBP,
                c.pr_min_gbe AS prMinGBE,
                c.pr_min_usd AS prMinUSD,
                c.pr_min_use AS prMinUSE,
                c.pr_min_f_usd AS prMinFUSD,
                c.pr_min_f_use AS prMinFUSE,
                c.pr_min_chf AS prMinCHF,
                c.pr_min_che AS prMinCHE,
                c.pr_min_sek AS prMinSEK,
                c.pr_min_see AS prMinSEE,
                c.pr_min_dkk AS prMinDKK,
                c.pr_min_dke AS prMinDKE,
                c.pr_min_nok AS prMinNOK,
                c.pr_min_noe AS prMinNOE,
                c.pr_min_pln AS prMinPLN,
                c.pr_min_ple AS prMinPLE,
                c.pr_min_cad AS prMinCAD,
                c.pr_min_cae AS prMinCAE,
                c.pr_min_f_cad AS prMinEuroFCAD,
                c.pr_min_f_cae AS prMinEuroFCAE,
                f.id AS fId,
                f.url AS fUrl,
                f.status AS fStatus,
                f.name AS fName,
                f.alternate_name AS fAName,
                f.suspended AS fSuspended,
                a.id AS itemId,
                lc.id AS lcId,
                lc.code AS lcCode,
                lc.alias AS lcAlias,
                la.id AS laId,
                la.alias AS laAlias,
                lst.id AS lstId,
                lst.alias AS lstAlias,
                lt.id AS ltId,
                lt.alias AS ltAlias,
                (SELECT COUNT(ii.idea_id) FROM `idea_interior` ii WHERE `ii`.`interior_id` = `i`.id) AS ideaCount
            FROM interior i
            LEFT JOIN collection c ON c.id = i.collection
            LEFT JOIN factory f ON f.id = c.factory
            LEFT JOIN interior_article iat ON iat.interior_id = i.id
            LEFT JOIN article a ON a.id = iat.article_id
            LEFT JOIN list_country lc ON lc.id = f.country
            LEFT JOIN interior_apply ia ON ia.interior_id = i.id
            LEFT JOIN list_apply la ON la.id = ia.apply_id
            LEFT JOIN interior_texture it ON it.interior_id = i.id
            LEFT JOIN list_texture lt ON lt.id = it.texture_id
            LEFT JOIN interior_style ist ON ist.interior_id = i.id
            LEFT JOIN list_style lst ON lst.id = ist.style_id
            WHERE c.id = 3244718 AND i.status = 1
         AND i.id IN (164533, 164534, 164536)
Parameters: 
[]
View formatted query    View runnable query    Explain query
2.93 ms
(0.00%) 		1 
SELECT i0_.`id` AS id_0 FROM `idea` i1_ INNER JOIN idea_interior i2_ ON i1_.id = i2_.idea_id INNER JOIN `interior` i0_ ON i0_.id = i2_.interior_id WHERE i1_.`token` = ? GROUP BY i0_.`id`
Parameters: 
[
  "d74acfc5c5c18191ac50b6aa497d76a9c15401479fc08e70c07be154dcc343c4"
]
View formatted query    View runnable query    Explain query
2.85 ms
(0.00%) 		1 
SELECT v0_.`id` AS id_0, v0_.`token` AS token_1, v0_.`url` AS url_2, v0_.`title` AS title_3, v0_.`icon` AS icon_4, v0_.`visit_date` AS visit_date_5, v0_.`v_type` AS v_type_6, v0_.`v_object_id` AS v_object_id_7 FROM `visit` v0_ WHERE v0_.`token` = ? AND v0_.`url` = ? AND v0_.`url` <> '/.*catalog.*/' LIMIT 1
Parameters: 
[
  "d74acfc5c5c18191ac50b6aa497d76a9c15401479fc08e70c07be154dcc343c4"
  "catalogue/marazzi"
]
View formatted query    View runnable query    Explain query
2.66 ms
(0.00%) 		1 
SELECT
                i.id AS iId,
                i.url AS iUrl,
                i.name AS iName,
                i.alt AS iAlt,
                i.file AS iFile,
                i.status AS iStatus,
                i.file_size_x AS iFileSizeX,
                i.file_size_y AS iFileSizeY,
                i.file_size_z_x AS iFileSizeZX,
                i.file_size_z_y AS iFileSizeZY,
                i.file_size_hd_x AS iFileSizeHdX,
                i.file_size_hd_y AS iFileSizeHdY,
                i.file_size_shd_x AS iFileSizeShdX,
                i.file_size_shd_y AS iFileSizeShdY,
                i.file_size4k_x AS iFileSize4kX,
                i.file_size4k_y AS iFileSize4kY,
                c.id AS cId,
                c.url AS cUrl,
                c.status AS cStatus,
                c.name AS cName,
                c.alternate_name AS cAName,
                c.pr_min_euro AS prMinEuro,
                c.pr_min_euro_de AS prMinEuroDe,
                c.pr_min_euro_fr AS prMinEuroFr,
                c.pr_min_euro_it AS prMinEuroIt,
                c.pr_min_euro_be AS prMinEuroBe,
                c.pr_min_euro_ie AS prMinEuroIe,
                c.pr_min_euro_nl AS prMinEuroNl,
                c.pr_min_euro_es AS prMinEuroEs,
                c.pr_min_rue AS prMinRUB,
                c.pr_min_rue AS prMinRUE,
                c.pr_min_gbp AS prMinGBP,
                c.pr_min_gbe AS prMinGBE,
                c.pr_min_usd AS prMinUSD,
                c.pr_min_use AS prMinUSE,
                c.pr_min_f_usd AS prMinFUSD,
                c.pr_min_f_use AS prMinFUSE,
                c.pr_min_chf AS prMinCHF,
                c.pr_min_che AS prMinCHE,
                c.pr_min_sek AS prMinSEK,
                c.pr_min_see AS prMinSEE,
                c.pr_min_dkk AS prMinDKK,
                c.pr_min_dke AS prMinDKE,
                c.pr_min_nok AS prMinNOK,
                c.pr_min_noe AS prMinNOE,
                c.pr_min_pln AS prMinPLN,
                c.pr_min_ple AS prMinPLE,
                c.pr_min_cad AS prMinCAD,
                c.pr_min_cae AS prMinCAE,
                c.pr_min_f_cad AS prMinEuroFCAD,
                c.pr_min_f_cae AS prMinEuroFCAE,
                f.id AS fId,
                f.url AS fUrl,
                f.status AS fStatus,
                f.name AS fName,
                f.alternate_name AS fAName,
                f.suspended AS fSuspended,
                a.id AS itemId,
                lc.id AS lcId,
                lc.code AS lcCode,
                lc.alias AS lcAlias,
                la.id AS laId,
                la.alias AS laAlias,
                lst.id AS lstId,
                lst.alias AS lstAlias,
                lt.id AS ltId,
                lt.alias AS ltAlias,
                (SELECT COUNT(ii.idea_id) FROM `idea_interior` ii WHERE `ii`.`interior_id` = `i`.id) AS ideaCount
            FROM interior i
            LEFT JOIN collection c ON c.id = i.collection
            LEFT JOIN factory f ON f.id = c.factory
            LEFT JOIN interior_article iat ON iat.interior_id = i.id
            LEFT JOIN article a ON a.id = iat.article_id
            LEFT JOIN list_country lc ON lc.id = f.country
            LEFT JOIN interior_apply ia ON ia.interior_id = i.id
            LEFT JOIN list_apply la ON la.id = ia.apply_id
            LEFT JOIN interior_texture it ON it.interior_id = i.id
            LEFT JOIN list_texture lt ON lt.id = it.texture_id
            LEFT JOIN interior_style ist ON ist.interior_id = i.id
            LEFT JOIN list_style lst ON lst.id = ist.style_id
            WHERE c.id = 3246344 AND i.status = 1
         AND i.id IN (175926, 189279, 189280)
Parameters: 
[]
View formatted query    View runnable query    Explain query
2.44 ms
(0.00%) 		1 
SELECT
                i.id AS iId,
                i.url AS iUrl,
                i.name AS iName,
                i.alt AS iAlt,
                i.file AS iFile,
                i.status AS iStatus,
                i.file_size_x AS iFileSizeX,
                i.file_size_y AS iFileSizeY,
                i.file_size_z_x AS iFileSizeZX,
                i.file_size_z_y AS iFileSizeZY,
                i.file_size_hd_x AS iFileSizeHdX,
                i.file_size_hd_y AS iFileSizeHdY,
                i.file_size_shd_x AS iFileSizeShdX,
                i.file_size_shd_y AS iFileSizeShdY,
                i.file_size4k_x AS iFileSize4kX,
                i.file_size4k_y AS iFileSize4kY,
                c.id AS cId,
                c.url AS cUrl,
                c.status AS cStatus,
                c.name AS cName,
                c.alternate_name AS cAName,
                c.pr_min_euro AS prMinEuro,
                c.pr_min_euro_de AS prMinEuroDe,
                c.pr_min_euro_fr AS prMinEuroFr,
                c.pr_min_euro_it AS prMinEuroIt,
                c.pr_min_euro_be AS prMinEuroBe,
                c.pr_min_euro_ie AS prMinEuroIe,
                c.pr_min_euro_nl AS prMinEuroNl,
                c.pr_min_euro_es AS prMinEuroEs,
                c.pr_min_rue AS prMinRUB,
                c.pr_min_rue AS prMinRUE,
                c.pr_min_gbp AS prMinGBP,
                c.pr_min_gbe AS prMinGBE,
                c.pr_min_usd AS prMinUSD,
                c.pr_min_use AS prMinUSE,
                c.pr_min_f_usd AS prMinFUSD,
                c.pr_min_f_use AS prMinFUSE,
                c.pr_min_chf AS prMinCHF,
                c.pr_min_che AS prMinCHE,
                c.pr_min_sek AS prMinSEK,
                c.pr_min_see AS prMinSEE,
                c.pr_min_dkk AS prMinDKK,
                c.pr_min_dke AS prMinDKE,
                c.pr_min_nok AS prMinNOK,
                c.pr_min_noe AS prMinNOE,
                c.pr_min_pln AS prMinPLN,
                c.pr_min_ple AS prMinPLE,
                c.pr_min_cad AS prMinCAD,
                c.pr_min_cae AS prMinCAE,
                c.pr_min_f_cad AS prMinEuroFCAD,
                c.pr_min_f_cae AS prMinEuroFCAE,
                f.id AS fId,
                f.url AS fUrl,
                f.status AS fStatus,
                f.name AS fName,
                f.alternate_name AS fAName,
                f.suspended AS fSuspended,
                a.id AS itemId,
                lc.id AS lcId,
                lc.code AS lcCode,
                lc.alias AS lcAlias,
                la.id AS laId,
                la.alias AS laAlias,
                lst.id AS lstId,
                lst.alias AS lstAlias,
                lt.id AS ltId,
                lt.alias AS ltAlias,
                (SELECT COUNT(ii.idea_id) FROM `idea_interior` ii WHERE `ii`.`interior_id` = `i`.id) AS ideaCount
            FROM interior i
            LEFT JOIN collection c ON c.id = i.collection
            LEFT JOIN factory f ON f.id = c.factory
            LEFT JOIN interior_article iat ON iat.interior_id = i.id
            LEFT JOIN article a ON a.id = iat.article_id
            LEFT JOIN list_country lc ON lc.id = f.country
            LEFT JOIN interior_apply ia ON ia.interior_id = i.id
            LEFT JOIN list_apply la ON la.id = ia.apply_id
            LEFT JOIN interior_texture it ON it.interior_id = i.id
            LEFT JOIN list_texture lt ON lt.id = it.texture_id
            LEFT JOIN interior_style ist ON ist.interior_id = i.id
            LEFT JOIN list_style lst ON lst.id = ist.style_id
            WHERE c.id = 3246447 AND i.status = 1
         AND i.id IN (177649, 177646, 177647)
Parameters: 
[]
View formatted query    View runnable query    Explain query
2.36 ms
(0.00%) 		1 
SELECT f0_.`id` AS id_0, f0_.`icon` AS icon_1, f0_.`icon_url` AS icon_url_2, f1_.`name_single_de` AS name_single_de_3 FROM `filters` f0_ LEFT JOIN `filter_pages` f1_ ON f0_.page_id = f1_.id WHERE f0_.`id` IN (10824)
Parameters: 
[]
View formatted query    View runnable query    Explain query
2.36 ms
(0.00%) 		1 
SELECT t0.`id` AS id_1, t0.`unid` AS unid_2, t0.`name` AS name_3, t0.`name_inv` AS name_inv_4, t0.`url` AS url_5, t0.`alternate_name` AS alternate_name_6, t0.`description_ru` AS description_ru_7, t0.`description_en` AS description_en_8, t0.`description_it` AS description_it_9, t0.`description_es` AS description_es_10, t0.`description_fr` AS description_fr_11, t0.`description_de` AS description_de_12, t0.`description_pt` AS description_pt_13, t0.`description_pl` AS description_pl_14, t0.`description_nl` AS description_nl_15, t0.`description_fi` AS description_fi_16, t0.`description_ua` AS description_ua_17, t0.`description_sv` AS description_sv_18, t0.`description_no` AS description_no_19, t0.`description_da` AS description_da_20, t0.`description_zh` AS description_zh_21, t0.`delivery_time` AS delivery_time_22, t0.`not_regular` AS not_regular_23, t0.`suspended` AS suspended_24, t0.`status` AS status_25, t0.`type` AS type_26, t0.`discount` AS discount_27, t0.`discount_date_start` AS discount_date_start_28, t0.`discount_date_end` AS discount_date_end_29, t0.`transcription` AS transcription_30, t0.`cost_delivery` AS cost_delivery_31, t0.`create_date` AS create_date_32, t0.`is_accepted` AS is_accepted_33, t0.`accepted_at` AS accepted_at_34, t0.`accept_state` AS accept_state_35, t0.`description_edit` AS description_edit_36, t0.`stated_at` AS stated_at_37, t0.`state` AS state_38, t0.`description_state` AS description_state_39, t0.`video` AS video_40, t0.`parser_address` AS parser_address_41, t0.`accessible` AS accessible_42, t0.`sound` AS sound_43, t0.`test_access` AS test_access_44, t0.`total_ideas` AS total_ideas_45, t0.`votes_submit` AS votes_submit_46, t0.`votes_stars` AS votes_stars_47, t0.`brand_link` AS brand_link_48, t0.`brand_logo` AS brand_logo_49, t0.`no_send_portl_message` AS no_send_portl_message_50, t0.user_id AS user_id_51, t0.country AS country_52, t0.filter AS filter_53 FROM `factory` t0 WHERE t0.`url` = ? LIMIT 1
Parameters: 
[
  "marazzi"
]
View formatted query    View runnable query    Explain query
2.23 ms
(0.00%) 		1 
SELECT f.id, f.rank AS `rank`, f.alt_name AS `altName`, f.old_command AS `sphinxName`, f.old_id AS `sphinxId`, htmlshow.de AS `isHtmlShow`, fp.name_menu_de AS `nameMenu`, fp.name_many_de AS `nameMany`, fp.name_single_de AS `nameSingle`, fp.html_de AS `html`, fp.description_de AS `description`, metadesc.de AS `metaDescriptionName`, par.count AS `count`, par.code AS `code`, par.is_enable AS `isEnable`, gr.id AS `groupId`, gr.alt_name AS `groupAltName`, gpname.de AS `groupName`, url.de AS `slug`, url.ru AS `slug.ru`, url.en AS `slug.en`, url.it AS `slug.it`, url.es AS `slug.es`, url.fr AS `slug.fr`, url.de AS `slug.de`, url.pl AS `slug.pl`, url.nl AS `slug.nl`, url.fi AS `slug.fi`, url.sv AS `slug.sv`, b.id AS `brandId`, b.status AS `brandStatus`, b.stated_at AS `brandStatedAt`, b.type AS `brandType`, b.name AS `brandName`, f.logo AS `brandLogo`, f.logo_url AS `brandLogoUrl`, b.sound AS `brandSound`, b.video AS `brandVideo`, cn.id AS `countryId`, cnfp.name_single_de AS `countryName`, cnurl.de AS `countrySlug`, cnpar.code AS `countryCode` FROM filters f LEFT JOIN filter_pages fp ON fp.id = f.page_id LEFT JOIN filter_params par ON par.id = f.param_id LEFT JOIN filter_groups gr ON gr.id = f.group_id LEFT JOIN locale_text gpname ON gpname.filter_group_name = gr.id LEFT JOIN locale_text metadesc ON metadesc.filter_name_for_meta_descr_id = f.id LEFT JOIN locale_url url ON url.filter_id = f.id LEFT JOIN locale_bool htmlshow ON htmlshow.filter_html_show_id = f.id LEFT JOIN factory b ON b.id = f.brand LEFT JOIN filters cn ON cn.id = f.country_id LEFT JOIN filter_pages cnfp ON cnfp.id = cn.page_id LEFT JOIN locale_url cnurl ON cnurl.filter_id = cn.id LEFT JOIN filter_params cnpar ON cnpar.id = cn.param_id WHERE f.id IN (?) ORDER BY gr.sort, f.sort
Parameters: 
[
  1 => 10250
]
View formatted query    View runnable query    Explain query
2.22 ms
(0.00%) 		1 
SELECT
                i.id AS iId,
                i.url AS iUrl,
                i.name AS iName,
                i.alt AS iAlt,
                i.file AS iFile,
                i.status AS iStatus,
                i.file_size_x AS iFileSizeX,
                i.file_size_y AS iFileSizeY,
                i.file_size_z_x AS iFileSizeZX,
                i.file_size_z_y AS iFileSizeZY,
                i.file_size_hd_x AS iFileSizeHdX,
                i.file_size_hd_y AS iFileSizeHdY,
                i.file_size_shd_x AS iFileSizeShdX,
                i.file_size_shd_y AS iFileSizeShdY,
                i.file_size4k_x AS iFileSize4kX,
                i.file_size4k_y AS iFileSize4kY,
                c.id AS cId,
                c.url AS cUrl,
                c.status AS cStatus,
                c.name AS cName,
                c.alternate_name AS cAName,
                c.pr_min_euro AS prMinEuro,
                c.pr_min_euro_de AS prMinEuroDe,
                c.pr_min_euro_fr AS prMinEuroFr,
                c.pr_min_euro_it AS prMinEuroIt,
                c.pr_min_euro_be AS prMinEuroBe,
                c.pr_min_euro_ie AS prMinEuroIe,
                c.pr_min_euro_nl AS prMinEuroNl,
                c.pr_min_euro_es AS prMinEuroEs,
                c.pr_min_rue AS prMinRUB,
                c.pr_min_rue AS prMinRUE,
                c.pr_min_gbp AS prMinGBP,
                c.pr_min_gbe AS prMinGBE,
                c.pr_min_usd AS prMinUSD,
                c.pr_min_use AS prMinUSE,
                c.pr_min_f_usd AS prMinFUSD,
                c.pr_min_f_use AS prMinFUSE,
                c.pr_min_chf AS prMinCHF,
                c.pr_min_che AS prMinCHE,
                c.pr_min_sek AS prMinSEK,
                c.pr_min_see AS prMinSEE,
                c.pr_min_dkk AS prMinDKK,
                c.pr_min_dke AS prMinDKE,
                c.pr_min_nok AS prMinNOK,
                c.pr_min_noe AS prMinNOE,
                c.pr_min_pln AS prMinPLN,
                c.pr_min_ple AS prMinPLE,
                c.pr_min_cad AS prMinCAD,
                c.pr_min_cae AS prMinCAE,
                c.pr_min_f_cad AS prMinEuroFCAD,
                c.pr_min_f_cae AS prMinEuroFCAE,
                f.id AS fId,
                f.url AS fUrl,
                f.status AS fStatus,
                f.name AS fName,
                f.alternate_name AS fAName,
                f.suspended AS fSuspended,
                a.id AS itemId,
                lc.id AS lcId,
                lc.code AS lcCode,
                lc.alias AS lcAlias,
                la.id AS laId,
                la.alias AS laAlias,
                lst.id AS lstId,
                lst.alias AS lstAlias,
                lt.id AS ltId,
                lt.alias AS ltAlias,
                (SELECT COUNT(ii.idea_id) FROM `idea_interior` ii WHERE `ii`.`interior_id` = `i`.id) AS ideaCount
            FROM interior i
            LEFT JOIN collection c ON c.id = i.collection
            LEFT JOIN factory f ON f.id = c.factory
            LEFT JOIN interior_article iat ON iat.interior_id = i.id
            LEFT JOIN article a ON a.id = iat.article_id
            LEFT JOIN list_country lc ON lc.id = f.country
            LEFT JOIN interior_apply ia ON ia.interior_id = i.id
            LEFT JOIN list_apply la ON la.id = ia.apply_id
            LEFT JOIN interior_texture it ON it.interior_id = i.id
            LEFT JOIN list_texture lt ON lt.id = it.texture_id
            LEFT JOIN interior_style ist ON ist.interior_id = i.id
            LEFT JOIN list_style lst ON lst.id = ist.style_id
            WHERE c.id = 3246670 AND i.status = 1
         AND i.id IN (178069, 178259, 178067)
Parameters: 
[]
View formatted query    View runnable query    Explain query
2.19 ms
(0.00%) 		1 
SELECT
                i.id AS iId,
                i.url AS iUrl,
                i.name AS iName,
                i.alt AS iAlt,
                i.file AS iFile,
                i.status AS iStatus,
                i.file_size_x AS iFileSizeX,
                i.file_size_y AS iFileSizeY,
                i.file_size_z_x AS iFileSizeZX,
                i.file_size_z_y AS iFileSizeZY,
                i.file_size_hd_x AS iFileSizeHdX,
                i.file_size_hd_y AS iFileSizeHdY,
                i.file_size_shd_x AS iFileSizeShdX,
                i.file_size_shd_y AS iFileSizeShdY,
                i.file_size4k_x AS iFileSize4kX,
                i.file_size4k_y AS iFileSize4kY,
                c.id AS cId,
                c.url AS cUrl,
                c.status AS cStatus,
                c.name AS cName,
                c.alternate_name AS cAName,
                c.pr_min_euro AS prMinEuro,
                c.pr_min_euro_de AS prMinEuroDe,
                c.pr_min_euro_fr AS prMinEuroFr,
                c.pr_min_euro_it AS prMinEuroIt,
                c.pr_min_euro_be AS prMinEuroBe,
                c.pr_min_euro_ie AS prMinEuroIe,
                c.pr_min_euro_nl AS prMinEuroNl,
                c.pr_min_euro_es AS prMinEuroEs,
                c.pr_min_rue AS prMinRUB,
                c.pr_min_rue AS prMinRUE,
                c.pr_min_gbp AS prMinGBP,
                c.pr_min_gbe AS prMinGBE,
                c.pr_min_usd AS prMinUSD,
                c.pr_min_use AS prMinUSE,
                c.pr_min_f_usd AS prMinFUSD,
                c.pr_min_f_use AS prMinFUSE,
                c.pr_min_chf AS prMinCHF,
                c.pr_min_che AS prMinCHE,
                c.pr_min_sek AS prMinSEK,
                c.pr_min_see AS prMinSEE,
                c.pr_min_dkk AS prMinDKK,
                c.pr_min_dke AS prMinDKE,
                c.pr_min_nok AS prMinNOK,
                c.pr_min_noe AS prMinNOE,
                c.pr_min_pln AS prMinPLN,
                c.pr_min_ple AS prMinPLE,
                c.pr_min_cad AS prMinCAD,
                c.pr_min_cae AS prMinCAE,
                c.pr_min_f_cad AS prMinEuroFCAD,
                c.pr_min_f_cae AS prMinEuroFCAE,
                f.id AS fId,
                f.url AS fUrl,
                f.status AS fStatus,
                f.name AS fName,
                f.alternate_name AS fAName,
                f.suspended AS fSuspended,
                a.id AS itemId,
                lc.id AS lcId,
                lc.code AS lcCode,
                lc.alias AS lcAlias,
                la.id AS laId,
                la.alias AS laAlias,
                lst.id AS lstId,
                lst.alias AS lstAlias,
                lt.id AS ltId,
                lt.alias AS ltAlias,
                (SELECT COUNT(ii.idea_id) FROM `idea_interior` ii WHERE `ii`.`interior_id` = `i`.id) AS ideaCount
            FROM interior i
            LEFT JOIN collection c ON c.id = i.collection
            LEFT JOIN factory f ON f.id = c.factory
            LEFT JOIN interior_article iat ON iat.interior_id = i.id
            LEFT JOIN article a ON a.id = iat.article_id
            LEFT JOIN list_country lc ON lc.id = f.country
            LEFT JOIN interior_apply ia ON ia.interior_id = i.id
            LEFT JOIN list_apply la ON la.id = ia.apply_id
            LEFT JOIN interior_texture it ON it.interior_id = i.id
            LEFT JOIN list_texture lt ON lt.id = it.texture_id
            LEFT JOIN interior_style ist ON ist.interior_id = i.id
            LEFT JOIN list_style lst ON lst.id = ist.style_id
            WHERE c.id = 3246457 AND i.status = 1
         AND i.id IN (176594, 176596, 176593)
Parameters: 
[]
View formatted query    View runnable query    Explain query
1.79 ms
(0.00%) 		1 
SELECT
                i.id AS iId,
                i.url AS iUrl,
                i.name AS iName,
                i.alt AS iAlt,
                i.file AS iFile,
                i.status AS iStatus,
                i.file_size_x AS iFileSizeX,
                i.file_size_y AS iFileSizeY,
                i.file_size_z_x AS iFileSizeZX,
                i.file_size_z_y AS iFileSizeZY,
                i.file_size_hd_x AS iFileSizeHdX,
                i.file_size_hd_y AS iFileSizeHdY,
                i.file_size_shd_x AS iFileSizeShdX,
                i.file_size_shd_y AS iFileSizeShdY,
                i.file_size4k_x AS iFileSize4kX,
                i.file_size4k_y AS iFileSize4kY,
                c.id AS cId,
                c.url AS cUrl,
                c.status AS cStatus,
                c.name AS cName,
                c.alternate_name AS cAName,
                c.pr_min_euro AS prMinEuro,
                c.pr_min_euro_de AS prMinEuroDe,
                c.pr_min_euro_fr AS prMinEuroFr,
                c.pr_min_euro_it AS prMinEuroIt,
                c.pr_min_euro_be AS prMinEuroBe,
                c.pr_min_euro_ie AS prMinEuroIe,
                c.pr_min_euro_nl AS prMinEuroNl,
                c.pr_min_euro_es AS prMinEuroEs,
                c.pr_min_rue AS prMinRUB,
                c.pr_min_rue AS prMinRUE,
                c.pr_min_gbp AS prMinGBP,
                c.pr_min_gbe AS prMinGBE,
                c.pr_min_usd AS prMinUSD,
                c.pr_min_use AS prMinUSE,
                c.pr_min_f_usd AS prMinFUSD,
                c.pr_min_f_use AS prMinFUSE,
                c.pr_min_chf AS prMinCHF,
                c.pr_min_che AS prMinCHE,
                c.pr_min_sek AS prMinSEK,
                c.pr_min_see AS prMinSEE,
                c.pr_min_dkk AS prMinDKK,
                c.pr_min_dke AS prMinDKE,
                c.pr_min_nok AS prMinNOK,
                c.pr_min_noe AS prMinNOE,
                c.pr_min_pln AS prMinPLN,
                c.pr_min_ple AS prMinPLE,
                c.pr_min_cad AS prMinCAD,
                c.pr_min_cae AS prMinCAE,
                c.pr_min_f_cad AS prMinEuroFCAD,
                c.pr_min_f_cae AS prMinEuroFCAE,
                f.id AS fId,
                f.url AS fUrl,
                f.status AS fStatus,
                f.name AS fName,
                f.alternate_name AS fAName,
                f.suspended AS fSuspended,
                a.id AS itemId,
                lc.id AS lcId,
                lc.code AS lcCode,
                lc.alias AS lcAlias,
                la.id AS laId,
                la.alias AS laAlias,
                lst.id AS lstId,
                lst.alias AS lstAlias,
                lt.id AS ltId,
                lt.alias AS ltAlias,
                (SELECT COUNT(ii.idea_id) FROM `idea_interior` ii WHERE `ii`.`interior_id` = `i`.id) AS ideaCount
            FROM interior i
            LEFT JOIN collection c ON c.id = i.collection
            LEFT JOIN factory f ON f.id = c.factory
            LEFT JOIN interior_article iat ON iat.interior_id = i.id
            LEFT JOIN article a ON a.id = iat.article_id
            LEFT JOIN list_country lc ON lc.id = f.country
            LEFT JOIN interior_apply ia ON ia.interior_id = i.id
            LEFT JOIN list_apply la ON la.id = ia.apply_id
            LEFT JOIN interior_texture it ON it.interior_id = i.id
            LEFT JOIN list_texture lt ON lt.id = it.texture_id
            LEFT JOIN interior_style ist ON ist.interior_id = i.id
            LEFT JOIN list_style lst ON lst.id = ist.style_id
            WHERE c.id = 3246443 AND i.status = 1
         AND i.id IN (177653, 177651, 177654)
Parameters: 
[]
View formatted query    View runnable query    Explain query
1.78 ms
(0.00%) 		1 
SELECT COUNT(v0_.`id`) AS sclr_0 FROM `visit` v0_ WHERE v0_.`token` = ? AND v0_.`url` <> '/.*catalog.*/'
Parameters: 
[
  "d74acfc5c5c18191ac50b6aa497d76a9c15401479fc08e70c07be154dcc343c4"
]
View formatted query    View runnable query    Explain query
1.77 ms
(0.00%) 		1 
SELECT
                i.id AS iId,
                i.url AS iUrl,
                i.name AS iName,
                i.alt AS iAlt,
                i.file AS iFile,
                i.status AS iStatus,
                i.file_size_x AS iFileSizeX,
                i.file_size_y AS iFileSizeY,
                i.file_size_z_x AS iFileSizeZX,
                i.file_size_z_y AS iFileSizeZY,
                i.file_size_hd_x AS iFileSizeHdX,
                i.file_size_hd_y AS iFileSizeHdY,
                i.file_size_shd_x AS iFileSizeShdX,
                i.file_size_shd_y AS iFileSizeShdY,
                i.file_size4k_x AS iFileSize4kX,
                i.file_size4k_y AS iFileSize4kY,
                c.id AS cId,
                c.url AS cUrl,
                c.status AS cStatus,
                c.name AS cName,
                c.alternate_name AS cAName,
                c.pr_min_euro AS prMinEuro,
                c.pr_min_euro_de AS prMinEuroDe,
                c.pr_min_euro_fr AS prMinEuroFr,
                c.pr_min_euro_it AS prMinEuroIt,
                c.pr_min_euro_be AS prMinEuroBe,
                c.pr_min_euro_ie AS prMinEuroIe,
                c.pr_min_euro_nl AS prMinEuroNl,
                c.pr_min_euro_es AS prMinEuroEs,
                c.pr_min_rue AS prMinRUB,
                c.pr_min_rue AS prMinRUE,
                c.pr_min_gbp AS prMinGBP,
                c.pr_min_gbe AS prMinGBE,
                c.pr_min_usd AS prMinUSD,
                c.pr_min_use AS prMinUSE,
                c.pr_min_f_usd AS prMinFUSD,
                c.pr_min_f_use AS prMinFUSE,
                c.pr_min_chf AS prMinCHF,
                c.pr_min_che AS prMinCHE,
                c.pr_min_sek AS prMinSEK,
                c.pr_min_see AS prMinSEE,
                c.pr_min_dkk AS prMinDKK,
                c.pr_min_dke AS prMinDKE,
                c.pr_min_nok AS prMinNOK,
                c.pr_min_noe AS prMinNOE,
                c.pr_min_pln AS prMinPLN,
                c.pr_min_ple AS prMinPLE,
                c.pr_min_cad AS prMinCAD,
                c.pr_min_cae AS prMinCAE,
                c.pr_min_f_cad AS prMinEuroFCAD,
                c.pr_min_f_cae AS prMinEuroFCAE,
                f.id AS fId,
                f.url AS fUrl,
                f.status AS fStatus,
                f.name AS fName,
                f.alternate_name AS fAName,
                f.suspended AS fSuspended,
                a.id AS itemId,
                lc.id AS lcId,
                lc.code AS lcCode,
                lc.alias AS lcAlias,
                la.id AS laId,
                la.alias AS laAlias,
                lst.id AS lstId,
                lst.alias AS lstAlias,
                lt.id AS ltId,
                lt.alias AS ltAlias,
                (SELECT COUNT(ii.idea_id) FROM `idea_interior` ii WHERE `ii`.`interior_id` = `i`.id) AS ideaCount
            FROM interior i
            LEFT JOIN collection c ON c.id = i.collection
            LEFT JOIN factory f ON f.id = c.factory
            LEFT JOIN interior_article iat ON iat.interior_id = i.id
            LEFT JOIN article a ON a.id = iat.article_id
            LEFT JOIN list_country lc ON lc.id = f.country
            LEFT JOIN interior_apply ia ON ia.interior_id = i.id
            LEFT JOIN list_apply la ON la.id = ia.apply_id
            LEFT JOIN interior_texture it ON it.interior_id = i.id
            LEFT JOIN list_texture lt ON lt.id = it.texture_id
            LEFT JOIN interior_style ist ON ist.interior_id = i.id
            LEFT JOIN list_style lst ON lst.id = ist.style_id
            WHERE c.id = 3245338 AND i.status = 1
         AND i.id IN (168861, 168863, 168864)
Parameters: 
[]
View formatted query    View runnable query    Explain query
1.76 ms
(0.00%) 		1 
SELECT
                i.id AS iId,
                i.url AS iUrl,
                i.name AS iName,
                i.alt AS iAlt,
                i.file AS iFile,
                i.status AS iStatus,
                i.file_size_x AS iFileSizeX,
                i.file_size_y AS iFileSizeY,
                i.file_size_z_x AS iFileSizeZX,
                i.file_size_z_y AS iFileSizeZY,
                i.file_size_hd_x AS iFileSizeHdX,
                i.file_size_hd_y AS iFileSizeHdY,
                i.file_size_shd_x AS iFileSizeShdX,
                i.file_size_shd_y AS iFileSizeShdY,
                i.file_size4k_x AS iFileSize4kX,
                i.file_size4k_y AS iFileSize4kY,
                c.id AS cId,
                c.url AS cUrl,
                c.status AS cStatus,
                c.name AS cName,
                c.alternate_name AS cAName,
                c.pr_min_euro AS prMinEuro,
                c.pr_min_euro_de AS prMinEuroDe,
                c.pr_min_euro_fr AS prMinEuroFr,
                c.pr_min_euro_it AS prMinEuroIt,
                c.pr_min_euro_be AS prMinEuroBe,
                c.pr_min_euro_ie AS prMinEuroIe,
                c.pr_min_euro_nl AS prMinEuroNl,
                c.pr_min_euro_es AS prMinEuroEs,
                c.pr_min_rue AS prMinRUB,
                c.pr_min_rue AS prMinRUE,
                c.pr_min_gbp AS prMinGBP,
                c.pr_min_gbe AS prMinGBE,
                c.pr_min_usd AS prMinUSD,
                c.pr_min_use AS prMinUSE,
                c.pr_min_f_usd AS prMinFUSD,
                c.pr_min_f_use AS prMinFUSE,
                c.pr_min_chf AS prMinCHF,
                c.pr_min_che AS prMinCHE,
                c.pr_min_sek AS prMinSEK,
                c.pr_min_see AS prMinSEE,
                c.pr_min_dkk AS prMinDKK,
                c.pr_min_dke AS prMinDKE,
                c.pr_min_nok AS prMinNOK,
                c.pr_min_noe AS prMinNOE,
                c.pr_min_pln AS prMinPLN,
                c.pr_min_ple AS prMinPLE,
                c.pr_min_cad AS prMinCAD,
                c.pr_min_cae AS prMinCAE,
                c.pr_min_f_cad AS prMinEuroFCAD,
                c.pr_min_f_cae AS prMinEuroFCAE,
                f.id AS fId,
                f.url AS fUrl,
                f.status AS fStatus,
                f.name AS fName,
                f.alternate_name AS fAName,
                f.suspended AS fSuspended,
                a.id AS itemId,
                lc.id AS lcId,
                lc.code AS lcCode,
                lc.alias AS lcAlias,
                la.id AS laId,
                la.alias AS laAlias,
                lst.id AS lstId,
                lst.alias AS lstAlias,
                lt.id AS ltId,
                lt.alias AS ltAlias,
                (SELECT COUNT(ii.idea_id) FROM `idea_interior` ii WHERE `ii`.`interior_id` = `i`.id) AS ideaCount
            FROM interior i
            LEFT JOIN collection c ON c.id = i.collection
            LEFT JOIN factory f ON f.id = c.factory
            LEFT JOIN interior_article iat ON iat.interior_id = i.id
            LEFT JOIN article a ON a.id = iat.article_id
            LEFT JOIN list_country lc ON lc.id = f.country
            LEFT JOIN interior_apply ia ON ia.interior_id = i.id
            LEFT JOIN list_apply la ON la.id = ia.apply_id
            LEFT JOIN interior_texture it ON it.interior_id = i.id
            LEFT JOIN list_texture lt ON lt.id = it.texture_id
            LEFT JOIN interior_style ist ON ist.interior_id = i.id
            LEFT JOIN list_style lst ON lst.id = ist.style_id
            WHERE c.id = 1742318 AND i.status = 1
         AND i.id IN (87642)
Parameters: 
[]
View formatted query    View runnable query    Explain query
1.58 ms
(0.00%) 		1 
SELECT
                i.id AS iId,
                i.url AS iUrl,
                i.name AS iName,
                i.alt AS iAlt,
                i.file AS iFile,
                i.status AS iStatus,
                i.file_size_x AS iFileSizeX,
                i.file_size_y AS iFileSizeY,
                i.file_size_z_x AS iFileSizeZX,
                i.file_size_z_y AS iFileSizeZY,
                i.file_size_hd_x AS iFileSizeHdX,
                i.file_size_hd_y AS iFileSizeHdY,
                i.file_size_shd_x AS iFileSizeShdX,
                i.file_size_shd_y AS iFileSizeShdY,
                i.file_size4k_x AS iFileSize4kX,
                i.file_size4k_y AS iFileSize4kY,
                c.id AS cId,
                c.url AS cUrl,
                c.status AS cStatus,
                c.name AS cName,
                c.alternate_name AS cAName,
                c.pr_min_euro AS prMinEuro,
                c.pr_min_euro_de AS prMinEuroDe,
                c.pr_min_euro_fr AS prMinEuroFr,
                c.pr_min_euro_it AS prMinEuroIt,
                c.pr_min_euro_be AS prMinEuroBe,
                c.pr_min_euro_ie AS prMinEuroIe,
                c.pr_min_euro_nl AS prMinEuroNl,
                c.pr_min_euro_es AS prMinEuroEs,
                c.pr_min_rue AS prMinRUB,
                c.pr_min_rue AS prMinRUE,
                c.pr_min_gbp AS prMinGBP,
                c.pr_min_gbe AS prMinGBE,
                c.pr_min_usd AS prMinUSD,
                c.pr_min_use AS prMinUSE,
                c.pr_min_f_usd AS prMinFUSD,
                c.pr_min_f_use AS prMinFUSE,
                c.pr_min_chf AS prMinCHF,
                c.pr_min_che AS prMinCHE,
                c.pr_min_sek AS prMinSEK,
                c.pr_min_see AS prMinSEE,
                c.pr_min_dkk AS prMinDKK,
                c.pr_min_dke AS prMinDKE,
                c.pr_min_nok AS prMinNOK,
                c.pr_min_noe AS prMinNOE,
                c.pr_min_pln AS prMinPLN,
                c.pr_min_ple AS prMinPLE,
                c.pr_min_cad AS prMinCAD,
                c.pr_min_cae AS prMinCAE,
                c.pr_min_f_cad AS prMinEuroFCAD,
                c.pr_min_f_cae AS prMinEuroFCAE,
                f.id AS fId,
                f.url AS fUrl,
                f.status AS fStatus,
                f.name AS fName,
                f.alternate_name AS fAName,
                f.suspended AS fSuspended,
                a.id AS itemId,
                lc.id AS lcId,
                lc.code AS lcCode,
                lc.alias AS lcAlias,
                la.id AS laId,
                la.alias AS laAlias,
                lst.id AS lstId,
                lst.alias AS lstAlias,
                lt.id AS ltId,
                lt.alias AS ltAlias,
                (SELECT COUNT(ii.idea_id) FROM `idea_interior` ii WHERE `ii`.`interior_id` = `i`.id) AS ideaCount
            FROM interior i
            LEFT JOIN collection c ON c.id = i.collection
            LEFT JOIN factory f ON f.id = c.factory
            LEFT JOIN interior_article iat ON iat.interior_id = i.id
            LEFT JOIN article a ON a.id = iat.article_id
            LEFT JOIN list_country lc ON lc.id = f.country
            LEFT JOIN interior_apply ia ON ia.interior_id = i.id
            LEFT JOIN list_apply la ON la.id = ia.apply_id
            LEFT JOIN interior_texture it ON it.interior_id = i.id
            LEFT JOIN list_texture lt ON lt.id = it.texture_id
            LEFT JOIN interior_style ist ON ist.interior_id = i.id
            LEFT JOIN list_style lst ON lst.id = ist.style_id
            WHERE c.id = 3249206 AND i.status = 1
         AND i.id IN (196136, 281041, 196131)
Parameters: 
[]
View formatted query    View runnable query    Explain query
1.31 ms
(0.00%) 		1 
SELECT f0_.`old_id` AS old_id_0, f1_.`name_single_de` AS name_single_de_1, f1_.`name_menu_de` AS name_menu_de_2 FROM `filters` f0_ LEFT JOIN `filter_pages` f1_ ON f0_.page_id = f1_.id LEFT JOIN `filter_groups` f2_ ON f0_.group_id = f2_.id WHERE f2_.`id` = 407 ORDER BY f0_.`sort` ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
1.14 ms
(0.00%) 		1 
SELECT c0_.`id` AS id_0, c0_.`rating` AS rating_1 FROM `collection` c0_ WHERE c0_.`id` IN (3244718, 3249206, 1861195, 3246170, 3246973, 3246672, 3245337, 3245569, 3246974, 1742318, 1651231, 3245427, 3245536, 3246669, 3246447, 3246670, 3249288, 3245338, 3246344, 3246443, 3246346, 3246445, 3246347, 3249584, 3246673, 3246448, 3246444, 3246457, 3246455, 3248044)
Parameters: 
[]
View formatted query    View runnable query    Explain query
1.04 ms
(0.00%) 		1 
INSERT INTO `visit` (`token`, `url`, `title`, `icon`, `visit_date`, `v_type`, `v_object_id`) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  1 => "d74acfc5c5c18191ac50b6aa497d76a9"
  2 => "catalogue/marazzi"
  3 => "Hersteller Marazzi"
  4 => "/img/histories/tile-catalogue.jpg?64"
  5 => "2025-08-04 12:52:12"
  6 => 5
  7 => 0
]
View formatted query    View runnable query    Explain query
0.90 ms
(0.00%) 		1 
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: 
[
  "d74acfc5c5c18191ac50b6aa497d76a9c15401479fc08e70c07be154dcc343c4"
]
View formatted query    View runnable query    Explain query
0.77 ms
(0.00%) 		1 
SELECT
                i.id AS iId,
                i.url AS iUrl,
                i.name AS iName,
                i.alt AS iAlt,
                i.file AS iFile,
                i.status AS iStatus,
                i.file_size_x AS iFileSizeX,
                i.file_size_y AS iFileSizeY,
                i.file_size_z_x AS iFileSizeZX,
                i.file_size_z_y AS iFileSizeZY,
                i.file_size_hd_x AS iFileSizeHdX,
                i.file_size_hd_y AS iFileSizeHdY,
                i.file_size_shd_x AS iFileSizeShdX,
                i.file_size_shd_y AS iFileSizeShdY,
                i.file_size4k_x AS iFileSize4kX,
                i.file_size4k_y AS iFileSize4kY,
                c.id AS cId,
                c.url AS cUrl,
                c.status AS cStatus,
                c.name AS cName,
                c.alternate_name AS cAName,
                c.pr_min_euro AS prMinEuro,
                c.pr_min_euro_de AS prMinEuroDe,
                c.pr_min_euro_fr AS prMinEuroFr,
                c.pr_min_euro_it AS prMinEuroIt,
                c.pr_min_euro_be AS prMinEuroBe,
                c.pr_min_euro_ie AS prMinEuroIe,
                c.pr_min_euro_nl AS prMinEuroNl,
                c.pr_min_euro_es AS prMinEuroEs,
                c.pr_min_rue AS prMinRUB,
                c.pr_min_rue AS prMinRUE,
                c.pr_min_gbp AS prMinGBP,
                c.pr_min_gbe AS prMinGBE,
                c.pr_min_usd AS prMinUSD,
                c.pr_min_use AS prMinUSE,
                c.pr_min_f_usd AS prMinFUSD,
                c.pr_min_f_use AS prMinFUSE,
                c.pr_min_chf AS prMinCHF,
                c.pr_min_che AS prMinCHE,
                c.pr_min_sek AS prMinSEK,
                c.pr_min_see AS prMinSEE,
                c.pr_min_dkk AS prMinDKK,
                c.pr_min_dke AS prMinDKE,
                c.pr_min_nok AS prMinNOK,
                c.pr_min_noe AS prMinNOE,
                c.pr_min_pln AS prMinPLN,
                c.pr_min_ple AS prMinPLE,
                c.pr_min_cad AS prMinCAD,
                c.pr_min_cae AS prMinCAE,
                c.pr_min_f_cad AS prMinEuroFCAD,
                c.pr_min_f_cae AS prMinEuroFCAE,
                f.id AS fId,
                f.url AS fUrl,
                f.status AS fStatus,
                f.name AS fName,
                f.alternate_name AS fAName,
                f.suspended AS fSuspended,
                a.id AS itemId,
                lc.id AS lcId,
                lc.code AS lcCode,
                lc.alias AS lcAlias,
                la.id AS laId,
                la.alias AS laAlias,
                lst.id AS lstId,
                lst.alias AS lstAlias,
                lt.id AS ltId,
                lt.alias AS ltAlias,
                (SELECT COUNT(ii.idea_id) FROM `idea_interior` ii WHERE `ii`.`interior_id` = `i`.id) AS ideaCount
            FROM interior i
            LEFT JOIN collection c ON c.id = i.collection
            LEFT JOIN factory f ON f.id = c.factory
            LEFT JOIN interior_article iat ON iat.interior_id = i.id
            LEFT JOIN article a ON a.id = iat.article_id
            LEFT JOIN list_country lc ON lc.id = f.country
            LEFT JOIN interior_apply ia ON ia.interior_id = i.id
            LEFT JOIN list_apply la ON la.id = ia.apply_id
            LEFT JOIN interior_texture it ON it.interior_id = i.id
            LEFT JOIN list_texture lt ON lt.id = it.texture_id
            LEFT JOIN interior_style ist ON ist.interior_id = i.id
            LEFT JOIN list_style lst ON lst.id = ist.style_id
            WHERE c.id = 3246170 AND i.status = 1
         AND i.id IN (174641, 174638, 174642)
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.74 ms
(0.00%) 		1 
SELECT
                i.id AS iId,
                i.url AS iUrl,
                i.name AS iName,
                i.alt AS iAlt,
                i.file AS iFile,
                i.status AS iStatus,
                i.file_size_x AS iFileSizeX,
                i.file_size_y AS iFileSizeY,
                i.file_size_z_x AS iFileSizeZX,
                i.file_size_z_y AS iFileSizeZY,
                i.file_size_hd_x AS iFileSizeHdX,
                i.file_size_hd_y AS iFileSizeHdY,
                i.file_size_shd_x AS iFileSizeShdX,
                i.file_size_shd_y AS iFileSizeShdY,
                i.file_size4k_x AS iFileSize4kX,
                i.file_size4k_y AS iFileSize4kY,
                c.id AS cId,
                c.url AS cUrl,
                c.status AS cStatus,
                c.name AS cName,
                c.alternate_name AS cAName,
                c.pr_min_euro AS prMinEuro,
                c.pr_min_euro_de AS prMinEuroDe,
                c.pr_min_euro_fr AS prMinEuroFr,
                c.pr_min_euro_it AS prMinEuroIt,
                c.pr_min_euro_be AS prMinEuroBe,
                c.pr_min_euro_ie AS prMinEuroIe,
                c.pr_min_euro_nl AS prMinEuroNl,
                c.pr_min_euro_es AS prMinEuroEs,
                c.pr_min_rue AS prMinRUB,
                c.pr_min_rue AS prMinRUE,
                c.pr_min_gbp AS prMinGBP,
                c.pr_min_gbe AS prMinGBE,
                c.pr_min_usd AS prMinUSD,
                c.pr_min_use AS prMinUSE,
                c.pr_min_f_usd AS prMinFUSD,
                c.pr_min_f_use AS prMinFUSE,
                c.pr_min_chf AS prMinCHF,
                c.pr_min_che AS prMinCHE,
                c.pr_min_sek AS prMinSEK,
                c.pr_min_see AS prMinSEE,
                c.pr_min_dkk AS prMinDKK,
                c.pr_min_dke AS prMinDKE,
                c.pr_min_nok AS prMinNOK,
                c.pr_min_noe AS prMinNOE,
                c.pr_min_pln AS prMinPLN,
                c.pr_min_ple AS prMinPLE,
                c.pr_min_cad AS prMinCAD,
                c.pr_min_cae AS prMinCAE,
                c.pr_min_f_cad AS prMinEuroFCAD,
                c.pr_min_f_cae AS prMinEuroFCAE,
                f.id AS fId,
                f.url AS fUrl,
                f.status AS fStatus,
                f.name AS fName,
                f.alternate_name AS fAName,
                f.suspended AS fSuspended,
                a.id AS itemId,
                lc.id AS lcId,
                lc.code AS lcCode,
                lc.alias AS lcAlias,
                la.id AS laId,
                la.alias AS laAlias,
                lst.id AS lstId,
                lst.alias AS lstAlias,
                lt.id AS ltId,
                lt.alias AS ltAlias,
                (SELECT COUNT(ii.idea_id) FROM `idea_interior` ii WHERE `ii`.`interior_id` = `i`.id) AS ideaCount
            FROM interior i
            LEFT JOIN collection c ON c.id = i.collection
            LEFT JOIN factory f ON f.id = c.factory
            LEFT JOIN interior_article iat ON iat.interior_id = i.id
            LEFT JOIN article a ON a.id = iat.article_id
            LEFT JOIN list_country lc ON lc.id = f.country
            LEFT JOIN interior_apply ia ON ia.interior_id = i.id
            LEFT JOIN list_apply la ON la.id = ia.apply_id
            LEFT JOIN interior_texture it ON it.interior_id = i.id
            LEFT JOIN list_texture lt ON lt.id = it.texture_id
            LEFT JOIN interior_style ist ON ist.interior_id = i.id
            LEFT JOIN list_style lst ON lst.id = ist.style_id
            WHERE c.id = 3246347 AND i.status = 1
         AND i.id IN (175934, 175936)
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.68 ms
(0.00%) 		1 
SELECT
                i.id AS iId,
                i.url AS iUrl,
                i.name AS iName,
                i.alt AS iAlt,
                i.file AS iFile,
                i.status AS iStatus,
                i.file_size_x AS iFileSizeX,
                i.file_size_y AS iFileSizeY,
                i.file_size_z_x AS iFileSizeZX,
                i.file_size_z_y AS iFileSizeZY,
                i.file_size_hd_x AS iFileSizeHdX,
                i.file_size_hd_y AS iFileSizeHdY,
                i.file_size_shd_x AS iFileSizeShdX,
                i.file_size_shd_y AS iFileSizeShdY,
                i.file_size4k_x AS iFileSize4kX,
                i.file_size4k_y AS iFileSize4kY,
                c.id AS cId,
                c.url AS cUrl,
                c.status AS cStatus,
                c.name AS cName,
                c.alternate_name AS cAName,
                c.pr_min_euro AS prMinEuro,
                c.pr_min_euro_de AS prMinEuroDe,
                c.pr_min_euro_fr AS prMinEuroFr,
                c.pr_min_euro_it AS prMinEuroIt,
                c.pr_min_euro_be AS prMinEuroBe,
                c.pr_min_euro_ie AS prMinEuroIe,
                c.pr_min_euro_nl AS prMinEuroNl,
                c.pr_min_euro_es AS prMinEuroEs,
                c.pr_min_rue AS prMinRUB,
                c.pr_min_rue AS prMinRUE,
                c.pr_min_gbp AS prMinGBP,
                c.pr_min_gbe AS prMinGBE,
                c.pr_min_usd AS prMinUSD,
                c.pr_min_use AS prMinUSE,
                c.pr_min_f_usd AS prMinFUSD,
                c.pr_min_f_use AS prMinFUSE,
                c.pr_min_chf AS prMinCHF,
                c.pr_min_che AS prMinCHE,
                c.pr_min_sek AS prMinSEK,
                c.pr_min_see AS prMinSEE,
                c.pr_min_dkk AS prMinDKK,
                c.pr_min_dke AS prMinDKE,
                c.pr_min_nok AS prMinNOK,
                c.pr_min_noe AS prMinNOE,
                c.pr_min_pln AS prMinPLN,
                c.pr_min_ple AS prMinPLE,
                c.pr_min_cad AS prMinCAD,
                c.pr_min_cae AS prMinCAE,
                c.pr_min_f_cad AS prMinEuroFCAD,
                c.pr_min_f_cae AS prMinEuroFCAE,
                f.id AS fId,
                f.url AS fUrl,
                f.status AS fStatus,
                f.name AS fName,
                f.alternate_name AS fAName,
                f.suspended AS fSuspended,
                a.id AS itemId,
                lc.id AS lcId,
                lc.code AS lcCode,
                lc.alias AS lcAlias,
                la.id AS laId,
                la.alias AS laAlias,
                lst.id AS lstId,
                lst.alias AS lstAlias,
                lt.id AS ltId,
                lt.alias AS ltAlias,
                (SELECT COUNT(ii.idea_id) FROM `idea_interior` ii WHERE `ii`.`interior_id` = `i`.id) AS ideaCount
            FROM interior i
            LEFT JOIN collection c ON c.id = i.collection
            LEFT JOIN factory f ON f.id = c.factory
            LEFT JOIN interior_article iat ON iat.interior_id = i.id
            LEFT JOIN article a ON a.id = iat.article_id
            LEFT JOIN list_country lc ON lc.id = f.country
            LEFT JOIN interior_apply ia ON ia.interior_id = i.id
            LEFT JOIN list_apply la ON la.id = ia.apply_id
            LEFT JOIN interior_texture it ON it.interior_id = i.id
            LEFT JOIN list_texture lt ON lt.id = it.texture_id
            LEFT JOIN interior_style ist ON ist.interior_id = i.id
            LEFT JOIN list_style lst ON lst.id = ist.style_id
            WHERE c.id = 1651231 AND i.status = 1
         AND i.id IN (84757, 84759, 84756)
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.65 ms
(0.00%) 		1 
SELECT
                i.id AS iId,
                i.url AS iUrl,
                i.name AS iName,
                i.alt AS iAlt,
                i.file AS iFile,
                i.status AS iStatus,
                i.file_size_x AS iFileSizeX,
                i.file_size_y AS iFileSizeY,
                i.file_size_z_x AS iFileSizeZX,
                i.file_size_z_y AS iFileSizeZY,
                i.file_size_hd_x AS iFileSizeHdX,
                i.file_size_hd_y AS iFileSizeHdY,
                i.file_size_shd_x AS iFileSizeShdX,
                i.file_size_shd_y AS iFileSizeShdY,
                i.file_size4k_x AS iFileSize4kX,
                i.file_size4k_y AS iFileSize4kY,
                c.id AS cId,
                c.url AS cUrl,
                c.status AS cStatus,
                c.name AS cName,
                c.alternate_name AS cAName,
                c.pr_min_euro AS prMinEuro,
                c.pr_min_euro_de AS prMinEuroDe,
                c.pr_min_euro_fr AS prMinEuroFr,
                c.pr_min_euro_it AS prMinEuroIt,
                c.pr_min_euro_be AS prMinEuroBe,
                c.pr_min_euro_ie AS prMinEuroIe,
                c.pr_min_euro_nl AS prMinEuroNl,
                c.pr_min_euro_es AS prMinEuroEs,
                c.pr_min_rue AS prMinRUB,
                c.pr_min_rue AS prMinRUE,
                c.pr_min_gbp AS prMinGBP,
                c.pr_min_gbe AS prMinGBE,
                c.pr_min_usd AS prMinUSD,
                c.pr_min_use AS prMinUSE,
                c.pr_min_f_usd AS prMinFUSD,
                c.pr_min_f_use AS prMinFUSE,
                c.pr_min_chf AS prMinCHF,
                c.pr_min_che AS prMinCHE,
                c.pr_min_sek AS prMinSEK,
                c.pr_min_see AS prMinSEE,
                c.pr_min_dkk AS prMinDKK,
                c.pr_min_dke AS prMinDKE,
                c.pr_min_nok AS prMinNOK,
                c.pr_min_noe AS prMinNOE,
                c.pr_min_pln AS prMinPLN,
                c.pr_min_ple AS prMinPLE,
                c.pr_min_cad AS prMinCAD,
                c.pr_min_cae AS prMinCAE,
                c.pr_min_f_cad AS prMinEuroFCAD,
                c.pr_min_f_cae AS prMinEuroFCAE,
                f.id AS fId,
                f.url AS fUrl,
                f.status AS fStatus,
                f.name AS fName,
                f.alternate_name AS fAName,
                f.suspended AS fSuspended,
                a.id AS itemId,
                lc.id AS lcId,
                lc.code AS lcCode,
                lc.alias AS lcAlias,
                la.id AS laId,
                la.alias AS laAlias,
                lst.id AS lstId,
                lst.alias AS lstAlias,
                lt.id AS ltId,
                lt.alias AS ltAlias,
                (SELECT COUNT(ii.idea_id) FROM `idea_interior` ii WHERE `ii`.`interior_id` = `i`.id) AS ideaCount
            FROM interior i
            LEFT JOIN collection c ON c.id = i.collection
            LEFT JOIN factory f ON f.id = c.factory
            LEFT JOIN interior_article iat ON iat.interior_id = i.id
            LEFT JOIN article a ON a.id = iat.article_id
            LEFT JOIN list_country lc ON lc.id = f.country
            LEFT JOIN interior_apply ia ON ia.interior_id = i.id
            LEFT JOIN list_apply la ON la.id = ia.apply_id
            LEFT JOIN interior_texture it ON it.interior_id = i.id
            LEFT JOIN list_texture lt ON lt.id = it.texture_id
            LEFT JOIN interior_style ist ON ist.interior_id = i.id
            LEFT JOIN list_style lst ON lst.id = ist.style_id
            WHERE c.id = 3246672 AND i.status = 1
         AND i.id IN (178085, 178086, 178082)
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.57 ms
(0.00%) 		1 
SELECT l0_.`id` AS id_0, l0_.`name` AS name_1, l0_.`alias` AS alias_2, l0_.`sort` AS sort_3, l0_.`count` AS count_4, l0_.`hide` AS hide_5, l0_.`important` AS important_6 FROM `list_material` l0_ ORDER BY l0_.`sort` DESC, l0_.`name` ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.50 ms
(0.00%) 		1 
SELECT f0_.`id` AS id_0 FROM `geo_country` g1_ LEFT JOIN factory_hide_countries f2_ ON g1_.id = f2_.country_id LEFT JOIN `factory` f0_ ON f0_.id = f2_.factory_id WHERE g1_.`code` = ?
Parameters: 
[
  "ch"
]
View formatted query    View runnable query    Explain query
0.47 ms
(0.00%) 		1 
SELECT
                i.id AS iId,
                i.url AS iUrl,
                i.name AS iName,
                i.alt AS iAlt,
                i.file AS iFile,
                i.status AS iStatus,
                i.file_size_x AS iFileSizeX,
                i.file_size_y AS iFileSizeY,
                i.file_size_z_x AS iFileSizeZX,
                i.file_size_z_y AS iFileSizeZY,
                i.file_size_hd_x AS iFileSizeHdX,
                i.file_size_hd_y AS iFileSizeHdY,
                i.file_size_shd_x AS iFileSizeShdX,
                i.file_size_shd_y AS iFileSizeShdY,
                i.file_size4k_x AS iFileSize4kX,
                i.file_size4k_y AS iFileSize4kY,
                c.id AS cId,
                c.url AS cUrl,
                c.status AS cStatus,
                c.name AS cName,
                c.alternate_name AS cAName,
                c.pr_min_euro AS prMinEuro,
                c.pr_min_euro_de AS prMinEuroDe,
                c.pr_min_euro_fr AS prMinEuroFr,
                c.pr_min_euro_it AS prMinEuroIt,
                c.pr_min_euro_be AS prMinEuroBe,
                c.pr_min_euro_ie AS prMinEuroIe,
                c.pr_min_euro_nl AS prMinEuroNl,
                c.pr_min_euro_es AS prMinEuroEs,
                c.pr_min_rue AS prMinRUB,
                c.pr_min_rue AS prMinRUE,
                c.pr_min_gbp AS prMinGBP,
                c.pr_min_gbe AS prMinGBE,
                c.pr_min_usd AS prMinUSD,
                c.pr_min_use AS prMinUSE,
                c.pr_min_f_usd AS prMinFUSD,
                c.pr_min_f_use AS prMinFUSE,
                c.pr_min_chf AS prMinCHF,
                c.pr_min_che AS prMinCHE,
                c.pr_min_sek AS prMinSEK,
                c.pr_min_see AS prMinSEE,
                c.pr_min_dkk AS prMinDKK,
                c.pr_min_dke AS prMinDKE,
                c.pr_min_nok AS prMinNOK,
                c.pr_min_noe AS prMinNOE,
                c.pr_min_pln AS prMinPLN,
                c.pr_min_ple AS prMinPLE,
                c.pr_min_cad AS prMinCAD,
                c.pr_min_cae AS prMinCAE,
                c.pr_min_f_cad AS prMinEuroFCAD,
                c.pr_min_f_cae AS prMinEuroFCAE,
                f.id AS fId,
                f.url AS fUrl,
                f.status AS fStatus,
                f.name AS fName,
                f.alternate_name AS fAName,
                f.suspended AS fSuspended,
                a.id AS itemId,
                lc.id AS lcId,
                lc.code AS lcCode,
                lc.alias AS lcAlias,
                la.id AS laId,
                la.alias AS laAlias,
                lst.id AS lstId,
                lst.alias AS lstAlias,
                lt.id AS ltId,
                lt.alias AS ltAlias,
                (SELECT COUNT(ii.idea_id) FROM `idea_interior` ii WHERE `ii`.`interior_id` = `i`.id) AS ideaCount
            FROM interior i
            LEFT JOIN collection c ON c.id = i.collection
            LEFT JOIN factory f ON f.id = c.factory
            LEFT JOIN interior_article iat ON iat.interior_id = i.id
            LEFT JOIN article a ON a.id = iat.article_id
            LEFT JOIN list_country lc ON lc.id = f.country
            LEFT JOIN interior_apply ia ON ia.interior_id = i.id
            LEFT JOIN list_apply la ON la.id = ia.apply_id
            LEFT JOIN interior_texture it ON it.interior_id = i.id
            LEFT JOIN list_texture lt ON lt.id = it.texture_id
            LEFT JOIN interior_style ist ON ist.interior_id = i.id
            LEFT JOIN list_style lst ON lst.id = ist.style_id
            WHERE c.id = 3246974 AND i.status = 1
         AND i.id IN (180353, 180355, 180354)
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.46 ms
(0.00%) 		2 
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
0.43 ms
(0.00%) 		1 
SELECT
                i.id AS iId,
                i.url AS iUrl,
                i.name AS iName,
                i.alt AS iAlt,
                i.file AS iFile,
                i.status AS iStatus,
                i.file_size_x AS iFileSizeX,
                i.file_size_y AS iFileSizeY,
                i.file_size_z_x AS iFileSizeZX,
                i.file_size_z_y AS iFileSizeZY,
                i.file_size_hd_x AS iFileSizeHdX,
                i.file_size_hd_y AS iFileSizeHdY,
                i.file_size_shd_x AS iFileSizeShdX,
                i.file_size_shd_y AS iFileSizeShdY,
                i.file_size4k_x AS iFileSize4kX,
                i.file_size4k_y AS iFileSize4kY,
                c.id AS cId,
                c.url AS cUrl,
                c.status AS cStatus,
                c.name AS cName,
                c.alternate_name AS cAName,
                c.pr_min_euro AS prMinEuro,
                c.pr_min_euro_de AS prMinEuroDe,
                c.pr_min_euro_fr AS prMinEuroFr,
                c.pr_min_euro_it AS prMinEuroIt,
                c.pr_min_euro_be AS prMinEuroBe,
                c.pr_min_euro_ie AS prMinEuroIe,
                c.pr_min_euro_nl AS prMinEuroNl,
                c.pr_min_euro_es AS prMinEuroEs,
                c.pr_min_rue AS prMinRUB,
                c.pr_min_rue AS prMinRUE,
                c.pr_min_gbp AS prMinGBP,
                c.pr_min_gbe AS prMinGBE,
                c.pr_min_usd AS prMinUSD,
                c.pr_min_use AS prMinUSE,
                c.pr_min_f_usd AS prMinFUSD,
                c.pr_min_f_use AS prMinFUSE,
                c.pr_min_chf AS prMinCHF,
                c.pr_min_che AS prMinCHE,
                c.pr_min_sek AS prMinSEK,
                c.pr_min_see AS prMinSEE,
                c.pr_min_dkk AS prMinDKK,
                c.pr_min_dke AS prMinDKE,
                c.pr_min_nok AS prMinNOK,
                c.pr_min_noe AS prMinNOE,
                c.pr_min_pln AS prMinPLN,
                c.pr_min_ple AS prMinPLE,
                c.pr_min_cad AS prMinCAD,
                c.pr_min_cae AS prMinCAE,
                c.pr_min_f_cad AS prMinEuroFCAD,
                c.pr_min_f_cae AS prMinEuroFCAE,
                f.id AS fId,
                f.url AS fUrl,
                f.status AS fStatus,
                f.name AS fName,
                f.alternate_name AS fAName,
                f.suspended AS fSuspended,
                a.id AS itemId,
                lc.id AS lcId,
                lc.code AS lcCode,
                lc.alias AS lcAlias,
                la.id AS laId,
                la.alias AS laAlias,
                lst.id AS lstId,
                lst.alias AS lstAlias,
                lt.id AS ltId,
                lt.alias AS ltAlias,
                (SELECT COUNT(ii.idea_id) FROM `idea_interior` ii WHERE `ii`.`interior_id` = `i`.id) AS ideaCount
            FROM interior i
            LEFT JOIN collection c ON c.id = i.collection
            LEFT JOIN factory f ON f.id = c.factory
            LEFT JOIN interior_article iat ON iat.interior_id = i.id
            LEFT JOIN article a ON a.id = iat.article_id
            LEFT JOIN list_country lc ON lc.id = f.country
            LEFT JOIN interior_apply ia ON ia.interior_id = i.id
            LEFT JOIN list_apply la ON la.id = ia.apply_id
            LEFT JOIN interior_texture it ON it.interior_id = i.id
            LEFT JOIN list_texture lt ON lt.id = it.texture_id
            LEFT JOIN interior_style ist ON ist.interior_id = i.id
            LEFT JOIN list_style lst ON lst.id = ist.style_id
            WHERE c.id = 3246346 AND i.status = 1
         AND i.id IN (175931, 175933, 175932)
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.36 ms
(0.00%) 		2 
SELECT
    f2.id,
    f2.name,
    f2.old_command,
    f2.old_id,
    GROUP_CONCAT(f.id) AS ids,
    GROUP_CONCAT(f.old_id) AS old_ids
FROM
    `filters` f
LEFT JOIN filters f2 ON
    f.parent_id = f2.id
LEFT JOIN filter_params p ON
    f.param_id = p.id
WHERE
    f.parent_id IS NOT NULL AND p.is_enable = 1  AND p.show_menu_advanced != 0 
GROUP BY
    f.parent_id;
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.36 ms
(0.00%) 		1 
SELECT
                i.id AS iId,
                i.url AS iUrl,
                i.name AS iName,
                i.alt AS iAlt,
                i.file AS iFile,
                i.status AS iStatus,
                i.file_size_x AS iFileSizeX,
                i.file_size_y AS iFileSizeY,
                i.file_size_z_x AS iFileSizeZX,
                i.file_size_z_y AS iFileSizeZY,
                i.file_size_hd_x AS iFileSizeHdX,
                i.file_size_hd_y AS iFileSizeHdY,
                i.file_size_shd_x AS iFileSizeShdX,
                i.file_size_shd_y AS iFileSizeShdY,
                i.file_size4k_x AS iFileSize4kX,
                i.file_size4k_y AS iFileSize4kY,
                c.id AS cId,
                c.url AS cUrl,
                c.status AS cStatus,
                c.name AS cName,
                c.alternate_name AS cAName,
                c.pr_min_euro AS prMinEuro,
                c.pr_min_euro_de AS prMinEuroDe,
                c.pr_min_euro_fr AS prMinEuroFr,
                c.pr_min_euro_it AS prMinEuroIt,
                c.pr_min_euro_be AS prMinEuroBe,
                c.pr_min_euro_ie AS prMinEuroIe,
                c.pr_min_euro_nl AS prMinEuroNl,
                c.pr_min_euro_es AS prMinEuroEs,
                c.pr_min_rue AS prMinRUB,
                c.pr_min_rue AS prMinRUE,
                c.pr_min_gbp AS prMinGBP,
                c.pr_min_gbe AS prMinGBE,
                c.pr_min_usd AS prMinUSD,
                c.pr_min_use AS prMinUSE,
                c.pr_min_f_usd AS prMinFUSD,
                c.pr_min_f_use AS prMinFUSE,
                c.pr_min_chf AS prMinCHF,
                c.pr_min_che AS prMinCHE,
                c.pr_min_sek AS prMinSEK,
                c.pr_min_see AS prMinSEE,
                c.pr_min_dkk AS prMinDKK,
                c.pr_min_dke AS prMinDKE,
                c.pr_min_nok AS prMinNOK,
                c.pr_min_noe AS prMinNOE,
                c.pr_min_pln AS prMinPLN,
                c.pr_min_ple AS prMinPLE,
                c.pr_min_cad AS prMinCAD,
                c.pr_min_cae AS prMinCAE,
                c.pr_min_f_cad AS prMinEuroFCAD,
                c.pr_min_f_cae AS prMinEuroFCAE,
                f.id AS fId,
                f.url AS fUrl,
                f.status AS fStatus,
                f.name AS fName,
                f.alternate_name AS fAName,
                f.suspended AS fSuspended,
                a.id AS itemId,
                lc.id AS lcId,
                lc.code AS lcCode,
                lc.alias AS lcAlias,
                la.id AS laId,
                la.alias AS laAlias,
                lst.id AS lstId,
                lst.alias AS lstAlias,
                lt.id AS ltId,
                lt.alias AS ltAlias,
                (SELECT COUNT(ii.idea_id) FROM `idea_interior` ii WHERE `ii`.`interior_id` = `i`.id) AS ideaCount
            FROM interior i
            LEFT JOIN collection c ON c.id = i.collection
            LEFT JOIN factory f ON f.id = c.factory
            LEFT JOIN interior_article iat ON iat.interior_id = i.id
            LEFT JOIN article a ON a.id = iat.article_id
            LEFT JOIN list_country lc ON lc.id = f.country
            LEFT JOIN interior_apply ia ON ia.interior_id = i.id
            LEFT JOIN list_apply la ON la.id = ia.apply_id
            LEFT JOIN interior_texture it ON it.interior_id = i.id
            LEFT JOIN list_texture lt ON lt.id = it.texture_id
            LEFT JOIN interior_style ist ON ist.interior_id = i.id
            LEFT JOIN list_style lst ON lst.id = ist.style_id
            WHERE c.id = 3249584 AND i.status = 1
         AND i.id IN (199721, 199715, 199717)
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.34 ms
(0.00%) 		1 
SELECT
                i.id AS iId,
                i.url AS iUrl,
                i.name AS iName,
                i.alt AS iAlt,
                i.file AS iFile,
                i.status AS iStatus,
                i.file_size_x AS iFileSizeX,
                i.file_size_y AS iFileSizeY,
                i.file_size_z_x AS iFileSizeZX,
                i.file_size_z_y AS iFileSizeZY,
                i.file_size_hd_x AS iFileSizeHdX,
                i.file_size_hd_y AS iFileSizeHdY,
                i.file_size_shd_x AS iFileSizeShdX,
                i.file_size_shd_y AS iFileSizeShdY,
                i.file_size4k_x AS iFileSize4kX,
                i.file_size4k_y AS iFileSize4kY,
                c.id AS cId,
                c.url AS cUrl,
                c.status AS cStatus,
                c.name AS cName,
                c.alternate_name AS cAName,
                c.pr_min_euro AS prMinEuro,
                c.pr_min_euro_de AS prMinEuroDe,
                c.pr_min_euro_fr AS prMinEuroFr,
                c.pr_min_euro_it AS prMinEuroIt,
                c.pr_min_euro_be AS prMinEuroBe,
                c.pr_min_euro_ie AS prMinEuroIe,
                c.pr_min_euro_nl AS prMinEuroNl,
                c.pr_min_euro_es AS prMinEuroEs,
                c.pr_min_rue AS prMinRUB,
                c.pr_min_rue AS prMinRUE,
                c.pr_min_gbp AS prMinGBP,
                c.pr_min_gbe AS prMinGBE,
                c.pr_min_usd AS prMinUSD,
                c.pr_min_use AS prMinUSE,
                c.pr_min_f_usd AS prMinFUSD,
                c.pr_min_f_use AS prMinFUSE,
                c.pr_min_chf AS prMinCHF,
                c.pr_min_che AS prMinCHE,
                c.pr_min_sek AS prMinSEK,
                c.pr_min_see AS prMinSEE,
                c.pr_min_dkk AS prMinDKK,
                c.pr_min_dke AS prMinDKE,
                c.pr_min_nok AS prMinNOK,
                c.pr_min_noe AS prMinNOE,
                c.pr_min_pln AS prMinPLN,
                c.pr_min_ple AS prMinPLE,
                c.pr_min_cad AS prMinCAD,
                c.pr_min_cae AS prMinCAE,
                c.pr_min_f_cad AS prMinEuroFCAD,
                c.pr_min_f_cae AS prMinEuroFCAE,
                f.id AS fId,
                f.url AS fUrl,
                f.status AS fStatus,
                f.name AS fName,
                f.alternate_name AS fAName,
                f.suspended AS fSuspended,
                a.id AS itemId,
                lc.id AS lcId,
                lc.code AS lcCode,
                lc.alias AS lcAlias,
                la.id AS laId,
                la.alias AS laAlias,
                lst.id AS lstId,
                lst.alias AS lstAlias,
                lt.id AS ltId,
                lt.alias AS ltAlias,
                (SELECT COUNT(ii.idea_id) FROM `idea_interior` ii WHERE `ii`.`interior_id` = `i`.id) AS ideaCount
            FROM interior i
            LEFT JOIN collection c ON c.id = i.collection
            LEFT JOIN factory f ON f.id = c.factory
            LEFT JOIN interior_article iat ON iat.interior_id = i.id
            LEFT JOIN article a ON a.id = iat.article_id
            LEFT JOIN list_country lc ON lc.id = f.country
            LEFT JOIN interior_apply ia ON ia.interior_id = i.id
            LEFT JOIN list_apply la ON la.id = ia.apply_id
            LEFT JOIN interior_texture it ON it.interior_id = i.id
            LEFT JOIN list_texture lt ON lt.id = it.texture_id
            LEFT JOIN interior_style ist ON ist.interior_id = i.id
            LEFT JOIN list_style lst ON lst.id = ist.style_id
            WHERE c.id = 3246448 AND i.status = 1
         AND i.id IN (177463, 177415, 177417)
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.33 ms
(0.00%) 		1 
SELECT
                i.id AS iId,
                i.url AS iUrl,
                i.name AS iName,
                i.alt AS iAlt,
                i.file AS iFile,
                i.status AS iStatus,
                i.file_size_x AS iFileSizeX,
                i.file_size_y AS iFileSizeY,
                i.file_size_z_x AS iFileSizeZX,
                i.file_size_z_y AS iFileSizeZY,
                i.file_size_hd_x AS iFileSizeHdX,
                i.file_size_hd_y AS iFileSizeHdY,
                i.file_size_shd_x AS iFileSizeShdX,
                i.file_size_shd_y AS iFileSizeShdY,
                i.file_size4k_x AS iFileSize4kX,
                i.file_size4k_y AS iFileSize4kY,
                c.id AS cId,
                c.url AS cUrl,
                c.status AS cStatus,
                c.name AS cName,
                c.alternate_name AS cAName,
                c.pr_min_euro AS prMinEuro,
                c.pr_min_euro_de AS prMinEuroDe,
                c.pr_min_euro_fr AS prMinEuroFr,
                c.pr_min_euro_it AS prMinEuroIt,
                c.pr_min_euro_be AS prMinEuroBe,
                c.pr_min_euro_ie AS prMinEuroIe,
                c.pr_min_euro_nl AS prMinEuroNl,
                c.pr_min_euro_es AS prMinEuroEs,
                c.pr_min_rue AS prMinRUB,
                c.pr_min_rue AS prMinRUE,
                c.pr_min_gbp AS prMinGBP,
                c.pr_min_gbe AS prMinGBE,
                c.pr_min_usd AS prMinUSD,
                c.pr_min_use AS prMinUSE,
                c.pr_min_f_usd AS prMinFUSD,
                c.pr_min_f_use AS prMinFUSE,
                c.pr_min_chf AS prMinCHF,
                c.pr_min_che AS prMinCHE,
                c.pr_min_sek AS prMinSEK,
                c.pr_min_see AS prMinSEE,
                c.pr_min_dkk AS prMinDKK,
                c.pr_min_dke AS prMinDKE,
                c.pr_min_nok AS prMinNOK,
                c.pr_min_noe AS prMinNOE,
                c.pr_min_pln AS prMinPLN,
                c.pr_min_ple AS prMinPLE,
                c.pr_min_cad AS prMinCAD,
                c.pr_min_cae AS prMinCAE,
                c.pr_min_f_cad AS prMinEuroFCAD,
                c.pr_min_f_cae AS prMinEuroFCAE,
                f.id AS fId,
                f.url AS fUrl,
                f.status AS fStatus,
                f.name AS fName,
                f.alternate_name AS fAName,
                f.suspended AS fSuspended,
                a.id AS itemId,
                lc.id AS lcId,
                lc.code AS lcCode,
                lc.alias AS lcAlias,
                la.id AS laId,
                la.alias AS laAlias,
                lst.id AS lstId,
                lst.alias AS lstAlias,
                lt.id AS ltId,
                lt.alias AS ltAlias,
                (SELECT COUNT(ii.idea_id) FROM `idea_interior` ii WHERE `ii`.`interior_id` = `i`.id) AS ideaCount
            FROM interior i
            LEFT JOIN collection c ON c.id = i.collection
            LEFT JOIN factory f ON f.id = c.factory
            LEFT JOIN interior_article iat ON iat.interior_id = i.id
            LEFT JOIN article a ON a.id = iat.article_id
            LEFT JOIN list_country lc ON lc.id = f.country
            LEFT JOIN interior_apply ia ON ia.interior_id = i.id
            LEFT JOIN list_apply la ON la.id = ia.apply_id
            LEFT JOIN interior_texture it ON it.interior_id = i.id
            LEFT JOIN list_texture lt ON lt.id = it.texture_id
            LEFT JOIN interior_style ist ON ist.interior_id = i.id
            LEFT JOIN list_style lst ON lst.id = ist.style_id
            WHERE c.id = 3245569 AND i.status = 1
         AND i.id IN (170720)
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.32 ms
(0.00%) 		1 
SELECT
                i.id AS iId,
                i.url AS iUrl,
                i.name AS iName,
                i.alt AS iAlt,
                i.file AS iFile,
                i.status AS iStatus,
                i.file_size_x AS iFileSizeX,
                i.file_size_y AS iFileSizeY,
                i.file_size_z_x AS iFileSizeZX,
                i.file_size_z_y AS iFileSizeZY,
                i.file_size_hd_x AS iFileSizeHdX,
                i.file_size_hd_y AS iFileSizeHdY,
                i.file_size_shd_x AS iFileSizeShdX,
                i.file_size_shd_y AS iFileSizeShdY,
                i.file_size4k_x AS iFileSize4kX,
                i.file_size4k_y AS iFileSize4kY,
                c.id AS cId,
                c.url AS cUrl,
                c.status AS cStatus,
                c.name AS cName,
                c.alternate_name AS cAName,
                c.pr_min_euro AS prMinEuro,
                c.pr_min_euro_de AS prMinEuroDe,
                c.pr_min_euro_fr AS prMinEuroFr,
                c.pr_min_euro_it AS prMinEuroIt,
                c.pr_min_euro_be AS prMinEuroBe,
                c.pr_min_euro_ie AS prMinEuroIe,
                c.pr_min_euro_nl AS prMinEuroNl,
                c.pr_min_euro_es AS prMinEuroEs,
                c.pr_min_rue AS prMinRUB,
                c.pr_min_rue AS prMinRUE,
                c.pr_min_gbp AS prMinGBP,
                c.pr_min_gbe AS prMinGBE,
                c.pr_min_usd AS prMinUSD,
                c.pr_min_use AS prMinUSE,
                c.pr_min_f_usd AS prMinFUSD,
                c.pr_min_f_use AS prMinFUSE,
                c.pr_min_chf AS prMinCHF,
                c.pr_min_che AS prMinCHE,
                c.pr_min_sek AS prMinSEK,
                c.pr_min_see AS prMinSEE,
                c.pr_min_dkk AS prMinDKK,
                c.pr_min_dke AS prMinDKE,
                c.pr_min_nok AS prMinNOK,
                c.pr_min_noe AS prMinNOE,
                c.pr_min_pln AS prMinPLN,
                c.pr_min_ple AS prMinPLE,
                c.pr_min_cad AS prMinCAD,
                c.pr_min_cae AS prMinCAE,
                c.pr_min_f_cad AS prMinEuroFCAD,
                c.pr_min_f_cae AS prMinEuroFCAE,
                f.id AS fId,
                f.url AS fUrl,
                f.status AS fStatus,
                f.name AS fName,
                f.alternate_name AS fAName,
                f.suspended AS fSuspended,
                a.id AS itemId,
                lc.id AS lcId,
                lc.code AS lcCode,
                lc.alias AS lcAlias,
                la.id AS laId,
                la.alias AS laAlias,
                lst.id AS lstId,
                lst.alias AS lstAlias,
                lt.id AS ltId,
                lt.alias AS ltAlias,
                (SELECT COUNT(ii.idea_id) FROM `idea_interior` ii WHERE `ii`.`interior_id` = `i`.id) AS ideaCount
            FROM interior i
            LEFT JOIN collection c ON c.id = i.collection
            LEFT JOIN factory f ON f.id = c.factory
            LEFT JOIN interior_article iat ON iat.interior_id = i.id
            LEFT JOIN article a ON a.id = iat.article_id
            LEFT JOIN list_country lc ON lc.id = f.country
            LEFT JOIN interior_apply ia ON ia.interior_id = i.id
            LEFT JOIN list_apply la ON la.id = ia.apply_id
            LEFT JOIN interior_texture it ON it.interior_id = i.id
            LEFT JOIN list_texture lt ON lt.id = it.texture_id
            LEFT JOIN interior_style ist ON ist.interior_id = i.id
            LEFT JOIN list_style lst ON lst.id = ist.style_id
            WHERE c.id = 3245337 AND i.status = 1
         AND i.id IN (168867, 168869, 168870)
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.32 ms
(0.00%) 		1 
SELECT
                i.id AS iId,
                i.url AS iUrl,
                i.name AS iName,
                i.alt AS iAlt,
                i.file AS iFile,
                i.status AS iStatus,
                i.file_size_x AS iFileSizeX,
                i.file_size_y AS iFileSizeY,
                i.file_size_z_x AS iFileSizeZX,
                i.file_size_z_y AS iFileSizeZY,
                i.file_size_hd_x AS iFileSizeHdX,
                i.file_size_hd_y AS iFileSizeHdY,
                i.file_size_shd_x AS iFileSizeShdX,
                i.file_size_shd_y AS iFileSizeShdY,
                i.file_size4k_x AS iFileSize4kX,
                i.file_size4k_y AS iFileSize4kY,
                c.id AS cId,
                c.url AS cUrl,
                c.status AS cStatus,
                c.name AS cName,
                c.alternate_name AS cAName,
                c.pr_min_euro AS prMinEuro,
                c.pr_min_euro_de AS prMinEuroDe,
                c.pr_min_euro_fr AS prMinEuroFr,
                c.pr_min_euro_it AS prMinEuroIt,
                c.pr_min_euro_be AS prMinEuroBe,
                c.pr_min_euro_ie AS prMinEuroIe,
                c.pr_min_euro_nl AS prMinEuroNl,
                c.pr_min_euro_es AS prMinEuroEs,
                c.pr_min_rue AS prMinRUB,
                c.pr_min_rue AS prMinRUE,
                c.pr_min_gbp AS prMinGBP,
                c.pr_min_gbe AS prMinGBE,
                c.pr_min_usd AS prMinUSD,
                c.pr_min_use AS prMinUSE,
                c.pr_min_f_usd AS prMinFUSD,
                c.pr_min_f_use AS prMinFUSE,
                c.pr_min_chf AS prMinCHF,
                c.pr_min_che AS prMinCHE,
                c.pr_min_sek AS prMinSEK,
                c.pr_min_see AS prMinSEE,
                c.pr_min_dkk AS prMinDKK,
                c.pr_min_dke AS prMinDKE,
                c.pr_min_nok AS prMinNOK,
                c.pr_min_noe AS prMinNOE,
                c.pr_min_pln AS prMinPLN,
                c.pr_min_ple AS prMinPLE,
                c.pr_min_cad AS prMinCAD,
                c.pr_min_cae AS prMinCAE,
                c.pr_min_f_cad AS prMinEuroFCAD,
                c.pr_min_f_cae AS prMinEuroFCAE,
                f.id AS fId,
                f.url AS fUrl,
                f.status AS fStatus,
                f.name AS fName,
                f.alternate_name AS fAName,
                f.suspended AS fSuspended,
                a.id AS itemId,
                lc.id AS lcId,
                lc.code AS lcCode,
                lc.alias AS lcAlias,
                la.id AS laId,
                la.alias AS laAlias,
                lst.id AS lstId,
                lst.alias AS lstAlias,
                lt.id AS ltId,
                lt.alias AS ltAlias,
                (SELECT COUNT(ii.idea_id) FROM `idea_interior` ii WHERE `ii`.`interior_id` = `i`.id) AS ideaCount
            FROM interior i
            LEFT JOIN collection c ON c.id = i.collection
            LEFT JOIN factory f ON f.id = c.factory
            LEFT JOIN interior_article iat ON iat.interior_id = i.id
            LEFT JOIN article a ON a.id = iat.article_id
            LEFT JOIN list_country lc ON lc.id = f.country
            LEFT JOIN interior_apply ia ON ia.interior_id = i.id
            LEFT JOIN list_apply la ON la.id = ia.apply_id
            LEFT JOIN interior_texture it ON it.interior_id = i.id
            LEFT JOIN list_texture lt ON lt.id = it.texture_id
            LEFT JOIN interior_style ist ON ist.interior_id = i.id
            LEFT JOIN list_style lst ON lst.id = ist.style_id
            WHERE c.id = 3246673 AND i.status = 1
         AND i.id IN (178089, 178090, 178091)
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.31 ms
(0.00%) 		1 
SELECT
                i.id AS iId,
                i.url AS iUrl,
                i.name AS iName,
                i.alt AS iAlt,
                i.file AS iFile,
                i.status AS iStatus,
                i.file_size_x AS iFileSizeX,
                i.file_size_y AS iFileSizeY,
                i.file_size_z_x AS iFileSizeZX,
                i.file_size_z_y AS iFileSizeZY,
                i.file_size_hd_x AS iFileSizeHdX,
                i.file_size_hd_y AS iFileSizeHdY,
                i.file_size_shd_x AS iFileSizeShdX,
                i.file_size_shd_y AS iFileSizeShdY,
                i.file_size4k_x AS iFileSize4kX,
                i.file_size4k_y AS iFileSize4kY,
                c.id AS cId,
                c.url AS cUrl,
                c.status AS cStatus,
                c.name AS cName,
                c.alternate_name AS cAName,
                c.pr_min_euro AS prMinEuro,
                c.pr_min_euro_de AS prMinEuroDe,
                c.pr_min_euro_fr AS prMinEuroFr,
                c.pr_min_euro_it AS prMinEuroIt,
                c.pr_min_euro_be AS prMinEuroBe,
                c.pr_min_euro_ie AS prMinEuroIe,
                c.pr_min_euro_nl AS prMinEuroNl,
                c.pr_min_euro_es AS prMinEuroEs,
                c.pr_min_rue AS prMinRUB,
                c.pr_min_rue AS prMinRUE,
                c.pr_min_gbp AS prMinGBP,
                c.pr_min_gbe AS prMinGBE,
                c.pr_min_usd AS prMinUSD,
                c.pr_min_use AS prMinUSE,
                c.pr_min_f_usd AS prMinFUSD,
                c.pr_min_f_use AS prMinFUSE,
                c.pr_min_chf AS prMinCHF,
                c.pr_min_che AS prMinCHE,
                c.pr_min_sek AS prMinSEK,
                c.pr_min_see AS prMinSEE,
                c.pr_min_dkk AS prMinDKK,
                c.pr_min_dke AS prMinDKE,
                c.pr_min_nok AS prMinNOK,
                c.pr_min_noe AS prMinNOE,
                c.pr_min_pln AS prMinPLN,
                c.pr_min_ple AS prMinPLE,
                c.pr_min_cad AS prMinCAD,
                c.pr_min_cae AS prMinCAE,
                c.pr_min_f_cad AS prMinEuroFCAD,
                c.pr_min_f_cae AS prMinEuroFCAE,
                f.id AS fId,
                f.url AS fUrl,
                f.status AS fStatus,
                f.name AS fName,
                f.alternate_name AS fAName,
                f.suspended AS fSuspended,
                a.id AS itemId,
                lc.id AS lcId,
                lc.code AS lcCode,
                lc.alias AS lcAlias,
                la.id AS laId,
                la.alias AS laAlias,
                lst.id AS lstId,
                lst.alias AS lstAlias,
                lt.id AS ltId,
                lt.alias AS ltAlias,
                (SELECT COUNT(ii.idea_id) FROM `idea_interior` ii WHERE `ii`.`interior_id` = `i`.id) AS ideaCount
            FROM interior i
            LEFT JOIN collection c ON c.id = i.collection
            LEFT JOIN factory f ON f.id = c.factory
            LEFT JOIN interior_article iat ON iat.interior_id = i.id
            LEFT JOIN article a ON a.id = iat.article_id
            LEFT JOIN list_country lc ON lc.id = f.country
            LEFT JOIN interior_apply ia ON ia.interior_id = i.id
            LEFT JOIN list_apply la ON la.id = ia.apply_id
            LEFT JOIN interior_texture it ON it.interior_id = i.id
            LEFT JOIN list_texture lt ON lt.id = it.texture_id
            LEFT JOIN interior_style ist ON ist.interior_id = i.id
            LEFT JOIN list_style lst ON lst.id = ist.style_id
            WHERE c.id = 3246973 AND i.status = 1
         AND i.id IN (180349, 180352, 180350)
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.30 ms
(0.00%) 		1 
SELECT
                i.id AS iId,
                i.url AS iUrl,
                i.name AS iName,
                i.alt AS iAlt,
                i.file AS iFile,
                i.status AS iStatus,
                i.file_size_x AS iFileSizeX,
                i.file_size_y AS iFileSizeY,
                i.file_size_z_x AS iFileSizeZX,
                i.file_size_z_y AS iFileSizeZY,
                i.file_size_hd_x AS iFileSizeHdX,
                i.file_size_hd_y AS iFileSizeHdY,
                i.file_size_shd_x AS iFileSizeShdX,
                i.file_size_shd_y AS iFileSizeShdY,
                i.file_size4k_x AS iFileSize4kX,
                i.file_size4k_y AS iFileSize4kY,
                c.id AS cId,
                c.url AS cUrl,
                c.status AS cStatus,
                c.name AS cName,
                c.alternate_name AS cAName,
                c.pr_min_euro AS prMinEuro,
                c.pr_min_euro_de AS prMinEuroDe,
                c.pr_min_euro_fr AS prMinEuroFr,
                c.pr_min_euro_it AS prMinEuroIt,
                c.pr_min_euro_be AS prMinEuroBe,
                c.pr_min_euro_ie AS prMinEuroIe,
                c.pr_min_euro_nl AS prMinEuroNl,
                c.pr_min_euro_es AS prMinEuroEs,
                c.pr_min_rue AS prMinRUB,
                c.pr_min_rue AS prMinRUE,
                c.pr_min_gbp AS prMinGBP,
                c.pr_min_gbe AS prMinGBE,
                c.pr_min_usd AS prMinUSD,
                c.pr_min_use AS prMinUSE,
                c.pr_min_f_usd AS prMinFUSD,
                c.pr_min_f_use AS prMinFUSE,
                c.pr_min_chf AS prMinCHF,
                c.pr_min_che AS prMinCHE,
                c.pr_min_sek AS prMinSEK,
                c.pr_min_see AS prMinSEE,
                c.pr_min_dkk AS prMinDKK,
                c.pr_min_dke AS prMinDKE,
                c.pr_min_nok AS prMinNOK,
                c.pr_min_noe AS prMinNOE,
                c.pr_min_pln AS prMinPLN,
                c.pr_min_ple AS prMinPLE,
                c.pr_min_cad AS prMinCAD,
                c.pr_min_cae AS prMinCAE,
                c.pr_min_f_cad AS prMinEuroFCAD,
                c.pr_min_f_cae AS prMinEuroFCAE,
                f.id AS fId,
                f.url AS fUrl,
                f.status AS fStatus,
                f.name AS fName,
                f.alternate_name AS fAName,
                f.suspended AS fSuspended,
                a.id AS itemId,
                lc.id AS lcId,
                lc.code AS lcCode,
                lc.alias AS lcAlias,
                la.id AS laId,
                la.alias AS laAlias,
                lst.id AS lstId,
                lst.alias AS lstAlias,
                lt.id AS ltId,
                lt.alias AS ltAlias,
                (SELECT COUNT(ii.idea_id) FROM `idea_interior` ii WHERE `ii`.`interior_id` = `i`.id) AS ideaCount
            FROM interior i
            LEFT JOIN collection c ON c.id = i.collection
            LEFT JOIN factory f ON f.id = c.factory
            LEFT JOIN interior_article iat ON iat.interior_id = i.id
            LEFT JOIN article a ON a.id = iat.article_id
            LEFT JOIN list_country lc ON lc.id = f.country
            LEFT JOIN interior_apply ia ON ia.interior_id = i.id
            LEFT JOIN list_apply la ON la.id = ia.apply_id
            LEFT JOIN interior_texture it ON it.interior_id = i.id
            LEFT JOIN list_texture lt ON lt.id = it.texture_id
            LEFT JOIN interior_style ist ON ist.interior_id = i.id
            LEFT JOIN list_style lst ON lst.id = ist.style_id
            WHERE c.id = 3245427 AND i.status = 1
         AND i.id IN (169450, 169451)
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.29 ms
(0.00%) 		1 
SELECT
                i.id AS iId,
                i.url AS iUrl,
                i.name AS iName,
                i.alt AS iAlt,
                i.file AS iFile,
                i.status AS iStatus,
                i.file_size_x AS iFileSizeX,
                i.file_size_y AS iFileSizeY,
                i.file_size_z_x AS iFileSizeZX,
                i.file_size_z_y AS iFileSizeZY,
                i.file_size_hd_x AS iFileSizeHdX,
                i.file_size_hd_y AS iFileSizeHdY,
                i.file_size_shd_x AS iFileSizeShdX,
                i.file_size_shd_y AS iFileSizeShdY,
                i.file_size4k_x AS iFileSize4kX,
                i.file_size4k_y AS iFileSize4kY,
                c.id AS cId,
                c.url AS cUrl,
                c.status AS cStatus,
                c.name AS cName,
                c.alternate_name AS cAName,
                c.pr_min_euro AS prMinEuro,
                c.pr_min_euro_de AS prMinEuroDe,
                c.pr_min_euro_fr AS prMinEuroFr,
                c.pr_min_euro_it AS prMinEuroIt,
                c.pr_min_euro_be AS prMinEuroBe,
                c.pr_min_euro_ie AS prMinEuroIe,
                c.pr_min_euro_nl AS prMinEuroNl,
                c.pr_min_euro_es AS prMinEuroEs,
                c.pr_min_rue AS prMinRUB,
                c.pr_min_rue AS prMinRUE,
                c.pr_min_gbp AS prMinGBP,
                c.pr_min_gbe AS prMinGBE,
                c.pr_min_usd AS prMinUSD,
                c.pr_min_use AS prMinUSE,
                c.pr_min_f_usd AS prMinFUSD,
                c.pr_min_f_use AS prMinFUSE,
                c.pr_min_chf AS prMinCHF,
                c.pr_min_che AS prMinCHE,
                c.pr_min_sek AS prMinSEK,
                c.pr_min_see AS prMinSEE,
                c.pr_min_dkk AS prMinDKK,
                c.pr_min_dke AS prMinDKE,
                c.pr_min_nok AS prMinNOK,
                c.pr_min_noe AS prMinNOE,
                c.pr_min_pln AS prMinPLN,
                c.pr_min_ple AS prMinPLE,
                c.pr_min_cad AS prMinCAD,
                c.pr_min_cae AS prMinCAE,
                c.pr_min_f_cad AS prMinEuroFCAD,
                c.pr_min_f_cae AS prMinEuroFCAE,
                f.id AS fId,
                f.url AS fUrl,
                f.status AS fStatus,
                f.name AS fName,
                f.alternate_name AS fAName,
                f.suspended AS fSuspended,
                a.id AS itemId,
                lc.id AS lcId,
                lc.code AS lcCode,
                lc.alias AS lcAlias,
                la.id AS laId,
                la.alias AS laAlias,
                lst.id AS lstId,
                lst.alias AS lstAlias,
                lt.id AS ltId,
                lt.alias AS ltAlias,
                (SELECT COUNT(ii.idea_id) FROM `idea_interior` ii WHERE `ii`.`interior_id` = `i`.id) AS ideaCount
            FROM interior i
            LEFT JOIN collection c ON c.id = i.collection
            LEFT JOIN factory f ON f.id = c.factory
            LEFT JOIN interior_article iat ON iat.interior_id = i.id
            LEFT JOIN article a ON a.id = iat.article_id
            LEFT JOIN list_country lc ON lc.id = f.country
            LEFT JOIN interior_apply ia ON ia.interior_id = i.id
            LEFT JOIN list_apply la ON la.id = ia.apply_id
            LEFT JOIN interior_texture it ON it.interior_id = i.id
            LEFT JOIN list_texture lt ON lt.id = it.texture_id
            LEFT JOIN interior_style ist ON ist.interior_id = i.id
            LEFT JOIN list_style lst ON lst.id = ist.style_id
            WHERE c.id = 3246669 AND i.status = 1
         AND i.id IN (178078, 178081, 178074)
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.29 ms
(0.00%) 		1 
SELECT
                i.id AS iId,
                i.url AS iUrl,
                i.name AS iName,
                i.alt AS iAlt,
                i.file AS iFile,
                i.status AS iStatus,
                i.file_size_x AS iFileSizeX,
                i.file_size_y AS iFileSizeY,
                i.file_size_z_x AS iFileSizeZX,
                i.file_size_z_y AS iFileSizeZY,
                i.file_size_hd_x AS iFileSizeHdX,
                i.file_size_hd_y AS iFileSizeHdY,
                i.file_size_shd_x AS iFileSizeShdX,
                i.file_size_shd_y AS iFileSizeShdY,
                i.file_size4k_x AS iFileSize4kX,
                i.file_size4k_y AS iFileSize4kY,
                c.id AS cId,
                c.url AS cUrl,
                c.status AS cStatus,
                c.name AS cName,
                c.alternate_name AS cAName,
                c.pr_min_euro AS prMinEuro,
                c.pr_min_euro_de AS prMinEuroDe,
                c.pr_min_euro_fr AS prMinEuroFr,
                c.pr_min_euro_it AS prMinEuroIt,
                c.pr_min_euro_be AS prMinEuroBe,
                c.pr_min_euro_ie AS prMinEuroIe,
                c.pr_min_euro_nl AS prMinEuroNl,
                c.pr_min_euro_es AS prMinEuroEs,
                c.pr_min_rue AS prMinRUB,
                c.pr_min_rue AS prMinRUE,
                c.pr_min_gbp AS prMinGBP,
                c.pr_min_gbe AS prMinGBE,
                c.pr_min_usd AS prMinUSD,
                c.pr_min_use AS prMinUSE,
                c.pr_min_f_usd AS prMinFUSD,
                c.pr_min_f_use AS prMinFUSE,
                c.pr_min_chf AS prMinCHF,
                c.pr_min_che AS prMinCHE,
                c.pr_min_sek AS prMinSEK,
                c.pr_min_see AS prMinSEE,
                c.pr_min_dkk AS prMinDKK,
                c.pr_min_dke AS prMinDKE,
                c.pr_min_nok AS prMinNOK,
                c.pr_min_noe AS prMinNOE,
                c.pr_min_pln AS prMinPLN,
                c.pr_min_ple AS prMinPLE,
                c.pr_min_cad AS prMinCAD,
                c.pr_min_cae AS prMinCAE,
                c.pr_min_f_cad AS prMinEuroFCAD,
                c.pr_min_f_cae AS prMinEuroFCAE,
                f.id AS fId,
                f.url AS fUrl,
                f.status AS fStatus,
                f.name AS fName,
                f.alternate_name AS fAName,
                f.suspended AS fSuspended,
                a.id AS itemId,
                lc.id AS lcId,
                lc.code AS lcCode,
                lc.alias AS lcAlias,
                la.id AS laId,
                la.alias AS laAlias,
                lst.id AS lstId,
                lst.alias AS lstAlias,
                lt.id AS ltId,
                lt.alias AS ltAlias,
                (SELECT COUNT(ii.idea_id) FROM `idea_interior` ii WHERE `ii`.`interior_id` = `i`.id) AS ideaCount
            FROM interior i
            LEFT JOIN collection c ON c.id = i.collection
            LEFT JOIN factory f ON f.id = c.factory
            LEFT JOIN interior_article iat ON iat.interior_id = i.id
            LEFT JOIN article a ON a.id = iat.article_id
            LEFT JOIN list_country lc ON lc.id = f.country
            LEFT JOIN interior_apply ia ON ia.interior_id = i.id
            LEFT JOIN list_apply la ON la.id = ia.apply_id
            LEFT JOIN interior_texture it ON it.interior_id = i.id
            LEFT JOIN list_texture lt ON lt.id = it.texture_id
            LEFT JOIN interior_style ist ON ist.interior_id = i.id
            LEFT JOIN list_style lst ON lst.id = ist.style_id
            WHERE c.id = 3246444 AND i.status = 1
         AND i.id IN (177413, 177412, 177411)
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.28 ms
(0.00%) 		1 
SELECT
                i.id AS iId,
                i.url AS iUrl,
                i.name AS iName,
                i.alt AS iAlt,
                i.file AS iFile,
                i.status AS iStatus,
                i.file_size_x AS iFileSizeX,
                i.file_size_y AS iFileSizeY,
                i.file_size_z_x AS iFileSizeZX,
                i.file_size_z_y AS iFileSizeZY,
                i.file_size_hd_x AS iFileSizeHdX,
                i.file_size_hd_y AS iFileSizeHdY,
                i.file_size_shd_x AS iFileSizeShdX,
                i.file_size_shd_y AS iFileSizeShdY,
                i.file_size4k_x AS iFileSize4kX,
                i.file_size4k_y AS iFileSize4kY,
                c.id AS cId,
                c.url AS cUrl,
                c.status AS cStatus,
                c.name AS cName,
                c.alternate_name AS cAName,
                c.pr_min_euro AS prMinEuro,
                c.pr_min_euro_de AS prMinEuroDe,
                c.pr_min_euro_fr AS prMinEuroFr,
                c.pr_min_euro_it AS prMinEuroIt,
                c.pr_min_euro_be AS prMinEuroBe,
                c.pr_min_euro_ie AS prMinEuroIe,
                c.pr_min_euro_nl AS prMinEuroNl,
                c.pr_min_euro_es AS prMinEuroEs,
                c.pr_min_rue AS prMinRUB,
                c.pr_min_rue AS prMinRUE,
                c.pr_min_gbp AS prMinGBP,
                c.pr_min_gbe AS prMinGBE,
                c.pr_min_usd AS prMinUSD,
                c.pr_min_use AS prMinUSE,
                c.pr_min_f_usd AS prMinFUSD,
                c.pr_min_f_use AS prMinFUSE,
                c.pr_min_chf AS prMinCHF,
                c.pr_min_che AS prMinCHE,
                c.pr_min_sek AS prMinSEK,
                c.pr_min_see AS prMinSEE,
                c.pr_min_dkk AS prMinDKK,
                c.pr_min_dke AS prMinDKE,
                c.pr_min_nok AS prMinNOK,
                c.pr_min_noe AS prMinNOE,
                c.pr_min_pln AS prMinPLN,
                c.pr_min_ple AS prMinPLE,
                c.pr_min_cad AS prMinCAD,
                c.pr_min_cae AS prMinCAE,
                c.pr_min_f_cad AS prMinEuroFCAD,
                c.pr_min_f_cae AS prMinEuroFCAE,
                f.id AS fId,
                f.url AS fUrl,
                f.status AS fStatus,
                f.name AS fName,
                f.alternate_name AS fAName,
                f.suspended AS fSuspended,
                a.id AS itemId,
                lc.id AS lcId,
                lc.code AS lcCode,
                lc.alias AS lcAlias,
                la.id AS laId,
                la.alias AS laAlias,
                lst.id AS lstId,
                lst.alias AS lstAlias,
                lt.id AS ltId,
                lt.alias AS ltAlias,
                (SELECT COUNT(ii.idea_id) FROM `idea_interior` ii WHERE `ii`.`interior_id` = `i`.id) AS ideaCount
            FROM interior i
            LEFT JOIN collection c ON c.id = i.collection
            LEFT JOIN factory f ON f.id = c.factory
            LEFT JOIN interior_article iat ON iat.interior_id = i.id
            LEFT JOIN article a ON a.id = iat.article_id
            LEFT JOIN list_country lc ON lc.id = f.country
            LEFT JOIN interior_apply ia ON ia.interior_id = i.id
            LEFT JOIN list_apply la ON la.id = ia.apply_id
            LEFT JOIN interior_texture it ON it.interior_id = i.id
            LEFT JOIN list_texture lt ON lt.id = it.texture_id
            LEFT JOIN interior_style ist ON ist.interior_id = i.id
            LEFT JOIN list_style lst ON lst.id = ist.style_id
            WHERE c.id = 3248044 AND i.status = 1
         AND i.id IN (187770, 187769)
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.28 ms
(0.00%) 		1 
SELECT
                i.id AS iId,
                i.url AS iUrl,
                i.name AS iName,
                i.alt AS iAlt,
                i.file AS iFile,
                i.status AS iStatus,
                i.file_size_x AS iFileSizeX,
                i.file_size_y AS iFileSizeY,
                i.file_size_z_x AS iFileSizeZX,
                i.file_size_z_y AS iFileSizeZY,
                i.file_size_hd_x AS iFileSizeHdX,
                i.file_size_hd_y AS iFileSizeHdY,
                i.file_size_shd_x AS iFileSizeShdX,
                i.file_size_shd_y AS iFileSizeShdY,
                i.file_size4k_x AS iFileSize4kX,
                i.file_size4k_y AS iFileSize4kY,
                c.id AS cId,
                c.url AS cUrl,
                c.status AS cStatus,
                c.name AS cName,
                c.alternate_name AS cAName,
                c.pr_min_euro AS prMinEuro,
                c.pr_min_euro_de AS prMinEuroDe,
                c.pr_min_euro_fr AS prMinEuroFr,
                c.pr_min_euro_it AS prMinEuroIt,
                c.pr_min_euro_be AS prMinEuroBe,
                c.pr_min_euro_ie AS prMinEuroIe,
                c.pr_min_euro_nl AS prMinEuroNl,
                c.pr_min_euro_es AS prMinEuroEs,
                c.pr_min_rue AS prMinRUB,
                c.pr_min_rue AS prMinRUE,
                c.pr_min_gbp AS prMinGBP,
                c.pr_min_gbe AS prMinGBE,
                c.pr_min_usd AS prMinUSD,
                c.pr_min_use AS prMinUSE,
                c.pr_min_f_usd AS prMinFUSD,
                c.pr_min_f_use AS prMinFUSE,
                c.pr_min_chf AS prMinCHF,
                c.pr_min_che AS prMinCHE,
                c.pr_min_sek AS prMinSEK,
                c.pr_min_see AS prMinSEE,
                c.pr_min_dkk AS prMinDKK,
                c.pr_min_dke AS prMinDKE,
                c.pr_min_nok AS prMinNOK,
                c.pr_min_noe AS prMinNOE,
                c.pr_min_pln AS prMinPLN,
                c.pr_min_ple AS prMinPLE,
                c.pr_min_cad AS prMinCAD,
                c.pr_min_cae AS prMinCAE,
                c.pr_min_f_cad AS prMinEuroFCAD,
                c.pr_min_f_cae AS prMinEuroFCAE,
                f.id AS fId,
                f.url AS fUrl,
                f.status AS fStatus,
                f.name AS fName,
                f.alternate_name AS fAName,
                f.suspended AS fSuspended,
                a.id AS itemId,
                lc.id AS lcId,
                lc.code AS lcCode,
                lc.alias AS lcAlias,
                la.id AS laId,
                la.alias AS laAlias,
                lst.id AS lstId,
                lst.alias AS lstAlias,
                lt.id AS ltId,
                lt.alias AS ltAlias,
                (SELECT COUNT(ii.idea_id) FROM `idea_interior` ii WHERE `ii`.`interior_id` = `i`.id) AS ideaCount
            FROM interior i
            LEFT JOIN collection c ON c.id = i.collection
            LEFT JOIN factory f ON f.id = c.factory
            LEFT JOIN interior_article iat ON iat.interior_id = i.id
            LEFT JOIN article a ON a.id = iat.article_id
            LEFT JOIN list_country lc ON lc.id = f.country
            LEFT JOIN interior_apply ia ON ia.interior_id = i.id
            LEFT JOIN list_apply la ON la.id = ia.apply_id
            LEFT JOIN interior_texture it ON it.interior_id = i.id
            LEFT JOIN list_texture lt ON lt.id = it.texture_id
            LEFT JOIN interior_style ist ON ist.interior_id = i.id
            LEFT JOIN list_style lst ON lst.id = ist.style_id
            WHERE c.id = 3249288 AND i.status = 1
         AND i.id IN (196999, 197008, 197007)
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.27 ms
(0.00%) 		1 
SELECT t0.`id` AS id_1, t0.`unid` AS unid_2, t0.`name` AS name_3, t0.`name_inv` AS name_inv_4, t0.`url` AS url_5, t0.`alternate_name` AS alternate_name_6, t0.`description_ru` AS description_ru_7, t0.`description_en` AS description_en_8, t0.`description_it` AS description_it_9, t0.`description_es` AS description_es_10, t0.`description_fr` AS description_fr_11, t0.`description_de` AS description_de_12, t0.`description_pt` AS description_pt_13, t0.`description_pl` AS description_pl_14, t0.`description_nl` AS description_nl_15, t0.`description_fi` AS description_fi_16, t0.`description_ua` AS description_ua_17, t0.`description_sv` AS description_sv_18, t0.`description_no` AS description_no_19, t0.`description_da` AS description_da_20, t0.`description_zh` AS description_zh_21, t0.`delivery_time` AS delivery_time_22, t0.`not_regular` AS not_regular_23, t0.`suspended` AS suspended_24, t0.`status` AS status_25, t0.`type` AS type_26, t0.`discount` AS discount_27, t0.`discount_date_start` AS discount_date_start_28, t0.`discount_date_end` AS discount_date_end_29, t0.`transcription` AS transcription_30, t0.`cost_delivery` AS cost_delivery_31, t0.`create_date` AS create_date_32, t0.`is_accepted` AS is_accepted_33, t0.`accepted_at` AS accepted_at_34, t0.`accept_state` AS accept_state_35, t0.`description_edit` AS description_edit_36, t0.`stated_at` AS stated_at_37, t0.`state` AS state_38, t0.`description_state` AS description_state_39, t0.`video` AS video_40, t0.`parser_address` AS parser_address_41, t0.`accessible` AS accessible_42, t0.`sound` AS sound_43, t0.`test_access` AS test_access_44, t0.`total_ideas` AS total_ideas_45, t0.`votes_submit` AS votes_submit_46, t0.`votes_stars` AS votes_stars_47, t0.`brand_link` AS brand_link_48, t0.`brand_logo` AS brand_logo_49, t0.`no_send_portl_message` AS no_send_portl_message_50, t0.user_id AS user_id_51, t0.country AS country_52, t0.filter AS filter_53 FROM `factory` t0 WHERE t0.`id` = ?
Parameters: 
[
  75
]
View formatted query    View runnable query    Explain query
0.25 ms
(0.00%) 		1 
SELECT
                i.id AS iId,
                i.url AS iUrl,
                i.name AS iName,
                i.alt AS iAlt,
                i.file AS iFile,
                i.status AS iStatus,
                i.file_size_x AS iFileSizeX,
                i.file_size_y AS iFileSizeY,
                i.file_size_z_x AS iFileSizeZX,
                i.file_size_z_y AS iFileSizeZY,
                i.file_size_hd_x AS iFileSizeHdX,
                i.file_size_hd_y AS iFileSizeHdY,
                i.file_size_shd_x AS iFileSizeShdX,
                i.file_size_shd_y AS iFileSizeShdY,
                i.file_size4k_x AS iFileSize4kX,
                i.file_size4k_y AS iFileSize4kY,
                c.id AS cId,
                c.url AS cUrl,
                c.status AS cStatus,
                c.name AS cName,
                c.alternate_name AS cAName,
                c.pr_min_euro AS prMinEuro,
                c.pr_min_euro_de AS prMinEuroDe,
                c.pr_min_euro_fr AS prMinEuroFr,
                c.pr_min_euro_it AS prMinEuroIt,
                c.pr_min_euro_be AS prMinEuroBe,
                c.pr_min_euro_ie AS prMinEuroIe,
                c.pr_min_euro_nl AS prMinEuroNl,
                c.pr_min_euro_es AS prMinEuroEs,
                c.pr_min_rue AS prMinRUB,
                c.pr_min_rue AS prMinRUE,
                c.pr_min_gbp AS prMinGBP,
                c.pr_min_gbe AS prMinGBE,
                c.pr_min_usd AS prMinUSD,
                c.pr_min_use AS prMinUSE,
                c.pr_min_f_usd AS prMinFUSD,
                c.pr_min_f_use AS prMinFUSE,
                c.pr_min_chf AS prMinCHF,
                c.pr_min_che AS prMinCHE,
                c.pr_min_sek AS prMinSEK,
                c.pr_min_see AS prMinSEE,
                c.pr_min_dkk AS prMinDKK,
                c.pr_min_dke AS prMinDKE,
                c.pr_min_nok AS prMinNOK,
                c.pr_min_noe AS prMinNOE,
                c.pr_min_pln AS prMinPLN,
                c.pr_min_ple AS prMinPLE,
                c.pr_min_cad AS prMinCAD,
                c.pr_min_cae AS prMinCAE,
                c.pr_min_f_cad AS prMinEuroFCAD,
                c.pr_min_f_cae AS prMinEuroFCAE,
                f.id AS fId,
                f.url AS fUrl,
                f.status AS fStatus,
                f.name AS fName,
                f.alternate_name AS fAName,
                f.suspended AS fSuspended,
                a.id AS itemId,
                lc.id AS lcId,
                lc.code AS lcCode,
                lc.alias AS lcAlias,
                la.id AS laId,
                la.alias AS laAlias,
                lst.id AS lstId,
                lst.alias AS lstAlias,
                lt.id AS ltId,
                lt.alias AS ltAlias,
                (SELECT COUNT(ii.idea_id) FROM `idea_interior` ii WHERE `ii`.`interior_id` = `i`.id) AS ideaCount
            FROM interior i
            LEFT JOIN collection c ON c.id = i.collection
            LEFT JOIN factory f ON f.id = c.factory
            LEFT JOIN interior_article iat ON iat.interior_id = i.id
            LEFT JOIN article a ON a.id = iat.article_id
            LEFT JOIN list_country lc ON lc.id = f.country
            LEFT JOIN interior_apply ia ON ia.interior_id = i.id
            LEFT JOIN list_apply la ON la.id = ia.apply_id
            LEFT JOIN interior_texture it ON it.interior_id = i.id
            LEFT JOIN list_texture lt ON lt.id = it.texture_id
            LEFT JOIN interior_style ist ON ist.interior_id = i.id
            LEFT JOIN list_style lst ON lst.id = ist.style_id
            WHERE c.id = 1861195 AND i.status = 1
         AND i.id IN (91977, 91973, 91974)
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.23 ms
(0.00%) 		1 
SELECT
                i.id AS iId,
                i.url AS iUrl,
                i.name AS iName,
                i.alt AS iAlt,
                i.file AS iFile,
                i.status AS iStatus,
                i.file_size_x AS iFileSizeX,
                i.file_size_y AS iFileSizeY,
                i.file_size_z_x AS iFileSizeZX,
                i.file_size_z_y AS iFileSizeZY,
                i.file_size_hd_x AS iFileSizeHdX,
                i.file_size_hd_y AS iFileSizeHdY,
                i.file_size_shd_x AS iFileSizeShdX,
                i.file_size_shd_y AS iFileSizeShdY,
                i.file_size4k_x AS iFileSize4kX,
                i.file_size4k_y AS iFileSize4kY,
                c.id AS cId,
                c.url AS cUrl,
                c.status AS cStatus,
                c.name AS cName,
                c.alternate_name AS cAName,
                c.pr_min_euro AS prMinEuro,
                c.pr_min_euro_de AS prMinEuroDe,
                c.pr_min_euro_fr AS prMinEuroFr,
                c.pr_min_euro_it AS prMinEuroIt,
                c.pr_min_euro_be AS prMinEuroBe,
                c.pr_min_euro_ie AS prMinEuroIe,
                c.pr_min_euro_nl AS prMinEuroNl,
                c.pr_min_euro_es AS prMinEuroEs,
                c.pr_min_rue AS prMinRUB,
                c.pr_min_rue AS prMinRUE,
                c.pr_min_gbp AS prMinGBP,
                c.pr_min_gbe AS prMinGBE,
                c.pr_min_usd AS prMinUSD,
                c.pr_min_use AS prMinUSE,
                c.pr_min_f_usd AS prMinFUSD,
                c.pr_min_f_use AS prMinFUSE,
                c.pr_min_chf AS prMinCHF,
                c.pr_min_che AS prMinCHE,
                c.pr_min_sek AS prMinSEK,
                c.pr_min_see AS prMinSEE,
                c.pr_min_dkk AS prMinDKK,
                c.pr_min_dke AS prMinDKE,
                c.pr_min_nok AS prMinNOK,
                c.pr_min_noe AS prMinNOE,
                c.pr_min_pln AS prMinPLN,
                c.pr_min_ple AS prMinPLE,
                c.pr_min_cad AS prMinCAD,
                c.pr_min_cae AS prMinCAE,
                c.pr_min_f_cad AS prMinEuroFCAD,
                c.pr_min_f_cae AS prMinEuroFCAE,
                f.id AS fId,
                f.url AS fUrl,
                f.status AS fStatus,
                f.name AS fName,
                f.alternate_name AS fAName,
                f.suspended AS fSuspended,
                a.id AS itemId,
                lc.id AS lcId,
                lc.code AS lcCode,
                lc.alias AS lcAlias,
                la.id AS laId,
                la.alias AS laAlias,
                lst.id AS lstId,
                lst.alias AS lstAlias,
                lt.id AS ltId,
                lt.alias AS ltAlias,
                (SELECT COUNT(ii.idea_id) FROM `idea_interior` ii WHERE `ii`.`interior_id` = `i`.id) AS ideaCount
            FROM interior i
            LEFT JOIN collection c ON c.id = i.collection
            LEFT JOIN factory f ON f.id = c.factory
            LEFT JOIN interior_article iat ON iat.interior_id = i.id
            LEFT JOIN article a ON a.id = iat.article_id
            LEFT JOIN list_country lc ON lc.id = f.country
            LEFT JOIN interior_apply ia ON ia.interior_id = i.id
            LEFT JOIN list_apply la ON la.id = ia.apply_id
            LEFT JOIN interior_texture it ON it.interior_id = i.id
            LEFT JOIN list_texture lt ON lt.id = it.texture_id
            LEFT JOIN interior_style ist ON ist.interior_id = i.id
            LEFT JOIN list_style lst ON lst.id = ist.style_id
            WHERE c.id = 3245536 AND i.status = 1
         AND i.id IN (170621, 170620)
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.21 ms
(0.00%) 		1 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.21 ms
(0.00%) 		1 
SELECT t0.`id` AS id_1, t0.`token` AS token_2, t0.`current_welcome_cons` AS current_welcome_cons_3, t0.`current_country` AS current_country_4, t0.`current_country_by_ip` AS current_country_by_ip_5, t0.`current_locale` AS current_locale_6, t0.`is_interview` AS is_interview_7, t0.`job_seeker_unid` AS job_seeker_unid_8, t0.interview_id AS interview_id_9 FROM `chat_b` t0 WHERE t0.`token` = ? LIMIT 1
Parameters: 
[
  "d74acfc5c5c18191ac50b6aa497d76a9c15401479fc08e70c07be154dcc343c4"
]
View formatted query    View runnable query    Explain query
0.19 ms
(0.00%) 		1 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.17 ms
(0.00%) 		1 
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: 
[
  "d74acfc5c5c18191ac50b6aa497d76a9c15401479fc08e70c07be154dcc343c4"
]
View formatted query    View runnable query    Explain query
0.16 ms
(0.00%) 		1 
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: 
[
  "d74acfc5c5c18191ac50b6aa497d76a9c15401479fc08e70c07be154dcc343c4"
]
View formatted query    View runnable query    Explain query
0.13 ms
(0.00%) 		1 
SELECT t0.`id` AS id_1, t0.`name` AS name_2, t0.`alias` AS alias_3, t0.`sort` AS sort_4, t0.`count` AS count_5, t0.`hide` AS hide_6, t0.`important` AS important_7 FROM `list_measure` t0 WHERE t0.`hide` = ?
Parameters: 
[
  0
]
View formatted query    View runnable query    Explain query
0.13 ms
(0.00%) 		1 
SELECT b0_.`id` AS id_0 FROM `buy_order` b0_ WHERE b0_.`token` = ? AND b0_.`status` <> 12
Parameters: 
[
  "d74acfc5c5c18191ac50b6aa497d76a9c15401479fc08e70c07be154dcc343c4"
]
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\Publication No errors.
WebBundle\Entity\FilterEntity No errors.
WebBundle\Entity\Collection No errors.
WebBundle\Entity\Factory No errors.
WebBundle\Entity\ListMeasure No errors.
WebBundle\Entity\ListMaterial No errors.
WebBundle\Entity\ProductReviewsCache No errors.
WebBundle\Entity\ReviewsCache No errors.
WebBundle\Entity\ListCountry No errors.
WebBundle\Entity\Article No errors.
WebBundle\Entity\Interior No errors.
WebBundle\Entity\Idea 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\ListApply No errors.
WebBundle\Entity\ListStyle No errors.
WebBundle\Entity\ListTexture No errors.
WebBundle\Entity\FactoryUser No errors.
WebBundle\Entity\ListBrandParser No errors.
FlexApp\Entity\Exhibition\ExhBrandEntity No errors.
WebBundle\Entity\CheckList No errors.
WebBundle\Entity\ListPrice No errors.
WebBundle\Entity\LocaleHtmlEntity No errors.
WebBundle\Entity\ListEmail No errors.
WebBundle\Entity\StaticPageEntity No errors.
WebBundle\Entity\TransEntity No errors.
FlexApp\Entity\Exhibition\ExhEntity No errors.
FlexApp\Entity\Exhibition\ExhCollectionEntity No errors.
WebBundle\Entity\LocaleMetaEntity No errors.
WebBundle\Entity\BuyOrderArticle No errors.
WebBundle\Entity\BuyOrder No errors.
WebBundle\Entity\Visit No errors.
WebBundle\Entity\OrderAddress No errors.
WebBundle\Entity\OrderHistory No errors.
WebBundle\Entity\OrderPayment No errors.
WebBundle\Entity\CurrencyRate No errors.
WebBundle\Entity\ListVat No errors.
WebBundle\Entity\WarehouseEntity No errors.
WebBundle\Entity\BuyOrderManager No errors.
FlexApp\Entity\InterviewEntity No errors.

oneC entity manager

No loaded entities.

logs entity manager

No loaded entities.