Symfony Profiler

SELECT
  p0_.id AS id_0,
  COALESCE(t1_.content, p0_.name) AS name_1,
  COALESCE(t2_.content, p0_.menu_name) AS menu_name_2,
  COALESCE(t3_.content, p0_.description) AS description_3,
  COALESCE(t4_.content, p0_.title) AS title_4,
  COALESCE(t5_.content, p0_.slug) AS slug_5,
  p0_.is_active AS is_active_6,
  p0_.sequence AS sequence_7,
  p0_.javascript AS javascript_8,
  COALESCE(t6_.content, p0_.text_general) AS text_general_9,
  p0_.state AS state_10,
  p0_.is_indexable AS is_indexable_11,
  p0_.external_id AS external_id_12,
  p0_.producer_id AS producer_id_13,
  p0_.upload_id AS upload_id_14,
  p0_.product_type_id AS product_type_id_15
FROM
  product p0_
  LEFT JOIN ext_translations t1_ ON t1_.locale = 'en'
  AND t1_.field = 'name'
  AND t1_.object_class = 'App\\Entity\\Project\\Product'
  AND t1_.foreign_key = p0_.id
  LEFT JOIN ext_translations t2_ ON t2_.locale = 'en'
  AND t2_.field = 'menu_name'
  AND t2_.object_class = 'App\\Entity\\Project\\Product'
  AND t2_.foreign_key = p0_.id
  LEFT JOIN ext_translations t3_ ON t3_.locale = 'en'
  AND t3_.field = 'description'
  AND t3_.object_class = 'App\\Entity\\Project\\Product'
  AND t3_.foreign_key = p0_.id
  LEFT JOIN ext_translations t4_ ON t4_.locale = 'en'
  AND t4_.field = 'title'
  AND t4_.object_class = 'App\\Entity\\Project\\Product'
  AND t4_.foreign_key = p0_.id
  LEFT JOIN ext_translations t5_ ON t5_.locale = 'en'
  AND t5_.field = 'slug'
  AND t5_.object_class = 'App\\Entity\\Project\\Product'
  AND t5_.foreign_key = p0_.id
  LEFT JOIN ext_translations t6_ ON t6_.locale = 'en'
  AND t6_.field = 'textGeneral'
  AND t6_.object_class = 'App\\Entity\\Project\\Product'
  AND t6_.foreign_key = p0_.id
WHERE
  (p0_.id = ?)
  AND (p0_.is_active = 1)

SELECT p0_.id AS id_0, COALESCE(t1_.content, p0_.name) AS name_1, COALESCE(t2_.content, p0_.menu_name) AS menu_name_2, COALESCE(t3_.content, p0_.description) AS description_3, COALESCE(t4_.content, p0_.title) AS title_4, COALESCE(t5_.content, p0_.slug) AS slug_5, p0_.is_active AS is_active_6, p0_.sequence AS sequence_7, p0_.javascript AS javascript_8, COALESCE(t6_.content, p0_.text_general) AS text_general_9, p0_.state AS state_10, p0_.is_indexable AS is_indexable_11, p0_.external_id AS external_id_12, p0_.producer_id AS producer_id_13, p0_.upload_id AS upload_id_14, p0_.product_type_id AS product_type_id_15 FROM product p0_ LEFT JOIN ext_translations t1_ ON t1_.locale = 'en' AND t1_.field = 'name' AND t1_.object_class = 'App\\Entity\\Project\\Product' AND t1_.foreign_key = p0_.id LEFT JOIN ext_translations t2_ ON t2_.locale = 'en' AND t2_.field = 'menu_name' AND t2_.object_class = 'App\\Entity\\Project\\Product' AND t2_.foreign_key = p0_.id LEFT JOIN ext_translations t3_ ON t3_.locale = 'en' AND t3_.field = 'description' AND t3_.object_class = 'App\\Entity\\Project\\Product' AND t3_.foreign_key = p0_.id LEFT JOIN ext_translations t4_ ON t4_.locale = 'en' AND t4_.field = 'title' AND t4_.object_class = 'App\\Entity\\Project\\Product' AND t4_.foreign_key = p0_.id LEFT JOIN ext_translations t5_ ON t5_.locale = 'en' AND t5_.field = 'slug' AND t5_.object_class = 'App\\Entity\\Project\\Product' AND t5_.foreign_key = p0_.id LEFT JOIN ext_translations t6_ ON t6_.locale = 'en' AND t6_.field = 'textGeneral' AND t6_.object_class = 'App\\Entity\\Project\\Product' AND t6_.foreign_key = p0_.id WHERE (p0_.id = 693) AND (p0_.is_active = 1);

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.menu_name AS menu_name_2,
  p0_.description AS description_3,
  p0_.title AS title_4,
  p0_.slug AS slug_5,
  p0_.is_active AS is_active_6,
  p0_.sequence AS sequence_7,
  p0_.javascript AS javascript_8,
  p0_.text_general AS text_general_9,
  p0_.state AS state_10,
  p0_.is_indexable AS is_indexable_11,
  p0_.external_id AS external_id_12,
  p1_.id AS id_13,
  p1_.name AS name_14,
  p1_.stock AS stock_15,
  p1_.external_id AS external_id_16,
  p1_.avg_restock_days AS avg_restock_days_17,
  p1_.is_active AS is_active_18,
  c2_.id AS id_19,
  c2_.name AS name_20,
  c2_.hex AS hex_21,
  c2_.sequence AS sequence_22,
  a3_.id AS id_23,
  a3_.name AS name_24,
  a3_.description AS description_25,
  p4_.id AS id_26,
  p4_.data AS data_27,
  p4_.sequence AS sequence_28,
  p5_.id AS id_29,
  p5_.sequence AS sequence_30,
  u6_.id AS id_31,
  u6_.type AS type_32,
  p7_.id AS id_33,
  p7_.name AS name_34,
  p7_.description AS description_35,
  p8_.id AS id_36,
  p8_.name AS name_37,
  p8_.menu_name AS menu_name_38,
  p8_.title AS title_39,
  p8_.description AS description_40,
  p8_.html AS html_41,
  p8_.is_menu AS is_menu_42,
  p8_.slug AS slug_43,
  u9_.id AS id_44,
  u9_.name AS name_45,
  u9_.extension AS extension_46,
  u9_.mime AS mime_47,
  u9_.title AS title_48,
  u9_.short_description AS short_description_49,
  u9_.description AS description_50,
  u9_.created AS created_51,
  u9_.path AS path_52,
  u9_.original_name AS original_name_53,
  u9_.width AS width_54,
  u9_.height AS height_55,
  u9_.sequence AS sequence_56,
  p0_.producer_id AS producer_id_57,
  p0_.upload_id AS upload_id_58,
  p0_.product_type_id AS product_type_id_59,
  p1_.product_id AS product_id_60,
  p1_.colour_id AS colour_id_61,
  p1_.availability_id AS availability_id_62,
  p1_.upload_id AS upload_id_63,
  p1_.product_type_id AS product_type_id_64,
  p4_.parameter_group_id AS parameter_group_id_65,
  p4_.category_id AS category_id_66,
  p4_.product_variant_id AS product_variant_id_67,
  p4_.person_id AS person_id_68,
  p5_.upload_group_id AS upload_group_id_69,
  p5_.product_variant_id AS product_variant_id_70,
  p8_.upload_id AS upload_id_71,
  u9_.upload_group_id AS upload_group_id_72
FROM
  product p0_
  LEFT JOIN product_variant p1_ ON p0_.id = p1_.product_id
  LEFT JOIN colour c2_ ON p1_.colour_id = c2_.id
  LEFT JOIN availability a3_ ON p1_.availability_id = a3_.id
  LEFT JOIN parameter p4_ ON p1_.id = p4_.product_variant_id
  LEFT JOIN product_variant_upload_group p5_ ON p1_.id = p5_.product_variant_id
  LEFT JOIN upload_group u6_ ON p5_.upload_group_id = u6_.id
  LEFT JOIN product_type p7_ ON p1_.product_type_id = p7_.id
  LEFT JOIN producer p8_ ON p0_.producer_id = p8_.id
  LEFT JOIN upload u9_ ON p0_.upload_id = u9_.id
WHERE
  (p0_.id = ?)
  AND (p0_.is_active = 1)

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.menu_name AS menu_name_2, p0_.description AS description_3, p0_.title AS title_4, p0_.slug AS slug_5, p0_.is_active AS is_active_6, p0_.sequence AS sequence_7, p0_.javascript AS javascript_8, p0_.text_general AS text_general_9, p0_.state AS state_10, p0_.is_indexable AS is_indexable_11, p0_.external_id AS external_id_12, p1_.id AS id_13, p1_.name AS name_14, p1_.stock AS stock_15, p1_.external_id AS external_id_16, p1_.avg_restock_days AS avg_restock_days_17, p1_.is_active AS is_active_18, c2_.id AS id_19, c2_.name AS name_20, c2_.hex AS hex_21, c2_.sequence AS sequence_22, a3_.id AS id_23, a3_.name AS name_24, a3_.description AS description_25, p4_.id AS id_26, p4_.data AS data_27, p4_.sequence AS sequence_28, p5_.id AS id_29, p5_.sequence AS sequence_30, u6_.id AS id_31, u6_.type AS type_32, p7_.id AS id_33, p7_.name AS name_34, p7_.description AS description_35, p8_.id AS id_36, p8_.name AS name_37, p8_.menu_name AS menu_name_38, p8_.title AS title_39, p8_.description AS description_40, p8_.html AS html_41, p8_.is_menu AS is_menu_42, p8_.slug AS slug_43, u9_.id AS id_44, u9_.name AS name_45, u9_.extension AS extension_46, u9_.mime AS mime_47, u9_.title AS title_48, u9_.short_description AS short_description_49, u9_.description AS description_50, u9_.created AS created_51, u9_.path AS path_52, u9_.original_name AS original_name_53, u9_.width AS width_54, u9_.height AS height_55, u9_.sequence AS sequence_56, p0_.producer_id AS producer_id_57, p0_.upload_id AS upload_id_58, p0_.product_type_id AS product_type_id_59, p1_.product_id AS product_id_60, p1_.colour_id AS colour_id_61, p1_.availability_id AS availability_id_62, p1_.upload_id AS upload_id_63, p1_.product_type_id AS product_type_id_64, p4_.parameter_group_id AS parameter_group_id_65, p4_.category_id AS category_id_66, p4_.product_variant_id AS product_variant_id_67, p4_.person_id AS person_id_68, p5_.upload_group_id AS upload_group_id_69, p5_.product_variant_id AS product_variant_id_70, p8_.upload_id AS upload_id_71, u9_.upload_group_id AS upload_group_id_72 FROM product p0_ LEFT JOIN product_variant p1_ ON p0_.id = p1_.product_id LEFT JOIN colour c2_ ON p1_.colour_id = c2_.id LEFT JOIN availability a3_ ON p1_.availability_id = a3_.id LEFT JOIN parameter p4_ ON p1_.id = p4_.product_variant_id LEFT JOIN product_variant_upload_group p5_ ON p1_.id = p5_.product_variant_id LEFT JOIN upload_group u6_ ON p5_.upload_group_id = u6_.id LEFT JOIN product_type p7_ ON p1_.product_type_id = p7_.id LEFT JOIN producer p8_ ON p0_.producer_id = p8_.id LEFT JOIN upload u9_ ON p0_.upload_id = u9_.id WHERE (p0_.id = 693) AND (p0_.is_active = 1);

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.unit AS unit_3,
  t0.is_product_parameter AS is_product_parameter_4,
  t0.is_filter AS is_filter_5,
  t0.type_id AS type_id_6
FROM
  parameter_group t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.unit AS unit_3, t0.is_product_parameter AS is_product_parameter_4, t0.is_filter AS is_filter_5, t0.type_id AS type_id_6 FROM parameter_group t0 WHERE t0.id = 1;

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '1' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Project\\ParameterGroup';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.unit AS unit_3,
  t0.is_product_parameter AS is_product_parameter_4,
  t0.is_filter AS is_filter_5,
  t0.type_id AS type_id_6
FROM
  parameter_group t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.unit AS unit_3, t0.is_product_parameter AS is_product_parameter_4, t0.is_filter AS is_filter_5, t0.type_id AS type_id_6 FROM parameter_group t0 WHERE t0.id = 2;

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '2' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Project\\ParameterGroup';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.unit AS unit_3,
  t0.is_product_parameter AS is_product_parameter_4,
  t0.is_filter AS is_filter_5,
  t0.type_id AS type_id_6
FROM
  parameter_group t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.unit AS unit_3, t0.is_product_parameter AS is_product_parameter_4, t0.is_filter AS is_filter_5, t0.type_id AS type_id_6 FROM parameter_group t0 WHERE t0.id = 8;

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '8' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Project\\ParameterGroup';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.unit AS unit_3,
  t0.is_product_parameter AS is_product_parameter_4,
  t0.is_filter AS is_filter_5,
  t0.type_id AS type_id_6
FROM
  parameter_group t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.unit AS unit_3, t0.is_product_parameter AS is_product_parameter_4, t0.is_filter AS is_filter_5, t0.type_id AS type_id_6 FROM parameter_group t0 WHERE t0.id = 28;

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '28' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Project\\ParameterGroup';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.unit AS unit_3,
  t0.is_product_parameter AS is_product_parameter_4,
  t0.is_filter AS is_filter_5,
  t0.type_id AS type_id_6
FROM
  parameter_group t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.unit AS unit_3, t0.is_product_parameter AS is_product_parameter_4, t0.is_filter AS is_filter_5, t0.type_id AS type_id_6 FROM parameter_group t0 WHERE t0.id = 27;

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '27' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Project\\ParameterGroup';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.unit AS unit_3,
  t0.is_product_parameter AS is_product_parameter_4,
  t0.is_filter AS is_filter_5,
  t0.type_id AS type_id_6
FROM
  parameter_group t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.unit AS unit_3, t0.is_product_parameter AS is_product_parameter_4, t0.is_filter AS is_filter_5, t0.type_id AS type_id_6 FROM parameter_group t0 WHERE t0.id = 32;

SELECT
  e0_.content AS content_0,
  e0_.field AS field_1
FROM
  ext_translations e0_
WHERE
  e0_.foreign_key = ?
  AND e0_.locale = ?
  AND e0_.object_class = ?

SELECT e0_.content AS content_0, e0_.field AS field_1 FROM ext_translations e0_ WHERE e0_.foreign_key = '32' AND e0_.locale = 'en' AND e0_.object_class = 'App\\Entity\\Project\\ParameterGroup';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.extension AS extension_3,
  t0.mime AS mime_4,
  t0.title AS title_5,
  t0.short_description AS short_description_6,
  t0.description AS description_7,
  t0.created AS created_8,
  t0.path AS path_9,
  t0.original_name AS original_name_10,
  t0.width AS width_11,
  t0.height AS height_12,
  t0.sequence AS sequence_13,
  t0.upload_group_id AS upload_group_id_14
FROM
  upload t0
WHERE
  t0.upload_group_id = ?
ORDER BY
  t0.sequence ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.extension AS extension_3, t0.mime AS mime_4, t0.title AS title_5, t0.short_description AS short_description_6, t0.description AS description_7, t0.created AS created_8, t0.path AS path_9, t0.original_name AS original_name_10, t0.width AS width_11, t0.height AS height_12, t0.sequence AS sequence_13, t0.upload_group_id AS upload_group_id_14 FROM upload t0 WHERE t0.upload_group_id = 271 ORDER BY t0.sequence ASC;