Symfony Profiler

SELECT
  n0_.id AS id_0,
  n0_.category AS category_1,
  n0_.type AS type_2,
  n0_.code AS code_3,
  n0_.label AS label_4,
  n0_.created_at AS created_at_5,
  n0_.updated_at AS updated_at_6,
  n0_.created_by AS created_by_7,
  n0_.updated_by AS updated_by_8
FROM
  norm n0_
ORDER BY
  n0_.code ASC,
  n0_.label ASC,
  n0_.category ASC,
  n0_.type ASC

SELECT n0_.id AS id_0, n0_.category AS category_1, n0_.type AS type_2, n0_.code AS code_3, n0_.label AS label_4, n0_.created_at AS created_at_5, n0_.updated_at AS updated_at_6, n0_.created_by AS created_by_7, n0_.updated_by AS updated_by_8 FROM norm n0_ ORDER BY n0_.code ASC, n0_.label ASC, n0_.category ASC, n0_.type ASC;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.level AS level_2,
  s0_.formatted_unique AS formatted_unique_3,
  s0_.created_at AS created_at_4,
  s0_.updated_at AS updated_at_5,
  s0_.skill_parent_id AS skill_parent_id_6,
  s0_.created_by AS created_by_7,
  s0_.updated_by AS updated_by_8
FROM
  skill s0_
WHERE
  s0_.level = ?

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.level AS level_2, s0_.formatted_unique AS formatted_unique_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5, s0_.skill_parent_id AS skill_parent_id_6, s0_.created_by AS created_by_7, s0_.updated_by AS updated_by_8 FROM skill s0_ WHERE s0_.level = 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.level AS level_3,
  t0.formatted_unique AS formatted_unique_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.skill_parent_id AS skill_parent_id_7,
  t8.id AS id_9,
  t8.name AS name_10,
  t8.level AS level_11,
  t8.formatted_unique AS formatted_unique_12,
  t8.created_at AS created_at_13,
  t8.updated_at AS updated_at_14,
  t8.skill_parent_id AS skill_parent_id_15,
  t8.created_by AS created_by_16,
  t8.updated_by AS updated_by_17,
  t0.created_by AS created_by_18,
  t0.updated_by AS updated_by_19
FROM
  skill t0
  LEFT JOIN skill t8 ON t0.skill_parent_id = t8.id
WHERE
  t0.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.level AS level_3, t0.formatted_unique AS formatted_unique_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.skill_parent_id AS skill_parent_id_7, t8.id AS id_9, t8.name AS name_10, t8.level AS level_11, t8.formatted_unique AS formatted_unique_12, t8.created_at AS created_at_13, t8.updated_at AS updated_at_14, t8.skill_parent_id AS skill_parent_id_15, t8.created_by AS created_by_16, t8.updated_by AS updated_by_17, t0.created_by AS created_by_18, t0.updated_by AS updated_by_19 FROM skill t0 LEFT JOIN skill t8 ON t0.skill_parent_id = t8.id WHERE t0.id IN (2, 8, 17, 26, 29, 35, 38, 41, 62, 68, 74, 83, 92, 98, 155, 164, 188, 266, 338, 362, 368, 431, 527, 686, 830, 896, 947);

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.fields_display_rules AS fields_display_rules_2,
  p0_.production_mean_category_id AS production_mean_category_id_3
FROM
  production_mean p0_
  INNER JOIN production_mean_category p1_ ON p0_.production_mean_category_id = p1_.id
ORDER BY
  p1_.grouping ASC,
  p1_.name ASC,
  p0_.name ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.fields_display_rules AS fields_display_rules_2, p0_.production_mean_category_id AS production_mean_category_id_3 FROM production_mean p0_ INNER JOIN production_mean_category p1_ ON p0_.production_mean_category_id = p1_.id ORDER BY p1_.grouping ASC, p1_.name ASC, p0_.name ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.grouping AS grouping_3
FROM
  production_mean_category t0
WHERE
  t0.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.grouping AS grouping_3 FROM production_mean_category t0 WHERE t0.id IN (1, 2, 3, 4, 37, 38, 39, 40, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36);

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1
FROM
  category c0_
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1 FROM category c0_ ORDER BY c0_.name ASC;

SELECT
  p0_.id AS id_0,
  p0_.value AS value_1,
  p0_.`order` AS order_2,
  p0_.created_at AS created_at_3,
  p0_.updated_at AS updated_at_4,
  p0_.deleted_at AS deleted_at_5,
  p0_.parent AS parent_6,
  p0_.discr AS discr_7,
  p0_.created_by AS created_by_8,
  p0_.updated_by AS updated_by_9
FROM
  param p0_
WHERE
  (
    (
      p0_.discr IN ('marche')
    )
    AND (p0_.deleted_at IS NULL)
  )
  AND p0_.discr IN (
    'marche', 'serie', 'matiere_travaille'
  )
ORDER BY
  p0_.value ASC

SELECT p0_.id AS id_0, p0_.value AS value_1, p0_.`order` AS order_2, p0_.created_at AS created_at_3, p0_.updated_at AS updated_at_4, p0_.deleted_at AS deleted_at_5, p0_.parent AS parent_6, p0_.discr AS discr_7, p0_.created_by AS created_by_8, p0_.updated_by AS updated_by_9 FROM param p0_ WHERE ((p0_.discr IN ('marche')) AND (p0_.deleted_at IS NULL)) AND p0_.discr IN ('marche', 'serie', 'matiere_travaille') ORDER BY p0_.value ASC;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.siret AS siret_2,
  c0_.address AS address_3,
  c0_.zip AS zip_4,
  c0_.city AS city_5,
  c0_.website AS website_6,
  c0_.email AS email_7,
  c0_.phone AS phone_8,
  c0_.logo AS logo_9,
  c0_.job AS job_10,
  c0_.turnover AS turnover_11,
  c0_.headcount AS headcount_12,
  c0_.founded_at AS founded_at_13,
  c0_.last_visit_at AS last_visit_at_14,
  c0_.characteristics AS characteristics_15,
  c0_.is_project_management AS is_project_management_16,
  c0_.comment AS comment_17,
  c0_.free_text AS free_text_18,
  c0_.contact_firstname AS contact_firstname_19,
  c0_.contact_lastname AS contact_lastname_20,
  c0_.contact_function AS contact_function_21,
  c0_.contact_email AS contact_email_22,
  c0_.contact_phone AS contact_phone_23,
  c0_.is_active AS is_active_24,
  c0_.is_valid AS is_valid_25,
  c0_.valid_at AS valid_at_26,
  c0_.value_proposition AS value_proposition_27,
  c0_.created_at AS created_at_28,
  c0_.updated_at AS updated_at_29,
  c0_.deleted_at AS deleted_at_30,
  p1_.id AS id_31,
  p1_.value AS value_32,
  p1_.`order` AS order_33,
  p1_.created_at AS created_at_34,
  p1_.updated_at AS updated_at_35,
  p1_.deleted_at AS deleted_at_36,
  p1_.parent AS parent_37,
  c0_.created_by AS created_by_38,
  c0_.updated_by AS updated_by_39,
  p1_.discr AS discr_40,
  p1_.created_by AS created_by_41,
  p1_.updated_by AS updated_by_42
FROM
  company c0_
  LEFT JOIN company_param c2_ ON c0_.id = c2_.company_id
  LEFT JOIN param p1_ ON p1_.id = c2_.param_id
  AND p1_.discr IN (
    'marche', 'serie', 'matiere_travaille'
  )
  AND (p1_.deleted_at IS NULL)
WHERE
  (c0_.is_active LIKE ?)
  AND (c0_.deleted_at IS NULL)
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.siret AS siret_2, c0_.address AS address_3, c0_.zip AS zip_4, c0_.city AS city_5, c0_.website AS website_6, c0_.email AS email_7, c0_.phone AS phone_8, c0_.logo AS logo_9, c0_.job AS job_10, c0_.turnover AS turnover_11, c0_.headcount AS headcount_12, c0_.founded_at AS founded_at_13, c0_.last_visit_at AS last_visit_at_14, c0_.characteristics AS characteristics_15, c0_.is_project_management AS is_project_management_16, c0_.comment AS comment_17, c0_.free_text AS free_text_18, c0_.contact_firstname AS contact_firstname_19, c0_.contact_lastname AS contact_lastname_20, c0_.contact_function AS contact_function_21, c0_.contact_email AS contact_email_22, c0_.contact_phone AS contact_phone_23, c0_.is_active AS is_active_24, c0_.is_valid AS is_valid_25, c0_.valid_at AS valid_at_26, c0_.value_proposition AS value_proposition_27, c0_.created_at AS created_at_28, c0_.updated_at AS updated_at_29, c0_.deleted_at AS deleted_at_30, p1_.id AS id_31, p1_.value AS value_32, p1_.`order` AS order_33, p1_.created_at AS created_at_34, p1_.updated_at AS updated_at_35, p1_.deleted_at AS deleted_at_36, p1_.parent AS parent_37, c0_.created_by AS created_by_38, c0_.updated_by AS updated_by_39, p1_.discr AS discr_40, p1_.created_by AS created_by_41, p1_.updated_by AS updated_by_42 FROM company c0_ LEFT JOIN company_param c2_ ON c0_.id = c2_.company_id LEFT JOIN param p1_ ON p1_.id = c2_.param_id AND p1_.discr IN ('marche', 'serie', 'matiere_travaille') AND (p1_.deleted_at IS NULL) WHERE (c0_.is_active LIKE '%1%') AND (c0_.deleted_at IS NULL) ORDER BY c0_.name ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  category t0
  INNER JOIN company_category ON t0.id = company_category.category_id
WHERE
  company_category.company_id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM category t0 INNER JOIN company_category ON t0.id = company_category.category_id WHERE company_category.company_id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  category t0
  INNER JOIN company_category ON t0.id = company_category.category_id
WHERE
  company_category.company_id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM category t0 INNER JOIN company_category ON t0.id = company_category.category_id WHERE company_category.company_id = 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  category t0
  INNER JOIN company_category ON t0.id = company_category.category_id
WHERE
  company_category.company_id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM category t0 INNER JOIN company_category ON t0.id = company_category.category_id WHERE company_category.company_id = 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  category t0
  INNER JOIN company_category ON t0.id = company_category.category_id
WHERE
  company_category.company_id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM category t0 INNER JOIN company_category ON t0.id = company_category.category_id WHERE company_category.company_id = 4;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  category t0
  INNER JOIN company_category ON t0.id = company_category.category_id
WHERE
  company_category.company_id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM category t0 INNER JOIN company_category ON t0.id = company_category.category_id WHERE company_category.company_id = 5;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  category t0
  INNER JOIN company_category ON t0.id = company_category.category_id
WHERE
  company_category.company_id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM category t0 INNER JOIN company_category ON t0.id = company_category.category_id WHERE company_category.company_id = 6;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  category t0
  INNER JOIN company_category ON t0.id = company_category.category_id
WHERE
  company_category.company_id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM category t0 INNER JOIN company_category ON t0.id = company_category.category_id WHERE company_category.company_id = 7;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  category t0
  INNER JOIN company_category ON t0.id = company_category.category_id
WHERE
  company_category.company_id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM category t0 INNER JOIN company_category ON t0.id = company_category.category_id WHERE company_category.company_id = 8;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  category t0
  INNER JOIN company_category ON t0.id = company_category.category_id
WHERE
  company_category.company_id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM category t0 INNER JOIN company_category ON t0.id = company_category.category_id WHERE company_category.company_id = 9;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  category t0
  INNER JOIN company_category ON t0.id = company_category.category_id
WHERE
  company_category.company_id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM category t0 INNER JOIN company_category ON t0.id = company_category.category_id WHERE company_category.company_id = 10;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  category t0
  INNER JOIN company_category ON t0.id = company_category.category_id
WHERE
  company_category.company_id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM category t0 INNER JOIN company_category ON t0.id = company_category.category_id WHERE company_category.company_id = 11;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  category t0
  INNER JOIN company_category ON t0.id = company_category.category_id
WHERE
  company_category.company_id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM category t0 INNER JOIN company_category ON t0.id = company_category.category_id WHERE company_category.company_id = 12;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  category t0
  INNER JOIN company_category ON t0.id = company_category.category_id
WHERE
  company_category.company_id = ?