Symfony Profiler

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

SELECT e0_.content AS content_0, e0_.field AS field_1, e0_.locale AS locale_2 FROM ext_translations e0_ WHERE e0_.foreign_key = 82 AND e0_.object_class = 'App\\Entity\\Project' ORDER BY e0_.locale ASC;

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 = 'ja' AND e0_.object_class = 'App\\Entity\\Shape';

SELECT
  t0.id AS id_1,
  t0.company_name AS company_name_2,
  t0.website_company AS website_company_3,
  t0.name AS name_4,
  t0.description AS description_5,
  t0.year AS year_6,
  t0.city AS city_7,
  t0.area_m AS area_m_8,
  t0.architect AS architect_9,
  t0.website_architect AS website_architect_10,
  t0.photography AS photography_11,
  t0.installation AS installation_12,
  t0.actif AS actif_13,
  t0.slug AS slug_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.kind_project_id AS kind_project_id_17,
  t18.id AS id_19,
  t18.name AS name_20,
  t18.slug AS slug_21,
  t0.country_id AS country_id_22,
  t23.id AS id_24,
  t23.name AS name_25,
  t23.caption AS caption_26,
  t23.path AS path_27,
  t23.size AS size_28,
  t23.created_at AS created_at_29,
  t23.updated_at AS updated_at_30,
  t23.to_show AS to_show_31,
  t23.collection_id AS collection_id_32,
  t23.product_id AS product_id_33,
  t23.project_id AS project_id_34,
  t23.section_id AS section_id_35
FROM
  project t0
  INNER JOIN kind_project t18 ON t0.kind_project_id = t18.id
  LEFT JOIN attachment t23 ON t23.project_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.website_company AS website_company_3, t0.name AS name_4, t0.description AS description_5, t0.year AS year_6, t0.city AS city_7, t0.area_m AS area_m_8, t0.architect AS architect_9, t0.website_architect AS website_architect_10, t0.photography AS photography_11, t0.installation AS installation_12, t0.actif AS actif_13, t0.slug AS slug_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.kind_project_id AS kind_project_id_17, t18.id AS id_19, t18.name AS name_20, t18.slug AS slug_21, t0.country_id AS country_id_22, t23.id AS id_24, t23.name AS name_25, t23.caption AS caption_26, t23.path AS path_27, t23.size AS size_28, t23.created_at AS created_at_29, t23.updated_at AS updated_at_30, t23.to_show AS to_show_31, t23.collection_id AS collection_id_32, t23.product_id AS product_id_33, t23.project_id AS project_id_34, t23.section_id AS section_id_35 FROM project t0 INNER JOIN kind_project t18 ON t0.kind_project_id = t18.id LEFT JOIN attachment t23 ON t23.project_id = t0.id WHERE t0.id = 82;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.color_code AS color_code_4,
  t0.best_seller AS best_seller_5,
  t0.order_appearance AS order_appearance_6,
  t0.file_archi AS file_archi_7,
  t0.file_revit AS file_revit_8,
  t0.actif AS actif_9,
  t0.slug AS slug_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.new AS new_13,
  t0.moq AS moq_14,
  t0.stock AS stock_15,
  t16.id AS id_17,
  t16.name AS name_18,
  t16.caption AS caption_19,
  t16.path AS path_20,
  t16.size AS size_21,
  t16.created_at AS created_at_22,
  t16.updated_at AS updated_at_23,
  t16.to_show AS to_show_24,
  t16.collection_id AS collection_id_25,
  t16.product_id AS product_id_26,
  t16.project_id AS project_id_27,
  t16.section_id AS section_id_28,
  t0.collection_id AS collection_id_29
FROM
  product t0
  LEFT JOIN attachment t16 ON t16.product_id = t0.id
  INNER JOIN product_project ON t0.id = product_project.product_id
WHERE
  product_project.project_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.color_code AS color_code_4, t0.best_seller AS best_seller_5, t0.order_appearance AS order_appearance_6, t0.file_archi AS file_archi_7, t0.file_revit AS file_revit_8, t0.actif AS actif_9, t0.slug AS slug_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.new AS new_13, t0.moq AS moq_14, t0.stock AS stock_15, t16.id AS id_17, t16.name AS name_18, t16.caption AS caption_19, t16.path AS path_20, t16.size AS size_21, t16.created_at AS created_at_22, t16.updated_at AS updated_at_23, t16.to_show AS to_show_24, t16.collection_id AS collection_id_25, t16.product_id AS product_id_26, t16.project_id AS project_id_27, t16.section_id AS section_id_28, t0.collection_id AS collection_id_29 FROM product t0 LEFT JOIN attachment t16 ON t16.product_id = t0.id INNER JOIN product_project ON t0.id = product_project.product_id WHERE product_project.project_id = 82;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.actif AS actif_4
FROM
  shape t0
  INNER JOIN shape_project ON t0.id = shape_project.shape_id
WHERE
  shape_project.project_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.actif AS actif_4 FROM shape t0 INNER JOIN shape_project ON t0.id = shape_project.shape_id WHERE shape_project.project_id = 82;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.actif AS actif_4
FROM
  color t0
  INNER JOIN color_product ON t0.id = color_product.color_id
WHERE
  color_product.product_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.actif AS actif_4 FROM color t0 INNER JOIN color_product ON t0.id = color_product.color_id WHERE color_product.product_id = 42;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.cc AS cc_3,
  t0.bcc AS bcc_4,
  t0.alpha2 AS alpha2_5,
  t0.agent_id AS agent_id_6,
  t7.id AS id_8,
  t7.first_name AS first_name_9,
  t7.last_name AS last_name_10,
  t7.email_address AS email_address_11,
  t7.phone_number AS phone_number_12,
  t7.company_name AS company_name_13,
  t7.localisation AS localisation_14,
  t7.city AS city_15,
  t7.actif AS actif_16,
  t7.slug AS slug_17,
  t7.current_locale AS current_locale_18
FROM
  country t0
  INNER JOIN agent t7 ON t0.agent_id = t7.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.cc AS cc_3, t0.bcc AS bcc_4, t0.alpha2 AS alpha2_5, t0.agent_id AS agent_id_6, t7.id AS id_8, t7.first_name AS first_name_9, t7.last_name AS last_name_10, t7.email_address AS email_address_11, t7.phone_number AS phone_number_12, t7.company_name AS company_name_13, t7.localisation AS localisation_14, t7.city AS city_15, t7.actif AS actif_16, t7.slug AS slug_17, t7.current_locale AS current_locale_18 FROM country t0 INNER JOIN agent t7 ON t0.agent_id = t7.id WHERE t0.id = 13;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.launch_year AS launch_year_4,
  t0.roll AS roll_5,
  t0.tile AS tile_6,
  t0.checkerboard AS checkerboard_7,
  t0.monolithic AS monolithic_8,
  t0.brick AS brick_9,
  t0.ashlar AS ashlar_10,
  t0.order_appearance AS order_appearance_11,
  t0.actif AS actif_12,
  t0.slug AS slug_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.new AS new_16,
  t17.id AS id_18,
  t17.name AS name_19,
  t17.caption AS caption_20,
  t17.path AS path_21,
  t17.size AS size_22,
  t17.created_at AS created_at_23,
  t17.updated_at AS updated_at_24,
  t17.to_show AS to_show_25,
  t17.collection_id AS collection_id_26,
  t17.product_id AS product_id_27,
  t17.project_id AS project_id_28,
  t17.section_id AS section_id_29
FROM
  collection t0
  LEFT JOIN attachment t17 ON t17.collection_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.launch_year AS launch_year_4, t0.roll AS roll_5, t0.tile AS tile_6, t0.checkerboard AS checkerboard_7, t0.monolithic AS monolithic_8, t0.brick AS brick_9, t0.ashlar AS ashlar_10, t0.order_appearance AS order_appearance_11, t0.actif AS actif_12, t0.slug AS slug_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.new AS new_16, t17.id AS id_18, t17.name AS name_19, t17.caption AS caption_20, t17.path AS path_21, t17.size AS size_22, t17.created_at AS created_at_23, t17.updated_at AS updated_at_24, t17.to_show AS to_show_25, t17.collection_id AS collection_id_26, t17.product_id AS product_id_27, t17.project_id AS project_id_28, t17.section_id AS section_id_29 FROM collection t0 LEFT JOIN attachment t17 ON t17.collection_id = t0.id WHERE t0.id = 14;

SELECT
  t0.id AS id_1,
  t0.old_url AS old_url_2,
  t0.new_url AS new_url_3
FROM
  custom_redirection t0
WHERE
  t0.old_url = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.old_url AS old_url_2, t0.new_url AS new_url_3 FROM custom_redirection t0 WHERE t0.old_url = '/api/v1/ja/projects/filter/product/planet' LIMIT 1;

SELECT
  p0_.id AS id_0
FROM
  project p0_
GROUP BY
  p0_.id
ORDER BY
  p0_.name ASC

SELECT p0_.id AS id_0 FROM project p0_ GROUP BY p0_.id ORDER BY p0_.name ASC;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.description AS description_2,
  p0_.color_code AS color_code_3,
  p0_.best_seller AS best_seller_4,
  p0_.order_appearance AS order_appearance_5,
  p0_.file_archi AS file_archi_6,
  p0_.file_revit AS file_revit_7,
  p0_.actif AS actif_8,
  p0_.slug AS slug_9,
  p0_.created_at AS created_at_10,
  p0_.updated_at AS updated_at_11,
  p0_.new AS new_12,
  p0_.moq AS moq_13,
  p0_.stock AS stock_14,
  p0_.collection_id AS collection_id_15
FROM
  product p0_
  INNER JOIN collection c1_ ON p0_.collection_id = c1_.id
WHERE
  p0_.slug = ?
  AND p0_.actif = 1
  AND c1_.actif = 1

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.color_code AS color_code_3, p0_.best_seller AS best_seller_4, p0_.order_appearance AS order_appearance_5, p0_.file_archi AS file_archi_6, p0_.file_revit AS file_revit_7, p0_.actif AS actif_8, p0_.slug AS slug_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11, p0_.new AS new_12, p0_.moq AS moq_13, p0_.stock AS stock_14, p0_.collection_id AS collection_id_15 FROM product p0_ INNER JOIN collection c1_ ON p0_.collection_id = c1_.id WHERE p0_.slug = 'planet' AND p0_.actif = 1 AND c1_.actif = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.caption AS caption_3,
  t0.path AS path_4,
  t0.size AS size_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.to_show AS to_show_8,
  t0.collection_id AS collection_id_9,
  t0.product_id AS product_id_10,
  t0.project_id AS project_id_11,
  t0.section_id AS section_id_12
FROM
  attachment t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.caption AS caption_3, t0.path AS path_4, t0.size AS size_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.to_show AS to_show_8, t0.collection_id AS collection_id_9, t0.product_id AS product_id_10, t0.project_id AS project_id_11, t0.section_id AS section_id_12 FROM attachment t0 WHERE t0.product_id = 42;