Symfony Profiler

SELECT
  a0_.id AS id_0,
  a0_.id_cnm AS id_cnm_1,
  a0_.reference4d AS reference4d_2,
  a0_.external_code AS external_code_3,
  a0_.slug AS slug_4,
  a0_.name AS name_5,
  a0_.name_en AS name_en_6,
  a0_.name_feminine AS name_feminine_7,
  a0_.name_reversed AS name_reversed_8,
  a0_.description AS description_9,
  a0_.criteria AS criteria_10,
  a0_.organization AS organization_11,
  a0_.position AS position_12,
  a0_.published AS published_13,
  a1_.id AS id_14,
  a1_.id_cnm AS id_cnm_15,
  a1_.reference4d AS reference4d_16,
  a1_.external_code AS external_code_17,
  a1_.slug AS slug_18,
  a1_.name AS name_19,
  a1_.name_en AS name_en_20,
  a1_.name_feminine AS name_feminine_21,
  a1_.name_reversed AS name_reversed_22,
  a1_.description AS description_23,
  a1_.criteria AS criteria_24,
  a1_.organization AS organization_25,
  a1_.position AS position_26,
  a1_.published AS published_27,
  a2_.id AS id_28,
  a2_.id_cnm AS id_cnm_29,
  a2_.reference4d AS reference4d_30,
  a2_.external_code AS external_code_31,
  a2_.slug AS slug_32,
  a2_.name AS name_33,
  a2_.name_en AS name_en_34,
  a2_.name_feminine AS name_feminine_35,
  a2_.name_reversed AS name_reversed_36,
  a2_.description AS description_37,
  a2_.criteria AS criteria_38,
  a2_.organization AS organization_39,
  a2_.position AS position_40,
  a2_.published AS published_41,
  a0_.thesaurus_id AS thesaurus_id_42,
  a0_.parent AS parent_43,
  a1_.thesaurus_id AS thesaurus_id_44,
  a1_.parent AS parent_45,
  a2_.thesaurus_id AS thesaurus_id_46,
  a2_.parent AS parent_47
FROM
  app_tag a0_
  LEFT JOIN app_tag a1_ ON a0_.parent = a1_.id
  LEFT JOIN app_tag a2_ ON a0_.id = a2_.parent
WHERE
  a0_.thesaurus_id = ?
ORDER BY
  a2_.position ASC

SELECT a0_.id AS id_0, a0_.id_cnm AS id_cnm_1, a0_.reference4d AS reference4d_2, a0_.external_code AS external_code_3, a0_.slug AS slug_4, a0_.name AS name_5, a0_.name_en AS name_en_6, a0_.name_feminine AS name_feminine_7, a0_.name_reversed AS name_reversed_8, a0_.description AS description_9, a0_.criteria AS criteria_10, a0_.organization AS organization_11, a0_.position AS position_12, a0_.published AS published_13, a1_.id AS id_14, a1_.id_cnm AS id_cnm_15, a1_.reference4d AS reference4d_16, a1_.external_code AS external_code_17, a1_.slug AS slug_18, a1_.name AS name_19, a1_.name_en AS name_en_20, a1_.name_feminine AS name_feminine_21, a1_.name_reversed AS name_reversed_22, a1_.description AS description_23, a1_.criteria AS criteria_24, a1_.organization AS organization_25, a1_.position AS position_26, a1_.published AS published_27, a2_.id AS id_28, a2_.id_cnm AS id_cnm_29, a2_.reference4d AS reference4d_30, a2_.external_code AS external_code_31, a2_.slug AS slug_32, a2_.name AS name_33, a2_.name_en AS name_en_34, a2_.name_feminine AS name_feminine_35, a2_.name_reversed AS name_reversed_36, a2_.description AS description_37, a2_.criteria AS criteria_38, a2_.organization AS organization_39, a2_.position AS position_40, a2_.published AS published_41, a0_.thesaurus_id AS thesaurus_id_42, a0_.parent AS parent_43, a1_.thesaurus_id AS thesaurus_id_44, a1_.parent AS parent_45, a2_.thesaurus_id AS thesaurus_id_46, a2_.parent AS parent_47 FROM app_tag a0_ LEFT JOIN app_tag a1_ ON a0_.parent = a1_.id LEFT JOIN app_tag a2_ ON a0_.id = a2_.parent WHERE a0_.thesaurus_id = 104 ORDER BY a2_.position ASC;

SELECT
  a0_.id AS id_0,
  a0_.slug AS slug_1,
  a0_.name AS name_2,
  a0_.type AS type_3,
  a0_.has_auto_positions AS has_auto_positions_4,
  a0_.has_last_level AS has_last_level_5,
  a1_.id AS id_6,
  a1_.id_cnm AS id_cnm_7,
  a1_.reference4d AS reference4d_8,
  a1_.external_code AS external_code_9,
  a1_.slug AS slug_10,
  a1_.name AS name_11,
  a1_.name_en AS name_en_12,
  a1_.name_feminine AS name_feminine_13,
  a1_.name_reversed AS name_reversed_14,
  a1_.description AS description_15,
  a1_.criteria AS criteria_16,
  a1_.organization AS organization_17,
  a1_.position AS position_18,
  a1_.published AS published_19,
  a2_.id AS id_20,
  a2_.id_cnm AS id_cnm_21,
  a2_.reference4d AS reference4d_22,
  a2_.external_code AS external_code_23,
  a2_.slug AS slug_24,
  a2_.name AS name_25,
  a2_.name_en AS name_en_26,
  a2_.name_feminine AS name_feminine_27,
  a2_.name_reversed AS name_reversed_28,
  a2_.description AS description_29,
  a2_.criteria AS criteria_30,
  a2_.organization AS organization_31,
  a2_.position AS position_32,
  a2_.published AS published_33,
  a1_.thesaurus_id AS thesaurus_id_34,
  a1_.parent AS parent_35,
  a2_.thesaurus_id AS thesaurus_id_36,
  a2_.parent AS parent_37
FROM
  app_thesaurus a0_
  LEFT JOIN app_tag a1_ ON a0_.id = a1_.thesaurus_id
  LEFT JOIN app_tag a2_ ON a1_.parent = a2_.id
WHERE
  a0_.id = ?
ORDER BY
  a1_.name ASC,
  a1_.position ASC

SELECT a0_.id AS id_0, a0_.slug AS slug_1, a0_.name AS name_2, a0_.type AS type_3, a0_.has_auto_positions AS has_auto_positions_4, a0_.has_last_level AS has_last_level_5, a1_.id AS id_6, a1_.id_cnm AS id_cnm_7, a1_.reference4d AS reference4d_8, a1_.external_code AS external_code_9, a1_.slug AS slug_10, a1_.name AS name_11, a1_.name_en AS name_en_12, a1_.name_feminine AS name_feminine_13, a1_.name_reversed AS name_reversed_14, a1_.description AS description_15, a1_.criteria AS criteria_16, a1_.organization AS organization_17, a1_.position AS position_18, a1_.published AS published_19, a2_.id AS id_20, a2_.id_cnm AS id_cnm_21, a2_.reference4d AS reference4d_22, a2_.external_code AS external_code_23, a2_.slug AS slug_24, a2_.name AS name_25, a2_.name_en AS name_en_26, a2_.name_feminine AS name_feminine_27, a2_.name_reversed AS name_reversed_28, a2_.description AS description_29, a2_.criteria AS criteria_30, a2_.organization AS organization_31, a2_.position AS position_32, a2_.published AS published_33, a1_.thesaurus_id AS thesaurus_id_34, a1_.parent AS parent_35, a2_.thesaurus_id AS thesaurus_id_36, a2_.parent AS parent_37 FROM app_thesaurus a0_ LEFT JOIN app_tag a1_ ON a0_.id = a1_.thesaurus_id LEFT JOIN app_tag a2_ ON a1_.parent = a2_.id WHERE a0_.id = 104 ORDER BY a1_.name ASC, a1_.position ASC;

SELECT
  COUNT(*)
FROM
  app_task t0
WHERE
  t0.status IN (?, ?)

SELECT COUNT(*) FROM app_task t0 WHERE t0.status IN ('new', 'running');

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.name AS name_3,
  t0.service AS service_4,
  t0.url AS url_5,
  t0.last_update AS last_update_6
FROM
  app_api t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.service AS service_4, t0.url AS url_5, t0.last_update AS last_update_6 FROM app_api t0 WHERE t0.name = 'Pays' LIMIT 1;

SELECT
  COUNT(*)
FROM
  app_api_update t0

SELECT COUNT(*) FROM app_api_update t0;

SELECT
  t0.id AS id_1,
  t0.irmawork_id AS irmawork_id_2,
  t0.username AS username_3,
  t0.slug AS slug_4,
  t0.last_name AS last_name_5,
  t0.first_name AS first_name_6,
  t0.email AS email_7,
  t0.password AS password_8,
  t0.avatar AS avatar_9,
  t0.reset_password AS reset_password_10,
  t0.salt AS salt_11,
  t0.roles AS roles_12,
  t0.is_enabled AS is_enabled_13,
  t0.token AS token_14,
  t0.date_updated AS date_updated_15
FROM
  app_administrator t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.irmawork_id AS irmawork_id_2, t0.username AS username_3, t0.slug AS slug_4, t0.last_name AS last_name_5, t0.first_name AS first_name_6, t0.email AS email_7, t0.password AS password_8, t0.avatar AS avatar_9, t0.reset_password AS reset_password_10, t0.salt AS salt_11, t0.roles AS roles_12, t0.is_enabled AS is_enabled_13, t0.token AS token_14, t0.date_updated AS date_updated_15 FROM app_administrator t0 WHERE t0.id = 55;

SELECT
  COUNT(*)
FROM
  app_suggestion t0
WHERE
  t0.status IN (?)

SELECT COUNT(*) FROM app_suggestion t0 WHERE t0.status IN ('new');