Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.message_info AS message_info_2,
  t0.params AS params_3,
  t0.created AS created_4,
  t0.start AS start_5,
  t0.end AS end_6,
  t0.message_error AS message_error_7,
  t0.environment_id AS environment_id_8,
  t0.project_id AS project_id_9,
  t0.type_id AS type_id_10,
  t0.status_id AS status_id_11,
  t0.server_id AS server_id_12,
  t0.who_id AS who_id_13
FROM
  job t0
WHERE
  t0.environment_id = ?
ORDER BY
  t0.id DESC

SELECT t0.id AS id_1, t0.message_info AS message_info_2, t0.params AS params_3, t0.created AS created_4, t0.start AS start_5, t0.end AS end_6, t0.message_error AS message_error_7, t0.environment_id AS environment_id_8, t0.project_id AS project_id_9, t0.type_id AS type_id_10, t0.status_id AS status_id_11, t0.server_id AS server_id_12, t0.who_id AS who_id_13 FROM job t0 WHERE t0.environment_id = 931 ORDER BY t0.id DESC;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.website AS website_3,
  t0.preferred_language AS preferred_language_4,
  t0.other_languages AS other_languages_5,
  t0.platforms AS platforms_6,
  t0.teams_tenant_id AS teams_tenant_id_7,
  t0.teams_client_secret AS teams_client_secret_8,
  t0.token AS token_9,
  t0.created AS created_10,
  t0.updated AS updated_11,
  t0.subscription AS subscription_12,
  t0.plan AS plan_13,
  t0.company AS company_14,
  t0.project_id AS project_id_15
FROM
  azure_marketplace t0
WHERE
  t0.project_id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.website AS website_3, t0.preferred_language AS preferred_language_4, t0.other_languages AS other_languages_5, t0.platforms AS platforms_6, t0.teams_tenant_id AS teams_tenant_id_7, t0.teams_client_secret AS teams_client_secret_8, t0.token AS token_9, t0.created AS created_10, t0.updated AS updated_11, t0.subscription AS subscription_12, t0.plan AS plan_13, t0.company AS company_14, t0.project_id AS project_id_15 FROM azure_marketplace t0 WHERE t0.project_id = 467;

SELECT
  t0.id AS id_1,
  t0.api_key AS api_key_2,
  t0.username AS username_3,
  t0.roles AS roles_4,
  t0.project_id AS project_id_5
FROM
  api_users t0
WHERE
  t0.project_id = ?

SELECT t0.id AS id_1, t0.api_key AS api_key_2, t0.username AS username_3, t0.roles AS roles_4, t0.project_id AS project_id_5 FROM api_users t0 WHERE t0.project_id = 467;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.params AS params_4,
  t0.config_group_id AS config_group_id_5
FROM
  config t0
  INNER JOIN deploy_tag_config ON t0.id = deploy_tag_config.config_id
WHERE
  deploy_tag_config.deploy_tag_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.params AS params_4, t0.config_group_id AS config_group_id_5 FROM config t0 INNER JOIN deploy_tag_config ON t0.id = deploy_tag_config.config_id WHERE deploy_tag_config.deploy_tag_id = 636962;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.params AS params_4,
  t0.config_group_id AS config_group_id_5
FROM
  config t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.params AS params_4, t0.config_group_id AS config_group_id_5 FROM config t0 WHERE t0.id = 52;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.note AS note_3,
  t0.project_id AS project_id_4,
  t0.environment_id AS environment_id_5
FROM
  deploy_tag t0
WHERE
  t0.project_id = ?
ORDER BY
  t0.name DESC

SELECT t0.id AS id_1, t0.name AS name_2, t0.note AS note_3, t0.project_id AS project_id_4, t0.environment_id AS environment_id_5 FROM deploy_tag t0 WHERE t0.project_id = 431 ORDER BY t0.name DESC;

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.option_type_id AS option_type_id_3,
  t0.environment_id AS environment_id_4
FROM
  environment_option t0
WHERE
  t0.environment_id = ?

SELECT t0.id AS id_1, t0.value AS value_2, t0.option_type_id AS option_type_id_3, t0.environment_id AS environment_id_4 FROM environment_option t0 WHERE t0.environment_id = 931;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.description AS description_2,
  p0_.botname AS botname_3,
  p0_.builds AS builds_4,
  p0_.container_registry_username AS container_registry_username_5,
  p0_.container_registry_password AS container_registry_password_6,
  p0_.slasecret AS slasecret_7,
  p0_.created AS created_8,
  p0_.updated AS updated_9,
  p0_.mobileapp_description AS mobileapp_description_10,
  p0_.mobileapp_intro AS mobileapp_intro_11,
  p0_.bot_identity_name AS bot_identity_name_12,
  p0_.ios_link AS ios_link_13,
  p0_.android_link AS android_link_14,
  p0_.viber_link AS viber_link_15,
  p0_.tempo_team_id AS tempo_team_id_16,
  p0_.type_id AS type_id_17,
  p0_.sla_id AS sla_id_18,
  p0_.dev_company_id AS dev_company_id_19
FROM
  project p0_

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.botname AS botname_3, p0_.builds AS builds_4, p0_.container_registry_username AS container_registry_username_5, p0_.container_registry_password AS container_registry_password_6, p0_.slasecret AS slasecret_7, p0_.created AS created_8, p0_.updated AS updated_9, p0_.mobileapp_description AS mobileapp_description_10, p0_.mobileapp_intro AS mobileapp_intro_11, p0_.bot_identity_name AS bot_identity_name_12, p0_.ios_link AS ios_link_13, p0_.android_link AS android_link_14, p0_.viber_link AS viber_link_15, p0_.tempo_team_id AS tempo_team_id_16, p0_.type_id AS type_id_17, p0_.sla_id AS sla_id_18, p0_.dev_company_id AS dev_company_id_19 FROM project p0_;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.params AS params_4,
  t0.config_group_id AS config_group_id_5
FROM
  config t0
WHERE
  t0.config_group_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.params AS params_4, t0.config_group_id AS config_group_id_5 FROM config t0 WHERE t0.config_group_id = 13;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.value AS value_2,
  c0_.params AS params_3,
  c0_.config_group_id AS config_group_id_4
FROM
  config c0_
WHERE
  c0_.config_group_id = 16
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.value AS value_2, c0_.params AS params_3, c0_.config_group_id AS config_group_id_4 FROM config c0_ WHERE c0_.config_group_id = 16 ORDER BY c0_.name ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  config_group t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM config_group t0 WHERE t0.id = 6;

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3 FROM user t0 WHERE t0.id = 86;

SELECT
  d0_.id AS id_0,
  d0_.file_name AS file_name_1,
  d0_.note AS note_2,
  d0_.date AS date_3,
  d0_.is_global AS is_global_4,
  d0_.cloud_type AS cloud_type_5,
  d0_.server_id AS server_id_6,
  d0_.project_id AS project_id_7
FROM
  db_imp_exp d0_
WHERE
  d0_.is_global = 1
ORDER BY
  d0_.date ASC

SELECT d0_.id AS id_0, d0_.file_name AS file_name_1, d0_.note AS note_2, d0_.date AS date_3, d0_.is_global AS is_global_4, d0_.cloud_type AS cloud_type_5, d0_.server_id AS server_id_6, d0_.project_id AS project_id_7 FROM db_imp_exp d0_ WHERE d0_.is_global = 1 ORDER BY d0_.date ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.params AS params_4,
  t0.config_group_id AS config_group_id_5
FROM
  config t0
  INNER JOIN environment_config ON t0.id = environment_config.config_id
WHERE
  environment_config.environment_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.params AS params_4, t0.config_group_id AS config_group_id_5 FROM config t0 INNER JOIN environment_config ON t0.id = environment_config.config_id WHERE environment_config.environment_id = 931;

SELECT
  count(DISTINCT e0_.id) AS sclr_0
FROM
  environment e0_
  LEFT JOIN project p1_ ON e0_.project_id = p1_.id
  LEFT JOIN environment_type e2_ ON e0_.type_id = e2_.id
WHERE
  p1_.id IN (?)

SELECT count(DISTINCT e0_.id) AS sclr_0 FROM environment e0_ LEFT JOIN project p1_ ON e0_.project_id = p1_.id LEFT JOIN environment_type e2_ ON e0_.type_id = e2_.id WHERE p1_.id IN (467);

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.value AS value_2,
  c0_.params AS params_3,
  c0_.config_group_id AS config_group_id_4
FROM
  config c0_
WHERE
  c0_.config_group_id = 5
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.value AS value_2, c0_.params AS params_3, c0_.config_group_id AS config_group_id_4 FROM config c0_ WHERE c0_.config_group_id = 5 ORDER BY c0_.name ASC;

SELECT
  t0.id AS id_1,
  t0.file_name AS file_name_2,
  t0.note AS note_3,
  t0.date AS date_4,
  t0.is_global AS is_global_5,
  t0.cloud_type AS cloud_type_6,
  t0.server_id AS server_id_7,
  t0.project_id AS project_id_8
FROM
  db_imp_exp t0
WHERE
  t0.project_id = ?
ORDER BY
  t0.date DESC

SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.note AS note_3, t0.date AS date_4, t0.is_global AS is_global_5, t0.cloud_type AS cloud_type_6, t0.server_id AS server_id_7, t0.project_id AS project_id_8 FROM db_imp_exp t0 WHERE t0.project_id = 467 ORDER BY t0.date DESC;

SELECT
  DISTINCT e0_.id AS id_0,
  e1_.name AS name_1,
  e0_.id AS id_2
FROM
  environment e0_
  LEFT JOIN project p2_ ON e0_.project_id = p2_.id
  LEFT JOIN environment_type e1_ ON e0_.type_id = e1_.id
WHERE
  p2_.id IN (?)
ORDER BY
  e1_.name ASC,
  e0_.id ASC
LIMIT
  25

SELECT DISTINCT e0_.id AS id_0, e1_.name AS name_1, e0_.id AS id_2 FROM environment e0_ LEFT JOIN project p2_ ON e0_.project_id = p2_.id LEFT JOIN environment_type e1_ ON e0_.type_id = e1_.id WHERE p2_.id IN (467) ORDER BY e1_.name ASC, e0_.id ASC LIMIT 25;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.description AS description_2,
  p0_.botname AS botname_3,
  p0_.builds AS builds_4,
  p0_.container_registry_username AS container_registry_username_5,
  p0_.container_registry_password AS container_registry_password_6,
  p0_.slasecret AS slasecret_7,
  p0_.created AS created_8,
  p0_.updated AS updated_9,
  p0_.mobileapp_description AS mobileapp_description_10,
  p0_.mobileapp_intro AS mobileapp_intro_11,
  p0_.bot_identity_name AS bot_identity_name_12,
  p0_.ios_link AS ios_link_13,
  p0_.android_link AS android_link_14,
  p0_.viber_link AS viber_link_15,
  p0_.tempo_team_id AS tempo_team_id_16,
  p0_.type_id AS type_id_17,
  p0_.sla_id AS sla_id_18,
  p0_.dev_company_id AS dev_company_id_19
FROM
  project p0_
WHERE
  p0_.id IN (?)

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.botname AS botname_3, p0_.builds AS builds_4, p0_.container_registry_username AS container_registry_username_5, p0_.container_registry_password AS container_registry_password_6, p0_.slasecret AS slasecret_7, p0_.created AS created_8, p0_.updated AS updated_9, p0_.mobileapp_description AS mobileapp_description_10, p0_.mobileapp_intro AS mobileapp_intro_11, p0_.bot_identity_name AS bot_identity_name_12, p0_.ios_link AS ios_link_13, p0_.android_link AS android_link_14, p0_.viber_link AS viber_link_15, p0_.tempo_team_id AS tempo_team_id_16, p0_.type_id AS type_id_17, p0_.sla_id AS sla_id_18, p0_.dev_company_id AS dev_company_id_19 FROM project p0_ WHERE p0_.id IN ('467');

SELECT
  e0_.id AS id_0,
  e0_.auto_stop AS auto_stop_1,
  e0_.fqdn AS fqdn_2,
  e0_.last_auto_stop_change AS last_auto_stop_change_3,
  e0_.auto_restart AS auto_restart_4,
  e0_.created AS created_5,
  e0_.updated AS updated_6,
  e0_.debug_mode AS debug_mode_7,
  e0_.last_debug_mode_change AS last_debug_mode_change_8,
  e0_.project_id AS project_id_9,
  e0_.type_id AS type_id_10,
  e0_.server_id AS server_id_11,
  e0_.monitoring_id AS monitoring_id_12
FROM
  environment e0_
  LEFT JOIN project p1_ ON e0_.project_id = p1_.id
  LEFT JOIN environment_type e2_ ON e0_.type_id = e2_.id
WHERE
  p1_.id IN (?)
  AND e0_.id IN (?)
ORDER BY
  e2_.name ASC,
  e0_.id ASC

SELECT e0_.id AS id_0, e0_.auto_stop AS auto_stop_1, e0_.fqdn AS fqdn_2, e0_.last_auto_stop_change AS last_auto_stop_change_3, e0_.auto_restart AS auto_restart_4, e0_.created AS created_5, e0_.updated AS updated_6, e0_.debug_mode AS debug_mode_7, e0_.last_debug_mode_change AS last_debug_mode_change_8, e0_.project_id AS project_id_9, e0_.type_id AS type_id_10, e0_.server_id AS server_id_11, e0_.monitoring_id AS monitoring_id_12 FROM environment e0_ LEFT JOIN project p1_ ON e0_.project_id = p1_.id LEFT JOIN environment_type e2_ ON e0_.type_id = e2_.id WHERE p1_.id IN (467) AND e0_.id IN (931) ORDER BY e2_.name ASC, e0_.id ASC;

SELECT
  e0_.id AS id_0,
  e0_.name AS name_1,
  e0_.type_id AS type_id_2
FROM
  environment_type e0_

SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.type_id AS type_id_2 FROM environment_type e0_;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.value AS value_2,
  c0_.params AS params_3,
  c0_.config_group_id AS config_group_id_4
FROM
  config c0_
WHERE
  c0_.config_group_id = 10
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.value AS value_2, c0_.params AS params_3, c0_.config_group_id AS config_group_id_4 FROM config c0_ WHERE c0_.config_group_id = 10 ORDER BY c0_.name ASC;