https://dev5.tile.expert/fr/json/article/settings/215519914/1

Query Metrics

13 Database Queries
13 Different statements
4.16 ms Query time
0 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 1.84 ms
SELECT l0_.`alias` AS alias_0, l0_.`id` AS id_1, l1_.`name` AS name_2, l2_.`id` AS id_3, l2_.`alias` AS alias_4, a3_.`overflow_sink` AS overflow_sink_5, a3_.`drain_size_sink` AS drain_size_sink_6, l4_.`alias` AS alias_7, a3_.`faucet_hole_sink` AS faucet_hole_sink_8, l5_.`alias` AS alias_9, a3_.`swimming_pool` AS swimming_pool_10, l6_.`alias` AS alias_11, l6_.`id` AS id_12, l7_.`alias` AS alias_13, l7_.`id` AS id_14, a8_.`type_painting` AS type_painting_15, a3_.`dyed_in_mass` AS dyed_in_mass_16, a3_.`durability_class` AS durability_class_17, l9_.`alias` AS alias_18, l9_.`id` AS id_19, '' AS sclr_20, a3_.`mosaic_effect` AS mosaic_effect_21, a3_.`square` AS square_22, a3_.`size_tessera` AS size_tessera_23, a3_.`tessera_size_x` AS tessera_size_x_24, a3_.`tessera_size_y` AS tessera_size_y_25, a3_.`tessera_size_z` AS tessera_size_z_26, l10_.`alias` AS alias_27, l10_.`id` AS id_28, a3_.`thick` AS thick_29, '' AS sclr_30, '' AS sclr_31, '' AS sclr_32, '' AS sclr_33, a3_.`module` AS module_34, a3_.`repeat_number` AS repeat_number_35, a3_.`glazed_granite` AS glazed_granite_36, a3_.`thin_granite` AS thin_granite_37, l11_.`alias` AS alias_38, l12_.`id` AS id_39, l12_.`alias` AS alias_40, l13_.`id` AS id_41, l13_.`alias` AS alias_42, '' AS sclr_43, a3_.`pei` AS pei_44, a3_.`weight` AS weight_45, l14_.`alias` AS alias_46, a8_.`description_fr` AS description_fr_47, a8_.`description_en` AS description_en_48, a3_.`packaging_count` AS packaging_count_49, a3_.`packaging_count_ft` AS packaging_count_ft_50, a3_.`packaging_count_pc` AS packaging_count_pc_51, c15_.`publish_date` AS publish_date_52 FROM `article` a3_ LEFT JOIN `collection` c15_ ON a3_.collection = c15_.id LEFT JOIN `article_detail` a8_ ON a3_.id = a8_.article_id LEFT JOIN `list_measure` l0_ ON a3_.measure = l0_.id LEFT JOIN `list_draw` l1_ ON a3_.draw = l1_.id LEFT JOIN `list_measure_size` l10_ ON a3_.measurement_size = l10_.id LEFT JOIN `list_type` l2_ ON a3_.type = l2_.id LEFT JOIN `list_delivery` l14_ ON a3_.delivery = l14_.id LEFT JOIN `list_edge_type` l11_ ON a3_.edge_type = l11_.id LEFT JOIN `list_shape` l9_ ON a3_.shape = l9_.id LEFT JOIN `list_off_shade` l13_ ON a3_.off_shade = l13_.id LEFT JOIN `list_sink` l4_ ON a3_.installation_type = l4_.id LEFT JOIN `list_meth_laying` l5_ ON a3_.meth_laying = l5_.id LEFT JOIN article_factory_color a17_ ON a3_.id = a17_.article_id LEFT JOIN `list_factory_color` l16_ ON l16_.id = a17_.factory_color_id LEFT JOIN `list_material` l7_ ON a3_.material = l7_.id LEFT JOIN `list_using` l6_ ON a3_.using = l6_.id LEFT JOIN `list_repeat_draw` l12_ ON a3_.repeat_draw = l12_.id WHERE a3_.`id` = ? GROUP BY a3_.`id`
Parameters:
[
  215519914
]
2 0.10 ms
SELECT l0_.`id` AS id_0, l0_.`alias` AS alias_1 FROM `article` a1_ LEFT JOIN article_texture a2_ ON a1_.id = a2_.article_id LEFT JOIN `list_texture` l0_ ON l0_.id = a2_.texture_id WHERE a1_.`id` = ? AND l0_.`id` IS NOT NULL GROUP BY l0_.`id`
Parameters:
[
  215519914
]
3 0.10 ms
SELECT l0_.`id` AS id_0, l0_.`alias` AS alias_1, l1_.`id` AS id_2, l1_.`alias` AS alias_3 FROM `article` a2_ LEFT JOIN article_surface a3_ ON a2_.id = a3_.article_id LEFT JOIN `list_surface` l0_ ON l0_.id = a3_.surface_id LEFT JOIN `list_sliding` l1_ ON a2_.sliding = l1_.id WHERE a2_.`id` = ? AND l0_.`id` IS NOT NULL GROUP BY l0_.`id`
Parameters:
[
  215519914
]
4 0.10 ms
SELECT l0_.`id` AS id_0, l0_.`alias` AS alias_1 FROM `article` a1_ LEFT JOIN article_motiv a2_ ON a1_.id = a2_.article_id LEFT JOIN `list_motiv` l0_ ON l0_.id = a2_.motiv_id WHERE a1_.`id` = ? AND l0_.`id` IS NOT NULL GROUP BY l0_.`id`
Parameters:
[
  215519914
]
5 0.10 ms
SELECT l0_.`id` AS id_0, l0_.`alias` AS alias_1 FROM `article` a1_ LEFT JOIN article_style a2_ ON a1_.id = a2_.article_id LEFT JOIN `list_style` l0_ ON l0_.id = a2_.style_id WHERE a1_.`id` = ? AND l0_.`id` IS NOT NULL GROUP BY l0_.`id`
Parameters:
[
  215519914
]
6 0.10 ms
SELECT l0_.`name` AS name_0 FROM `article` a1_ LEFT JOIN article_factory_color a2_ ON a1_.id = a2_.article_id LEFT JOIN `list_factory_color` l0_ ON l0_.id = a2_.factory_color_id WHERE a1_.`id` = ? GROUP BY l0_.`id`
Parameters:
[
  215519914
]
7 0.09 ms
SELECT l0_.`alias` AS alias_0 FROM `article` a1_ LEFT JOIN article_shape a2_ ON a1_.id = a2_.article_id LEFT JOIN `list_shape` l0_ ON l0_.id = a2_.shape_id WHERE l0_.`alias` IS NOT NULL AND a1_.`id` = ?
Parameters:
[
  215519914
]
8 0.08 ms
SELECT l0_.`id` AS id_0, l0_.`alias` AS alias_1 FROM `article` a1_ LEFT JOIN article_edge_type a2_ ON a1_.id = a2_.article_id LEFT JOIN `list_edge_type` l0_ ON l0_.id = a2_.edge_type_id WHERE l0_.`id` IS NOT NULL AND a1_.`id` = ?
Parameters:
[
  215519914
]
9 0.79 ms
SELECT a0_.`id` AS id_0, a0_.`code` AS code_1, a0_.`name` AS name_2, a0_.`alternate_name` AS alternate_name_3, a0_.`urla` AS urla_4, a0_.`file` AS file_5, a0_.`size_x` AS size_x_6, a0_.`size_y` AS size_y_7, a0_.`size_gb_x` AS size_gb_x_8, a0_.`size_gb_y` AS size_gb_y_9, a0_.`size_tessera` AS size_tessera_10, a0_.`file_size1_x` AS file_size1_x_11, a0_.`file_size1_y` AS file_size1_y_12, a0_.`file_size2_x` AS file_size2_x_13, a0_.`file_size2_y` AS file_size2_y_14, a0_.`file_size3_x` AS file_size3_x_15, a0_.`file_size3_y` AS file_size3_y_16, a0_.`file_size500_x` AS file_size500_x_17, a0_.`file_size500_y` AS file_size500_y_18, a0_.`file_size740_x` AS file_size740_x_19, a0_.`file_size740_y` AS file_size740_y_20, a0_.`file_size8_x` AS file_size8_x_21, a0_.`file_size8_y` AS file_size8_y_22, a0_.`pallet` AS pallet_23, a0_.`pallet_ft` AS pallet_ft_24, a0_.`type_constraint` AS type_constraint_25, a0_.`multiple_pallet` AS multiple_pallet_26, a0_.`min_order` AS min_order_27, a0_.`price_euro` AS price_euro_28, a0_.`price_mq_euro` AS price_mq_euro_29, a0_.`price_euro_de` AS price_euro_de_30, a0_.`price_mq_euro_de` AS price_mq_euro_de_31, a0_.`price_euro_at` AS price_euro_at_32, a0_.`price_mq_euro_at` AS price_mq_euro_at_33, a0_.`price_euro_fi` AS price_euro_fi_34, a0_.`price_mq_euro_fi` AS price_mq_euro_fi_35, a0_.`price_euro_fr` AS price_euro_fr_36, a0_.`price_mq_euro_fr` AS price_mq_euro_fr_37, a0_.`price_euro_it` AS price_euro_it_38, a0_.`price_mq_euro_it` AS price_mq_euro_it_39, a0_.`price_euro_be` AS price_euro_be_40, a0_.`price_mq_euro_be` AS price_mq_euro_be_41, a0_.`price_euro_ie` AS price_euro_ie_42, a0_.`price_mq_euro_ie` AS price_mq_euro_ie_43, a0_.`price_euro_nl` AS price_euro_nl_44, a0_.`price_mq_euro_nl` AS price_mq_euro_nl_45, a0_.`price_euro_es` AS price_euro_es_46, a0_.`price_mq_euro_es` AS price_mq_euro_es_47, a0_.`price_rub` AS price_rub_48, a0_.`price_rue` AS price_rue_49, a0_.`price_mq_rub` AS price_mq_rub_50, a0_.`price_mq_rue` AS price_mq_rue_51, a0_.`price_gbp` AS price_gbp_52, a0_.`price_gbe` AS price_gbe_53, a0_.`price_mq_gbp` AS price_mq_gbp_54, a0_.`price_mq_gbe` AS price_mq_gbe_55, a0_.`price_usd` AS price_usd_56, a0_.`price_use` AS price_use_57, a0_.`price_fq_usd` AS price_fq_usd_58, a0_.`price_fq_use` AS price_fq_use_59, a0_.`price_mq_usd` AS price_mq_usd_60, a0_.`price_mq_use` AS price_mq_use_61, a0_.`price_chf` AS price_chf_62, a0_.`price_che` AS price_che_63, a0_.`price_mq_chf` AS price_mq_chf_64, a0_.`price_mq_che` AS price_mq_che_65, a0_.`price_sek` AS price_sek_66, a0_.`price_see` AS price_see_67, a0_.`price_mq_sek` AS price_mq_sek_68, a0_.`price_mq_see` AS price_mq_see_69, a0_.`price_dkk` AS price_dkk_70, a0_.`price_dke` AS price_dke_71, a0_.`price_mq_dkk` AS price_mq_dkk_72, a0_.`price_mq_dke` AS price_mq_dke_73, a0_.`price_nok` AS price_nok_74, a0_.`price_noe` AS price_noe_75, a0_.`price_mq_nok` AS price_mq_nok_76, a0_.`price_mq_noe` AS price_mq_noe_77, a0_.`price_pln` AS price_pln_78, a0_.`price_ple` AS price_ple_79, a0_.`price_mq_pln` AS price_mq_pln_80, a0_.`price_mq_ple` AS price_mq_ple_81, a0_.`price_cad` AS price_cad_82, a0_.`price_cae` AS price_cae_83, a0_.`price_fq_cad` AS price_fq_cad_84, a0_.`price_fq_cae` AS price_fq_cae_85, a0_.`price_mq_cad` AS price_mq_cad_86, a0_.`price_mq_cae` AS price_mq_cae_87, a0_.`thick` AS thick_88, a0_.`weight` AS weight_89, a0_.`packaging_count` AS packaging_count_90, a0_.`packaging_count_ft` AS packaging_count_ft_91, a0_.`packaging_count_pc` AS packaging_count_pc_92, a0_.`m2one_ps` AS m2one_ps_93, a0_.`description_ru` AS description_ru_94, a0_.`description_en` AS description_en_95, a0_.`description_it` AS description_it_96, a0_.`description_es` AS description_es_97, a0_.`description_fr` AS description_fr_98, a0_.`description_de` AS description_de_99, a0_.`description_pt` AS description_pt_100, a0_.`description_pl` AS description_pl_101, a0_.`description_nl` AS description_nl_102, a0_.`description_fi` AS description_fi_103, a0_.`description_ua` AS description_ua_104, a0_.`description_sv` AS description_sv_105, a0_.`description_no` AS description_no_106, a0_.`description_da` AS description_da_107, a0_.`description_cn` AS description_cn_108, a0_.`scheme` AS scheme_109, a0_.`sale_date` AS sale_date_110, a0_.`thin_granite` AS thin_granite_111, a0_.`glazed_granite` AS glazed_granite_112, a0_.`pei` AS pei_113, a0_.`is_grouped` AS is_grouped_114, a0_.`is_rotate` AS is_rotate_115, a0_.`price_prx` AS price_prx_116, a0_.`background_white` AS background_white_117, a0_.`border_grey` AS border_grey_118, a0_.`is_edit` AS is_edit_119, a0_.`edited_at` AS edited_at_120, a0_.`comment` AS comment_121, a0_.`file_edit` AS file_edit_122, a0_.`image_setting` AS image_setting_123, a0_.`file_w` AS file_w_124, a0_.`file_h` AS file_h_125, a0_.`file_w4000` AS file_w4000_126, a0_.`file_h4000` AS file_h4000_127, a0_.`size_z` AS size_z_128, a0_.`size_gb_z` AS size_gb_z_129, a0_.`repeat_number` AS repeat_number_130, a0_.`size_big` AS size_big_131, a0_.`delivery_suspended` AS delivery_suspended_132, a0_.`poddon_x` AS poddon_x_133, a0_.`poddon_y` AS poddon_y_134, a0_.`poddon_z` AS poddon_z_135, a0_.`module` AS module_136, a0_.`tessera_size_x` AS tessera_size_x_137, a0_.`tessera_size_y` AS tessera_size_y_138, a0_.`tessera_size_z` AS tessera_size_z_139, a0_.`poddon_count` AS poddon_count_140, a0_.`poddon_weight` AS poddon_weight_141, a0_.`added_to_cart` AS added_to_cart_142, a0_.`sold_out` AS sold_out_143, a0_.`sold_out_vol` AS sold_out_vol_144, a0_.`swimming_pool` AS swimming_pool_145, a0_.`can_select_substrate` AS can_select_substrate_146, a0_.`designer` AS designer_147, a0_.`designer_id` AS designer_id_148, a0_.`mosaic_effect` AS mosaic_effect_149, a0_.`not_sample` AS not_sample_150, a0_.`express_sample` AS express_sample_151, a0_.`description_edit` AS description_edit_152, a0_.`comment_scheme_image` AS comment_scheme_image_153, a0_.`variant_image` AS variant_image_154, a0_.`square` AS square_155, a0_.`fix_big_size` AS fix_big_size_156, a0_.`overflow_sink` AS overflow_sink_157, a0_.`drain_size_sink` AS drain_size_sink_158, a0_.`faucet_hole_sink` AS faucet_hole_sink_159, a0_.`rotate` AS rotate_160, a0_.`dyed_in_mass` AS dyed_in_mass_161, a0_.`durability_class` AS durability_class_162, a0_.`is_comment_ru` AS is_comment_ru_163, a0_.`file_rotation` AS file_rotation_164, a0_.`created_at` AS created_at_165, a0_.`updated_at` AS updated_at_166, a0_.collection AS collection_167, a0_.newCollection AS newCollection_168, a0_.type AS type_169, a0_.measure AS measure_170, a0_.surface AS surface_171, a0_.pr_status AS pr_status_172, a0_.category_price AS category_price_173, a0_.edge_type AS edge_type_174, a0_.using AS using_175, a0_.shape AS shape_176, a0_.material AS material_177, a0_.delivery AS delivery_178, a0_.sliding AS sliding_179, a0_.off_shade AS off_shade_180, a0_.style AS style_181, a0_.repeat_draw AS repeat_draw_182, a0_.measurement_size AS measurement_size_183, a0_.installation_type AS installation_type_184, a0_.meth_laying AS meth_laying_185, a0_.draw AS draw_186 FROM `article` a0_ WHERE a0_.`name` LIKE ? OR a0_.`alternate_name` LIKE ? LIMIT 1
Parameters:
[
  "Fillgel 4407 Marrone Avana"
  "Fillgel 4407 Marrone Avana"
]
10 0.20 ms
SELECT t0.`id` AS id_1, t0.`del` AS del_2, t0.`size_x_one` AS size_x_one_3, t0.`size_y_one` AS size_y_one_4, t0.`type_one` AS type_one_5, t0.`amount_one` AS amount_one_6, t0.`size_x_two` AS size_x_two_7, t0.`size_y_two` AS size_y_two_8, t0.`type_two` AS type_two_9, t0.`amount_two` AS amount_two_10, t0.item_id AS item_id_11, t0.item_one AS item_one_12, t0.item_two AS item_two_13 FROM `sample` t0 WHERE t0.item_id = ?
Parameters:
[
  228197745
]
11 0.12 ms
SELECT t0.`id` AS id_1, t0.`picture_in_title` AS picture_in_title_2, t0.`gtin` AS gtin_3, t0.`file` AS file_4, t0.`file_size1_x` AS file_size1_x_5, t0.`file_size1_y` AS file_size1_y_6, t0.`file_size2_x` AS file_size2_x_7, t0.`file_size2_y` AS file_size2_y_8, t0.`file_size3_x` AS file_size3_x_9, t0.`file_size3_y` AS file_size3_y_10, t0.`file_size8_x` AS file_size8_x_11, t0.`file_size8_y` AS file_size8_y_12, t0.`file_size500_x` AS file_size500_x_13, t0.`file_size500_y` AS file_size500_y_14, t0.`file_size740_x` AS file_size740_x_15, t0.`file_size740_y` AS file_size740_y_16, t0.`description_ru` AS description_ru_17, t0.`description_en` AS description_en_18, t0.`description_it` AS description_it_19, t0.`description_es` AS description_es_20, t0.`description_fr` AS description_fr_21, t0.`description_de` AS description_de_22, t0.`description_pt` AS description_pt_23, t0.`description_pl` AS description_pl_24, t0.`description_nl` AS description_nl_25, t0.`description_fi` AS description_fi_26, t0.`description_ua` AS description_ua_27, t0.`description_sv` AS description_sv_28, t0.`description_no` AS description_no_29, t0.`description_da` AS description_da_30, t0.`description_edit` AS description_edit_31, t0.`comment` AS comment_32, t0.`file_edit` AS file_edit_33, t0.`image_setting` AS image_setting_34, t0.`file_w` AS file_w_35, t0.`file_h` AS file_h_36, t0.`file_w4000` AS file_w4000_37, t0.`file_h4000` AS file_h4000_38, t0.`comment_scheme_image` AS comment_scheme_image_39, t0.`variant_image` AS variant_image_40, t0.`file_rotation` AS file_rotation_41, t0.`rotate` AS rotate_42, t0.`type_painting` AS type_painting_43, t0.`big_size_scheme` AS big_size_scheme_44, t0.article_id AS article_id_45 FROM `article_detail` t0 WHERE t0.article_id = ?
Parameters:
[
  228197745
]
12 0.33 ms
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.`id` = ?
Parameters:
[
  3245628
]
13 0.21 ms
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:
[
  125
]

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\Collection No errors.
WebBundle\Entity\FilterEntity No errors.
WebBundle\Entity\CollectionAlsoViewed No errors.
WebBundle\Entity\Idea No errors.
WebBundle\Entity\LastUrlEntity No errors.
WebBundle\Entity\Article 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.
WebBundle\Entity\ListCountry No errors.
FlexApp\Entity\ConsultantEntity No errors.
FlexApp\Entity\Collection\CollectionEntity No errors.
WebBundle\Entity\ListType No errors.
WebBundle\Entity\ListMeasure No errors.
WebBundle\Entity\ListSurface No errors.
WebBundle\Entity\ListPRStatus No errors.
WebBundle\Entity\ListPrice No errors.
WebBundle\Entity\ListEdgeType No errors.
WebBundle\Entity\ListUsing No errors.
WebBundle\Entity\ListShape No errors.
WebBundle\Entity\ListMaterial No errors.
WebBundle\Entity\ListDelivery No errors.
WebBundle\Entity\ListSliding No errors.
WebBundle\Entity\ListOffShade No errors.
WebBundle\Entity\ListStyle No errors.
WebBundle\Entity\Interior No errors.
WebBundle\Entity\ListColor No errors.
WebBundle\Entity\ListFactoryColor No errors.
WebBundle\Entity\ListTexture No errors.
WebBundle\Entity\ListStoneTexture No errors.
WebBundle\Entity\ArticlePriceDiscount No errors.
WebBundle\Entity\InteriorArticle No errors.
WebBundle\Entity\InteriorArticleLogging No errors.
WebBundle\Entity\ListRepeatDraw No errors.
WebBundle\Entity\ListMotiv No errors.
WebBundle\Entity\ListMeasureSize No errors.
WebBundle\Entity\SampleEntity No errors.
WebBundle\Entity\ListSink No errors.
WebBundle\Entity\ListMethLaying No errors.
WebBundle\Entity\ArticleDetail No errors.
WebBundle\Entity\ListDraw No errors.
WebBundle\Entity\Factory No errors.
WebBundle\Entity\LocaleHtmlEntity No errors.
WebBundle\Entity\ListEmail No errors.
WebBundle\Entity\Publication No errors.
WebBundle\Entity\StaticPageEntity No errors.
WebBundle\Entity\TransEntity No errors.
FlexApp\Entity\Exhibition\ExhEntity No errors.
FlexApp\Entity\Exhibition\ExhBrandEntity No errors.
FlexApp\Entity\Exhibition\ExhCollectionEntity No errors.
WebBundle\Entity\LocaleMetaEntity No errors.
WebBundle\Entity\CheckList No errors.
FlexApp\Entity\GeoCountryEntity No errors.
WebBundle\Entity\FactoryUser No errors.
WebBundle\Entity\ListBrandParser No errors.

oneC entity manager

No loaded entities.

logs entity manager

No loaded entities.