Symfony Profiler

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_en` AS description_en_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`

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_en` AS description_en_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` = 872990743 GROUP BY a3_.`id`;

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`

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` = 872990743 AND l0_.`id` IS NOT NULL GROUP BY l0_.`id`;

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`

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` = 872990743 AND l0_.`id` IS NOT NULL GROUP BY l0_.`id`;

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`

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` = 872990743 AND l0_.`id` IS NOT NULL GROUP BY l0_.`id`;

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`

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` = 872990743 AND l0_.`id` IS NOT NULL GROUP BY l0_.`id`;

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`

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` = 872990743 GROUP BY l0_.`id`;

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` = ?

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` = 872990743;

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` = ?

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` = 872990743;