https://dev5.tile.expert/en-us/tile/del-conca/frammenti/f/stonalizzazione-v2

301 Redirect from
@app_collection (8c589b)
Method
GET
HTTP Status
301
IP
216.73.216.124
Profiled on
Token
d682f5

Query Metrics

7 Database Queries
6 Different statements
129.22 ms Query time
0 Invalid entities

Queries

Group similar statements

default connection

#▲ Time Info
1 0.50 ms 
SELECT c0_.`id` AS id_0, c0_.`unid` AS unid_1, c0_.`code` AS code_2, c0_.`name` AS name_3, c0_.`alternate_name` AS alternate_name_4, c0_.`name_full` AS name_full_5, c0_.`url` AS url_6, c0_.`status` AS status_7, c0_.`type` AS type_8, c0_.`typeSet` AS typeSet_9, c0_.`pc_as_m` AS pc_as_m_10, c0_.`publish_date` AS publish_date_11, c0_.`update_date` AS update_date_12, c0_.`archive` AS archive_13, c0_.`pr_min_euro` AS pr_min_euro_14, c0_.`pr_min_euro_de` AS pr_min_euro_de_15, c0_.`pr_min_euro_at` AS pr_min_euro_at_16, c0_.`pr_min_euro_fi` AS pr_min_euro_fi_17, c0_.`pr_min_euro_fr` AS pr_min_euro_fr_18, c0_.`pr_min_euro_it` AS pr_min_euro_it_19, c0_.`pr_min_euro_be` AS pr_min_euro_be_20, c0_.`pr_min_euro_ie` AS pr_min_euro_ie_21, c0_.`pr_min_euro_nl` AS pr_min_euro_nl_22, c0_.`pr_min_euro_es` AS pr_min_euro_es_23, c0_.`pr_min_rub` AS pr_min_rub_24, c0_.`pr_min_rue` AS pr_min_rue_25, c0_.`pr_min_gbp` AS pr_min_gbp_26, c0_.`pr_min_gbe` AS pr_min_gbe_27, c0_.`pr_min_usd` AS pr_min_usd_28, c0_.`pr_min_use` AS pr_min_use_29, c0_.`pr_min_f_usd` AS pr_min_f_usd_30, c0_.`pr_min_f_use` AS pr_min_f_use_31, c0_.`pr_min_chf` AS pr_min_chf_32, c0_.`pr_min_che` AS pr_min_che_33, c0_.`pr_min_sek` AS pr_min_sek_34, c0_.`pr_min_see` AS pr_min_see_35, c0_.`pr_min_dkk` AS pr_min_dkk_36, c0_.`pr_min_dke` AS pr_min_dke_37, c0_.`pr_min_nok` AS pr_min_nok_38, c0_.`pr_min_noe` AS pr_min_noe_39, c0_.`pr_min_pln` AS pr_min_pln_40, c0_.`pr_min_ple` AS pr_min_ple_41, c0_.`pr_min_cad` AS pr_min_cad_42, c0_.`pr_min_cae` AS pr_min_cae_43, c0_.`pr_min_f_cad` AS pr_min_f_cad_44, c0_.`pr_min_f_cae` AS pr_min_f_cae_45, c0_.`pr_min_ed` AS pr_min_ed_46, c0_.`important` AS important_47, c0_.`author` AS author_48, c0_.`author_id` AS author_id_49, c0_.`rating` AS rating_50, c0_.`header` AS header_51, c0_.`settings` AS settings_52, c0_.`fids` AS fids_53, c0_.`portal_unid` AS portal_unid_54, c0_.`accepted_at` AS accepted_at_55, c0_.`accept_state` AS accept_state_56, c0_.`description_edit` AS description_edit_57, c0_.`link_award` AS link_award_58, c0_.`awards` AS awards_59, c0_.`video` AS video_60, c0_.`stated_at` AS stated_at_61, c0_.`state` AS state_62, c0_.`description_state` AS description_state_63, c0_.`body_hide` AS body_hide_64, c0_.`release_year` AS release_year_65, c0_.`site` AS site_66, c0_.`show_main` AS show_main_67, c0_.`glue_url` AS glue_url_68, c0_.`accessible` AS accessible_69, c0_.`delivery_suspended` AS delivery_suspended_70, c0_.`process` AS process_71, c0_.`exhibition` AS exhibition_72, c0_.`test_access` AS test_access_73, c0_.`views` AS views_74, c0_.`comment_unid` AS comment_unid_75, c0_.`accesible_at` AS accesible_at_76, c0_.`created_at` AS created_at_77, c0_.`updated_at` AS updated_at_78, f1_.`id` AS id_79, f1_.`unid` AS unid_80, f1_.`name` AS name_81, f1_.`name_inv` AS name_inv_82, f1_.`url` AS url_83, f1_.`alternate_name` AS alternate_name_84, f1_.`description_ru` AS description_ru_85, f1_.`description_en` AS description_en_86, f1_.`description_it` AS description_it_87, f1_.`description_es` AS description_es_88, f1_.`description_fr` AS description_fr_89, f1_.`description_de` AS description_de_90, f1_.`description_pt` AS description_pt_91, f1_.`description_pl` AS description_pl_92, f1_.`description_nl` AS description_nl_93, f1_.`description_fi` AS description_fi_94, f1_.`description_ua` AS description_ua_95, f1_.`description_sv` AS description_sv_96, f1_.`description_no` AS description_no_97, f1_.`description_da` AS description_da_98, f1_.`description_zh` AS description_zh_99, f1_.`delivery_time` AS delivery_time_100, f1_.`not_regular` AS not_regular_101, f1_.`suspended` AS suspended_102, f1_.`status` AS status_103, f1_.`type` AS type_104, f1_.`discount` AS discount_105, f1_.`discount_date_start` AS discount_date_start_106, f1_.`discount_date_end` AS discount_date_end_107, f1_.`transcription` AS transcription_108, f1_.`cost_delivery` AS cost_delivery_109, f1_.`create_date` AS create_date_110, f1_.`is_accepted` AS is_accepted_111, f1_.`accepted_at` AS accepted_at_112, f1_.`accept_state` AS accept_state_113, f1_.`description_edit` AS description_edit_114, f1_.`stated_at` AS stated_at_115, f1_.`state` AS state_116, f1_.`description_state` AS description_state_117, f1_.`video` AS video_118, f1_.`parser_address` AS parser_address_119, f1_.`accessible` AS accessible_120, f1_.`sound` AS sound_121, f1_.`test_access` AS test_access_122, f1_.`total_ideas` AS total_ideas_123, f1_.`votes_submit` AS votes_submit_124, f1_.`votes_stars` AS votes_stars_125, f1_.`brand_link` AS brand_link_126, f1_.`brand_logo` AS brand_logo_127, f1_.`no_send_portl_message` AS no_send_portl_message_128, l2_.`id` AS id_129, l2_.`code` AS code_130, l2_.`locale` AS locale_131, l2_.`phone_code` AS phone_code_132, l2_.`phone_mask` AS phone_mask_133, l2_.`min_valid_phone_numbers` AS min_valid_phone_numbers_134, l2_.`zip_code_mask` AS zip_code_mask_135, l2_.`percent_vat` AS percent_vat_136, l2_.`name` AS name_137, l2_.`name_en` AS name_en_138, l2_.`alias` AS alias_139, l2_.`sort` AS sort_140, l2_.`count` AS count_141, l2_.`hide` AS hide_142, l2_.`important` AS important_143, l2_.`pay_pal_percent` AS pay_pal_percent_144, l2_.`pay_pal_percent_own` AS pay_pal_percent_own_145, l2_.`vat` AS vat_146, l2_.`pv_type` AS pv_type_147, l2_.`capital_timezone_diff` AS capital_timezone_diff_148, l2_.`capital` AS capital_149, l2_.`free_sample_delivery` AS free_sample_delivery_150, l2_.`units` AS units_151, l3_.`id` AS id_152, l3_.`source` AS source_153, l3_.`ru` AS ru_154, l3_.`en` AS en_155, l3_.`it` AS it_156, l3_.`es` AS es_157, l3_.`fr` AS fr_158, l3_.`de` AS de_159, l3_.`pl` AS pl_160, l3_.`pt` AS pt_161, l3_.`nl` AS nl_162, l3_.`fi` AS fi_163, l3_.`ua` AS ua_164, l3_.`sv` AS sv_165, l3_.`no` AS no_166, l3_.`da` AS da_167, l3_.`cn` AS cn_168, l3_.`zh` AS zh_169, l3_.`created_at` AS created_at_170, l3_.`updated_at` AS updated_at_171, l4_.`id` AS id_172, l4_.`source` AS source_173, l4_.`ru` AS ru_174, l4_.`en` AS en_175, l4_.`it` AS it_176, l4_.`es` AS es_177, l4_.`fr` AS fr_178, l4_.`de` AS de_179, l4_.`pl` AS pl_180, l4_.`pt` AS pt_181, l4_.`nl` AS nl_182, l4_.`fi` AS fi_183, l4_.`ua` AS ua_184, l4_.`sv` AS sv_185, l4_.`no` AS no_186, l4_.`da` AS da_187, l4_.`cn` AS cn_188, l4_.`zh` AS zh_189, l4_.`created_at` AS created_at_190, l4_.`updated_at` AS updated_at_191, l5_.`id` AS id_192, l5_.`source` AS source_193, l5_.`ru` AS ru_194, l5_.`en` AS en_195, l5_.`it` AS it_196, l5_.`es` AS es_197, l5_.`fr` AS fr_198, l5_.`de` AS de_199, l5_.`pl` AS pl_200, l5_.`pt` AS pt_201, l5_.`nl` AS nl_202, l5_.`fi` AS fi_203, l5_.`ua` AS ua_204, l5_.`sv` AS sv_205, l5_.`no` AS no_206, l5_.`da` AS da_207, l5_.`cn` AS cn_208, l5_.`zh` AS zh_209, l5_.`created_at` AS created_at_210, l5_.`updated_at` AS updated_at_211 FROM `collection` c0_ LEFT JOIN `factory` f1_ ON c0_.factory = f1_.id LEFT JOIN `list_country` l2_ ON f1_.country = l2_.id LEFT JOIN `locale_html` l3_ ON c0_.id = l3_.collection_body_id LEFT JOIN `locale_meta` l4_ ON c0_.id = l4_.collection_keywords_id LEFT JOIN `locale_meta` l5_ ON c0_.id = l5_.collection_description_id WHERE f1_.`status` > ? AND f1_.`url` = ? AND c0_.`url` = ?
Parameters: 
[
  0
  "del-conca"
  "frammenti"
]
View formatted query    View runnable query    Explain query
2 0.27 ms 
SELECT f0_.`id` AS id_0 FROM `geo_country` g1_ LEFT JOIN factory_hide_countries f2_ ON g1_.id = f2_.country_id LEFT JOIN `factory` f0_ ON f0_.id = f2_.factory_id WHERE g1_.`code` = ?
Parameters: 
[
  "us"
]
View formatted query    View runnable query    Explain query
3 0.60 ms 
UPDATE `collection` SET `views` = `views` + '1' WHERE `id` = :id
Parameters: 
[
  "id" => 3248186
]
View formatted query    View runnable query    Explain query
4 0.49 ms 
SELECT
                i.id AS iId,
                i.url AS iUrl,
                i.name AS iName,
                i.alt AS iAlt,
                i.file AS iFile,
                i.status AS iStatus,
                i.file_size_x AS iFileSizeX,
                i.file_size_y AS iFileSizeY,
                i.file_size_z_x AS iFileSizeZX,
                i.file_size_z_y AS iFileSizeZY,
                i.file_size_hd_x AS iFileSizeHdX,
                i.file_size_hd_y AS iFileSizeHdY,
                i.file_size_shd_x AS iFileSizeShdX,
                i.file_size_shd_y AS iFileSizeShdY,
                i.file_size4k_x AS iFileSize4kX,
                i.file_size4k_y AS iFileSize4kY,
                c.id AS cId,
                c.url AS cUrl,
                c.status AS cStatus,
                c.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 = 3248186 AND i.status = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query
5 125.74 ms 
SELECT f0_.`id` AS id_0, f0_.`name` AS name_1, f0_.`alt_name` AS alt_name_2, f0_.`left_menu` AS left_menu_3, f0_.`sort` AS sort_4, f0_.`important` AS important_5, f0_.`old_command` AS old_command_6, f0_.`old_id` AS old_id_7, f0_.`sub_key` AS sub_key_8, f0_.`parent_key` AS parent_key_9, f0_.`rank` AS rank_10, f0_.`icon` AS icon_11, f0_.`icon_url` AS icon_url_12, f0_.`logo` AS logo_13, f0_.`logo_url` AS logo_url_14, f0_.`created_at` AS created_at_15, f0_.`updated_at` AS updated_at_16, l1_.`id` AS id_17, l1_.`source` AS source_18, l1_.`ru` AS ru_19, l1_.`en` AS en_20, l1_.`it` AS it_21, l1_.`es` AS es_22, l1_.`fr` AS fr_23, l1_.`de` AS de_24, l1_.`pl` AS pl_25, l1_.`pt` AS pt_26, l1_.`nl` AS nl_27, l1_.`fi` AS fi_28, l1_.`ua` AS ua_29, l1_.`sv` AS sv_30, l1_.`no` AS no_31, l1_.`da` AS da_32, l1_.`cn` AS cn_33, l1_.`zh` AS zh_34, l1_.`created_at` AS created_at_35, l1_.`updated_at` AS updated_at_36, f2_.`id` AS id_37, f2_.`name` AS name_38, f2_.`alt_name` AS alt_name_39, f2_.`name_single_source` AS name_single_source_40, f2_.`name_single_ru` AS name_single_ru_41, f2_.`name_single_en` AS name_single_en_42, f2_.`name_single_it` AS name_single_it_43, f2_.`name_single_es` AS name_single_es_44, f2_.`name_single_fr` AS name_single_fr_45, f2_.`name_single_de` AS name_single_de_46, f2_.`name_single_pl` AS name_single_pl_47, f2_.`name_single_pt` AS name_single_pt_48, f2_.`name_single_nl` AS name_single_nl_49, f2_.`name_single_fi` AS name_single_fi_50, f2_.`name_single_ua` AS name_single_ua_51, f2_.`name_single_sv` AS name_single_sv_52, f2_.`name_single_no` AS name_single_no_53, f2_.`name_single_da` AS name_single_da_54, f2_.`name_single_usa` AS name_single_usa_55, f2_.`name_single_cn` AS name_single_cn_56, f2_.`name_single_zh` AS name_single_zh_57, f2_.`name_many_source` AS name_many_source_58, f2_.`name_many_ru` AS name_many_ru_59, f2_.`name_many_en` AS name_many_en_60, f2_.`name_many_it` AS name_many_it_61, f2_.`name_many_es` AS name_many_es_62, f2_.`name_many_fr` AS name_many_fr_63, f2_.`name_many_de` AS name_many_de_64, f2_.`name_many_pl` AS name_many_pl_65, f2_.`name_many_pt` AS name_many_pt_66, f2_.`name_many_nl` AS name_many_nl_67, f2_.`name_many_fi` AS name_many_fi_68, f2_.`name_many_ua` AS name_many_ua_69, f2_.`name_many_sv` AS name_many_sv_70, f2_.`name_many_no` AS name_many_no_71, f2_.`name_many_da` AS name_many_da_72, f2_.`name_many_usa` AS name_many_usa_73, f2_.`name_many_cn` AS name_many_cn_74, f2_.`name_many_zh` AS name_many_zh_75, f2_.`name_menu_source` AS name_menu_source_76, f2_.`name_menu_ru` AS name_menu_ru_77, f2_.`name_menu_en` AS name_menu_en_78, f2_.`name_menu_it` AS name_menu_it_79, f2_.`name_menu_es` AS name_menu_es_80, f2_.`name_menu_fr` AS name_menu_fr_81, f2_.`name_menu_de` AS name_menu_de_82, f2_.`name_menu_pl` AS name_menu_pl_83, f2_.`name_menu_pt` AS name_menu_pt_84, f2_.`name_menu_nl` AS name_menu_nl_85, f2_.`name_menu_fi` AS name_menu_fi_86, f2_.`name_menu_ua` AS name_menu_ua_87, f2_.`name_menu_sv` AS name_menu_sv_88, f2_.`name_menu_no` AS name_menu_no_89, f2_.`name_menu_da` AS name_menu_da_90, f2_.`name_menu_usa` AS name_menu_usa_91, f2_.`name_menu_cn` AS name_menu_cn_92, f2_.`name_menu_zh` AS name_menu_zh_93, f2_.`description_source` AS description_source_94, f2_.`description_ru` AS description_ru_95, f2_.`description_en` AS description_en_96, f2_.`description_it` AS description_it_97, f2_.`description_es` AS description_es_98, f2_.`description_fr` AS description_fr_99, f2_.`description_de` AS description_de_100, f2_.`description_pl` AS description_pl_101, f2_.`description_pt` AS description_pt_102, f2_.`description_nl` AS description_nl_103, f2_.`description_fi` AS description_fi_104, f2_.`description_ua` AS description_ua_105, f2_.`description_sv` AS description_sv_106, f2_.`description_no` AS description_no_107, f2_.`description_da` AS description_da_108, f2_.`description_usa` AS description_usa_109, f2_.`description_cn` AS description_cn_110, f2_.`description_zh` AS description_zh_111, f2_.`keywords_source` AS keywords_source_112, f2_.`keywords_ru` AS keywords_ru_113, f2_.`keywords_en` AS keywords_en_114, f2_.`keywords_it` AS keywords_it_115, f2_.`keywords_es` AS keywords_es_116, f2_.`keywords_fr` AS keywords_fr_117, f2_.`keywords_de` AS keywords_de_118, f2_.`keywords_pl` AS keywords_pl_119, f2_.`keywords_pt` AS keywords_pt_120, f2_.`keywords_nl` AS keywords_nl_121, f2_.`keywords_fi` AS keywords_fi_122, f2_.`keywords_ua` AS keywords_ua_123, f2_.`keywords_sv` AS keywords_sv_124, f2_.`keywords_no` AS keywords_no_125, f2_.`keywords_da` AS keywords_da_126, f2_.`keywords_usa` AS keywords_usa_127, f2_.`keywords_cn` AS keywords_cn_128, f2_.`keywords_zh` AS keywords_zh_129, f2_.`html_source` AS html_source_130, f2_.`html_ru` AS html_ru_131, f2_.`html_en` AS html_en_132, f2_.`html_it` AS html_it_133, f2_.`html_es` AS html_es_134, f2_.`html_fr` AS html_fr_135, f2_.`html_de` AS html_de_136, f2_.`html_pl` AS html_pl_137, f2_.`html_pt` AS html_pt_138, f2_.`html_nl` AS html_nl_139, f2_.`html_fi` AS html_fi_140, f2_.`html_ua` AS html_ua_141, f2_.`html_sv` AS html_sv_142, f2_.`html_no` AS html_no_143, f2_.`html_da` AS html_da_144, f2_.`html_usa` AS html_usa_145, f2_.`html_cn` AS html_cn_146, f2_.`html_zh` AS html_zh_147, f3_.`id` AS id_148, f3_.`alt_name` AS alt_name_149, f3_.`count` AS count_150, f3_.`hide` AS hide_151, f3_.`hide_all` AS hide_all_152, f3_.`is_enable` AS is_enable_153, f3_.`show_footer` AS show_footer_154, f3_.`show_menu` AS show_menu_155, f3_.`show_menu_advanced` AS show_menu_advanced_156, f3_.`hex_code` AS hex_code_157, f3_.`code` AS code_158, f3_.`phone_code` AS phone_code_159, f3_.`link` AS link_160, f4_.`id` AS id_161, f4_.`unid` AS unid_162, f4_.`name` AS name_163, f4_.`name_inv` AS name_inv_164, f4_.`url` AS url_165, f4_.`alternate_name` AS alternate_name_166, f4_.`description_ru` AS description_ru_167, f4_.`description_en` AS description_en_168, f4_.`description_it` AS description_it_169, f4_.`description_es` AS description_es_170, f4_.`description_fr` AS description_fr_171, f4_.`description_de` AS description_de_172, f4_.`description_pt` AS description_pt_173, f4_.`description_pl` AS description_pl_174, f4_.`description_nl` AS description_nl_175, f4_.`description_fi` AS description_fi_176, f4_.`description_ua` AS description_ua_177, f4_.`description_sv` AS description_sv_178, f4_.`description_no` AS description_no_179, f4_.`description_da` AS description_da_180, f4_.`description_zh` AS description_zh_181, f4_.`delivery_time` AS delivery_time_182, f4_.`not_regular` AS not_regular_183, f4_.`suspended` AS suspended_184, f4_.`status` AS status_185, f4_.`type` AS type_186, f4_.`discount` AS discount_187, f4_.`discount_date_start` AS discount_date_start_188, f4_.`discount_date_end` AS discount_date_end_189, f4_.`transcription` AS transcription_190, f4_.`cost_delivery` AS cost_delivery_191, f4_.`create_date` AS create_date_192, f4_.`is_accepted` AS is_accepted_193, f4_.`accepted_at` AS accepted_at_194, f4_.`accept_state` AS accept_state_195, f4_.`description_edit` AS description_edit_196, f4_.`stated_at` AS stated_at_197, f4_.`state` AS state_198, f4_.`description_state` AS description_state_199, f4_.`video` AS video_200, f4_.`parser_address` AS parser_address_201, f4_.`accessible` AS accessible_202, f4_.`sound` AS sound_203, f4_.`test_access` AS test_access_204, f4_.`total_ideas` AS total_ideas_205, f4_.`votes_submit` AS votes_submit_206, f4_.`votes_stars` AS votes_stars_207, f4_.`brand_link` AS brand_link_208, f4_.`brand_logo` AS brand_logo_209, f4_.`no_send_portl_message` AS no_send_portl_message_210, f5_.`id` AS id_211, f5_.`alt_name` AS alt_name_212, f5_.`left_menu` AS left_menu_213, f5_.`sort` AS sort_214, f5_.`is_enable` AS is_enable_215, f5_.`show_footer` AS show_footer_216, f5_.`show_menu` AS show_menu_217, f5_.`show_menu_advanced` AS show_menu_advanced_218, a6_.`id` AS id_219, a6_.`code` AS code_220, a6_.`name` AS name_221, a6_.`alternate_name` AS alternate_name_222, a6_.`urla` AS urla_223, a6_.`file` AS file_224, a6_.`size_x` AS size_x_225, a6_.`size_y` AS size_y_226, a6_.`size_gb_x` AS size_gb_x_227, a6_.`size_gb_y` AS size_gb_y_228, a6_.`size_tessera` AS size_tessera_229, a6_.`file_size1_x` AS file_size1_x_230, a6_.`file_size1_y` AS file_size1_y_231, a6_.`file_size2_x` AS file_size2_x_232, a6_.`file_size2_y` AS file_size2_y_233, a6_.`file_size3_x` AS file_size3_x_234, a6_.`file_size3_y` AS file_size3_y_235, a6_.`file_size500_x` AS file_size500_x_236, a6_.`file_size500_y` AS file_size500_y_237, a6_.`file_size740_x` AS file_size740_x_238, a6_.`file_size740_y` AS file_size740_y_239, a6_.`file_size8_x` AS file_size8_x_240, a6_.`file_size8_y` AS file_size8_y_241, a6_.`pallet` AS pallet_242, a6_.`pallet_ft` AS pallet_ft_243, a6_.`type_constraint` AS type_constraint_244, a6_.`multiple_pallet` AS multiple_pallet_245, a6_.`min_order` AS min_order_246, a6_.`price_euro` AS price_euro_247, a6_.`price_mq_euro` AS price_mq_euro_248, a6_.`price_euro_de` AS price_euro_de_249, a6_.`price_mq_euro_de` AS price_mq_euro_de_250, a6_.`price_euro_at` AS price_euro_at_251, a6_.`price_mq_euro_at` AS price_mq_euro_at_252, a6_.`price_euro_fi` AS price_euro_fi_253, a6_.`price_mq_euro_fi` AS price_mq_euro_fi_254, a6_.`price_euro_fr` AS price_euro_fr_255, a6_.`price_mq_euro_fr` AS price_mq_euro_fr_256, a6_.`price_euro_it` AS price_euro_it_257, a6_.`price_mq_euro_it` AS price_mq_euro_it_258, a6_.`price_euro_be` AS price_euro_be_259, a6_.`price_mq_euro_be` AS price_mq_euro_be_260, a6_.`price_euro_ie` AS price_euro_ie_261, a6_.`price_mq_euro_ie` AS price_mq_euro_ie_262, a6_.`price_euro_nl` AS price_euro_nl_263, a6_.`price_mq_euro_nl` AS price_mq_euro_nl_264, a6_.`price_euro_es` AS price_euro_es_265, a6_.`price_mq_euro_es` AS price_mq_euro_es_266, a6_.`price_rub` AS price_rub_267, a6_.`price_rue` AS price_rue_268, a6_.`price_mq_rub` AS price_mq_rub_269, a6_.`price_mq_rue` AS price_mq_rue_270, a6_.`price_gbp` AS price_gbp_271, a6_.`price_gbe` AS price_gbe_272, a6_.`price_mq_gbp` AS price_mq_gbp_273, a6_.`price_mq_gbe` AS price_mq_gbe_274, a6_.`price_usd` AS price_usd_275, a6_.`price_use` AS price_use_276, a6_.`price_fq_usd` AS price_fq_usd_277, a6_.`price_fq_use` AS price_fq_use_278, a6_.`price_mq_usd` AS price_mq_usd_279, a6_.`price_mq_use` AS price_mq_use_280, a6_.`price_chf` AS price_chf_281, a6_.`price_che` AS price_che_282, a6_.`price_mq_chf` AS price_mq_chf_283, a6_.`price_mq_che` AS price_mq_che_284, a6_.`price_sek` AS price_sek_285, a6_.`price_see` AS price_see_286, a6_.`price_mq_sek` AS price_mq_sek_287, a6_.`price_mq_see` AS price_mq_see_288, a6_.`price_dkk` AS price_dkk_289, a6_.`price_dke` AS price_dke_290, a6_.`price_mq_dkk` AS price_mq_dkk_291, a6_.`price_mq_dke` AS price_mq_dke_292, a6_.`price_nok` AS price_nok_293, a6_.`price_noe` AS price_noe_294, a6_.`price_mq_nok` AS price_mq_nok_295, a6_.`price_mq_noe` AS price_mq_noe_296, a6_.`price_pln` AS price_pln_297, a6_.`price_ple` AS price_ple_298, a6_.`price_mq_pln` AS price_mq_pln_299, a6_.`price_mq_ple` AS price_mq_ple_300, a6_.`price_cad` AS price_cad_301, a6_.`price_cae` AS price_cae_302, a6_.`price_fq_cad` AS price_fq_cad_303, a6_.`price_fq_cae` AS price_fq_cae_304, a6_.`price_mq_cad` AS price_mq_cad_305, a6_.`price_mq_cae` AS price_mq_cae_306, a6_.`thick` AS thick_307, a6_.`weight` AS weight_308, a6_.`packaging_count` AS packaging_count_309, a6_.`packaging_count_ft` AS packaging_count_ft_310, a6_.`packaging_count_pc` AS packaging_count_pc_311, a6_.`m2one_ps` AS m2one_ps_312, a6_.`description_ru` AS description_ru_313, a6_.`description_en` AS description_en_314, a6_.`description_it` AS description_it_315, a6_.`description_es` AS description_es_316, a6_.`description_fr` AS description_fr_317, a6_.`description_de` AS description_de_318, a6_.`description_pt` AS description_pt_319, a6_.`description_pl` AS description_pl_320, a6_.`description_nl` AS description_nl_321, a6_.`description_fi` AS description_fi_322, a6_.`description_ua` AS description_ua_323, a6_.`description_sv` AS description_sv_324, a6_.`description_no` AS description_no_325, a6_.`description_da` AS description_da_326, a6_.`description_cn` AS description_cn_327, a6_.`scheme` AS scheme_328, a6_.`sale_date` AS sale_date_329, a6_.`thin_granite` AS thin_granite_330, a6_.`glazed_granite` AS glazed_granite_331, a6_.`pei` AS pei_332, a6_.`is_grouped` AS is_grouped_333, a6_.`is_rotate` AS is_rotate_334, a6_.`price_prx` AS price_prx_335, a6_.`background_white` AS background_white_336, a6_.`border_grey` AS border_grey_337, a6_.`is_edit` AS is_edit_338, a6_.`edited_at` AS edited_at_339, a6_.`comment` AS comment_340, a6_.`file_edit` AS file_edit_341, a6_.`image_setting` AS image_setting_342, a6_.`file_w` AS file_w_343, a6_.`file_h` AS file_h_344, a6_.`file_w4000` AS file_w4000_345, a6_.`file_h4000` AS file_h4000_346, a6_.`size_z` AS size_z_347, a6_.`size_gb_z` AS size_gb_z_348, a6_.`repeat_number` AS repeat_number_349, a6_.`size_big` AS size_big_350, a6_.`delivery_suspended` AS delivery_suspended_351, a6_.`poddon_x` AS poddon_x_352, a6_.`poddon_y` AS poddon_y_353, a6_.`poddon_z` AS poddon_z_354, a6_.`module` AS module_355, a6_.`tessera_size_x` AS tessera_size_x_356, a6_.`tessera_size_y` AS tessera_size_y_357, a6_.`tessera_size_z` AS tessera_size_z_358, a6_.`poddon_count` AS poddon_count_359, a6_.`poddon_weight` AS poddon_weight_360, a6_.`added_to_cart` AS added_to_cart_361, a6_.`sold_out` AS sold_out_362, a6_.`sold_out_vol` AS sold_out_vol_363, a6_.`swimming_pool` AS swimming_pool_364, a6_.`can_select_substrate` AS can_select_substrate_365, a6_.`designer` AS designer_366, a6_.`designer_id` AS designer_id_367, a6_.`mosaic_effect` AS mosaic_effect_368, a6_.`not_sample` AS not_sample_369, a6_.`express_sample` AS express_sample_370, a6_.`description_edit` AS description_edit_371, a6_.`comment_scheme_image` AS comment_scheme_image_372, a6_.`variant_image` AS variant_image_373, a6_.`square` AS square_374, a6_.`fix_big_size` AS fix_big_size_375, a6_.`overflow_sink` AS overflow_sink_376, a6_.`drain_size_sink` AS drain_size_sink_377, a6_.`faucet_hole_sink` AS faucet_hole_sink_378, a6_.`rotate` AS rotate_379, a6_.`dyed_in_mass` AS dyed_in_mass_380, a6_.`durability_class` AS durability_class_381, a6_.`is_comment_ru` AS is_comment_ru_382, a6_.`file_rotation` AS file_rotation_383, a6_.`created_at` AS created_at_384, a6_.`updated_at` AS updated_at_385, l7_.`id` AS id_386, l7_.`source` AS source_387, l7_.`ru` AS ru_388, l7_.`en` AS en_389, l7_.`it` AS it_390, l7_.`es` AS es_391, l7_.`fr` AS fr_392, l7_.`de` AS de_393, l7_.`pl` AS pl_394, l7_.`pt` AS pt_395, l7_.`nl` AS nl_396, l7_.`fi` AS fi_397, l7_.`ua` AS ua_398, l7_.`sv` AS sv_399, l7_.`no` AS no_400, l7_.`da` AS da_401, l7_.`cn` AS cn_402, l7_.`zh` AS zh_403, l7_.`created_at` AS created_at_404, l7_.`updated_at` AS updated_at_405, f8_.`id` AS id_406, f8_.`name` AS name_407, f8_.`alt_name` AS alt_name_408, f8_.`left_menu` AS left_menu_409, f8_.`sort` AS sort_410, f8_.`important` AS important_411, f8_.`old_command` AS old_command_412, f8_.`old_id` AS old_id_413, f8_.`sub_key` AS sub_key_414, f8_.`parent_key` AS parent_key_415, f8_.`rank` AS rank_416, f8_.`icon` AS icon_417, f8_.`icon_url` AS icon_url_418, f8_.`logo` AS logo_419, f8_.`logo_url` AS logo_url_420, f8_.`created_at` AS created_at_421, f8_.`updated_at` AS updated_at_422, l9_.`id` AS id_423, l9_.`source` AS source_424, l9_.`ru` AS ru_425, l9_.`en` AS en_426, l9_.`it` AS it_427, l9_.`es` AS es_428, l9_.`fr` AS fr_429, l9_.`de` AS de_430, l9_.`pl` AS pl_431, l9_.`pt` AS pt_432, l9_.`nl` AS nl_433, l9_.`fi` AS fi_434, l9_.`ua` AS ua_435, l9_.`sv` AS sv_436, l9_.`no` AS no_437, l9_.`da` AS da_438, l9_.`usa` AS usa_439, l9_.`cn` AS cn_440, l9_.`zh` AS zh_441, l9_.`created_at` AS created_at_442, l9_.`updated_at` AS updated_at_443, l10_.`id` AS id_444, l10_.`source` AS source_445, l10_.`ru` AS ru_446, l10_.`en` AS en_447, l10_.`it` AS it_448, l10_.`es` AS es_449, l10_.`fr` AS fr_450, l10_.`de` AS de_451, l10_.`pl` AS pl_452, l10_.`pt` AS pt_453, l10_.`nl` AS nl_454, l10_.`fi` AS fi_455, l10_.`ua` AS ua_456, l10_.`sv` AS sv_457, l10_.`no` AS no_458, l10_.`da` AS da_459, l10_.`usa` AS usa_460, l10_.`cn` AS cn_461, l10_.`zh` AS zh_462, l10_.`created_at` AS created_at_463, l10_.`updated_at` AS updated_at_464, f0_.page_id AS page_id_465, f0_.param_id AS param_id_466, f0_.group_id AS group_id_467, f0_.brand AS brand_468, f0_.country_id AS country_id_469, f0_.parent_id AS parent_id_470, l1_.publication_id AS publication_id_471, l1_.filter_id AS filter_id_472, l1_.exh_id AS exh_id_473, f4_.user_id AS user_id_474, f4_.country AS country_475, f4_.filter AS filter_476, f5_.parent_id AS parent_id_477, a6_.collection AS collection_478, a6_.newCollection AS newCollection_479, a6_.type AS type_480, a6_.measure AS measure_481, a6_.surface AS surface_482, a6_.pr_status AS pr_status_483, a6_.category_price AS category_price_484, a6_.edge_type AS edge_type_485, a6_.using AS using_486, a6_.shape AS shape_487, a6_.material AS material_488, a6_.delivery AS delivery_489, a6_.sliding AS sliding_490, a6_.off_shade AS off_shade_491, a6_.style AS style_492, a6_.repeat_draw AS repeat_draw_493, a6_.measurement_size AS measurement_size_494, a6_.installation_type AS installation_type_495, a6_.meth_laying AS meth_laying_496, a6_.draw AS draw_497, l7_.blog_show_id AS blog_show_id_498, l7_.blog_hide_single_id AS blog_hide_single_id_499, l7_.static_page_status_show_id AS static_page_status_show_id_500, l7_.static_page_comment_show_id AS static_page_comment_show_id_501, l7_.filter_html_show_id AS filter_html_show_id_502, l7_.exh_show_id AS exh_show_id_503, l7_.exh_hide_single_id AS exh_hide_single_id_504, f8_.page_id AS page_id_505, f8_.param_id AS param_id_506, f8_.group_id AS group_id_507, f8_.brand AS brand_508, f8_.country_id AS country_id_509, f8_.parent_id AS parent_id_510, l9_.static_page_unid_id AS static_page_unid_id_511, l9_.vacancy_question_link_id AS vacancy_question_link_id_512, l9_.filter_name_for_meta_descr_id AS filter_name_for_meta_descr_id_513, l9_.filter_name_for_meta_title_id AS filter_name_for_meta_title_id_514, l9_.exh_image_alt AS exh_image_alt_515, l9_.filter_group_name AS filter_group_name_516, l9_.filter_tooltip AS filter_tooltip_517, l9_.calendar_text AS calendar_text_518, l9_.filter_key_adwords AS filter_key_adwords_519, l9_.filter_title_adwords AS filter_title_adwords_520, l9_.filter_key_adwords_combi_first AS filter_key_adwords_combi_first_521, l9_.filter_title_adwords_combi_first AS filter_title_adwords_combi_first_522, l9_.filter_key_adwords_combi_other AS filter_key_adwords_combi_other_523, l9_.filter_title_adwords_combi_other AS filter_title_adwords_combi_other_524, l9_.filter_key_adwords_multi_id AS filter_key_adwords_multi_id_525, l9_.filter_title_adwords_multi_id AS filter_title_adwords_multi_id_526, l9_.filter_key_adwords_combi_multi_id AS filter_key_adwords_combi_multi_id_527, l9_.filter_title_adwords_combi_multi_id AS filter_title_adwords_combi_multi_id_528, l10_.static_page_unid_id AS static_page_unid_id_529, l10_.vacancy_question_link_id AS vacancy_question_link_id_530, l10_.filter_name_for_meta_descr_id AS filter_name_for_meta_descr_id_531, l10_.filter_name_for_meta_title_id AS filter_name_for_meta_title_id_532, l10_.exh_image_alt AS exh_image_alt_533, l10_.filter_group_name AS filter_group_name_534, l10_.filter_tooltip AS filter_tooltip_535, l10_.calendar_text AS calendar_text_536, l10_.filter_key_adwords AS filter_key_adwords_537, l10_.filter_title_adwords AS filter_title_adwords_538, l10_.filter_key_adwords_combi_first AS filter_key_adwords_combi_first_539, l10_.filter_title_adwords_combi_first AS filter_title_adwords_combi_first_540, l10_.filter_key_adwords_combi_other AS filter_key_adwords_combi_other_541, l10_.filter_title_adwords_combi_other AS filter_title_adwords_combi_other_542, l10_.filter_key_adwords_multi_id AS filter_key_adwords_multi_id_543, l10_.filter_title_adwords_multi_id AS filter_title_adwords_multi_id_544, l10_.filter_key_adwords_combi_multi_id AS filter_key_adwords_combi_multi_id_545, l10_.filter_title_adwords_combi_multi_id AS filter_title_adwords_combi_multi_id_546 FROM `filters` f0_ LEFT JOIN `locale_url` l1_ ON f0_.id = l1_.filter_id LEFT JOIN `filter_pages` f2_ ON f0_.page_id = f2_.id LEFT JOIN `filter_params` f3_ ON f0_.param_id = f3_.id LEFT JOIN `factory` f4_ ON f0_.brand = f4_.id LEFT JOIN `user` u11_ ON f4_.user_id = u11_.id LEFT JOIN `filter_groups` f5_ ON f0_.group_id = f5_.id LEFT JOIN article_filters a12_ ON f0_.id = a12_.filter_id LEFT JOIN `article` a6_ ON a6_.id = a12_.article_id LEFT JOIN `locale_bool` l7_ ON f0_.id = l7_.filter_html_show_id LEFT JOIN `filters` f8_ ON f0_.country_id = f8_.id LEFT JOIN `locale_text` l9_ ON f0_.id = l9_.filter_name_for_meta_title_id LEFT JOIN `locale_text` l10_ ON f0_.id = l10_.filter_name_for_meta_descr_id WHERE f0_.`alt_name` IN (?) ORDER BY f5_.`sort` ASC, f0_.`sort` ASC
Parameters: 
[
  [
    "release_year_2020"
  ]
]
View formatted query    View runnable query    Explain query
6 0.28 ms 
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
7 1.35 ms 
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

oneC connection

No database queries were performed.

logs connection

No database queries were performed.

Database Connections

Name Service
default doctrine.dbal.default_connection
oneC doctrine.dbal.oneC_connection
logs doctrine.dbal.logs_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager
oneC doctrine.orm.oneC_entity_manager
logs doctrine.orm.logs_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class Mapping errors
WebBundle\Entity\User No errors.
WebBundle\Entity\Article No errors.
WebBundle\Entity\BuyOrder No errors.
WebBundle\Entity\FilterEntity No errors.
WebBundle\Entity\Idea No errors.
WebBundle\Entity\Interior No errors.
WebBundle\Entity\Publication No errors.
WebBundle\Entity\Visit No errors.
WebBundle\Entity\LastUrlEntity No errors.
WebBundle\Entity\Collection No errors.
WebBundle\Entity\ProductReviewsCache No errors.
WebBundle\Entity\ReviewsCache No errors.
WebBundle\Entity\ListCountry No errors.
WebBundle\Entity\Factory No errors.
WebBundle\Entity\CollectionAlsoViewed No errors.
WebBundle\Entity\InteriorHistory No errors.
FlexApp\Entity\ChatB No errors.
FlexApp\Entity\ChatBMessage No errors.
FlexApp\Entity\BoolDBSetting No errors.
FlexApp\Entity\Widget No errors.
FlexApp\Entity\CountryAndLangSpecificDataEntity No errors.
FlexApp\Entity\ConsultantEntity No errors.
WebBundle\Entity\LocaleHtmlEntity No errors.
WebBundle\Entity\LocaleMetaEntity No errors.
FlexApp\Entity\GeoCountryEntity No errors.
WebBundle\Entity\ListApply No errors.
WebBundle\Entity\ListStyle No errors.
WebBundle\Entity\ListTexture No errors.
WebBundle\Entity\FilterPageEntity No errors.
WebBundle\Entity\FilterParamEntity No errors.
WebBundle\Entity\FilterGroupEntity No errors.

oneC entity manager

No loaded entities.

logs entity manager

No loaded entities.