Symfony Profiler

SELECT
  t0.firstname AS firstname_1,
  t0.lastname AS lastname_2,
  t0.email AS email_3,
  t0.phone AS phone_4,
  t0.roles AS roles_5,
  t0.password AS password_6,
  t0.id AS id_7,
  t0.lang AS lang_8,
  t0.enabled AS enabled_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.soft_deleted_at AS soft_deleted_at_12
FROM
  "user" t0
WHERE
  t0.id = ?
  AND (
    (t0.soft_deleted_at IS NULL)
  )

SELECT t0.firstname AS firstname_1, t0.lastname AS lastname_2, t0.email AS email_3, t0.phone AS phone_4, t0.roles AS roles_5, t0.password AS password_6, t0.id AS id_7, t0.lang AS lang_8, t0.enabled AS enabled_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.soft_deleted_at AS soft_deleted_at_12 FROM "user" t0 WHERE t0.id = '1ebeac78-ac73-65d8-bf18-19b031cc137f' AND ((t0.soft_deleted_at IS NULL));

SELECT
  DISTINCT e0_.id AS id_0,
  e0_.created_at AS created_at_1
FROM
  ecrf_data_issue e0_
ORDER BY
  e0_.created_at DESC
LIMIT
  20

SELECT DISTINCT e0_.id AS id_0, e0_.created_at AS created_at_1 FROM ecrf_data_issue e0_ ORDER BY e0_.created_at DESC LIMIT 20;

SELECT
  e0_.flags AS flags_0,
  e0_.id AS id_1,
  e0_.created_at AS created_at_2,
  e0_.updated_at AS updated_at_3,
  e0_.visit_id AS visit_id_4,
  e0_.section_id AS section_id_5,
  e0_.element_id AS element_id_6,
  e0_.ecrf_id AS ecrf_id_7
FROM
  ecrf_data_issue e0_
WHERE
  e0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
ORDER BY
  e0_.created_at DESC

SELECT e0_.flags AS flags_0, e0_.id AS id_1, e0_.created_at AS created_at_2, e0_.updated_at AS updated_at_3, e0_.visit_id AS visit_id_4, e0_.section_id AS section_id_5, e0_.element_id AS element_id_6, e0_.ecrf_id AS ecrf_id_7 FROM ecrf_data_issue e0_ WHERE e0_.id IN ('1f0ebb87-f6b6-6744-bbab-7b4477a89f9e', '1f0ebb77-17f5-6b64-8308-7b4477a89f9e', '1f0ebb77-18f0-6c58-a969-7b4477a89f9e', '1f0ebb76-55dd-6bee-8965-7b4477a89f9e', '1f0ebb76-543c-6d4e-93fc-7b4477a89f9e', '1f0ebb75-9076-69f0-a4b1-7b4477a89f9e', '1f0ebb75-9297-669e-ab7a-7b4477a89f9e', '1f0ebb75-7a3b-62c6-a05f-7b4477a89f9e', '1f0ebb75-77fe-6ab2-9850-7b4477a89f9e', '1f0ebb75-5dfc-6786-b19e-7b4477a89f9e', '1f0ebb75-5ca5-6dba-85be-7b4477a89f9e', '1f0ebb75-4c10-62b6-8194-7b4477a89f9e', '1f0ebb75-40c9-6830-9079-7b4477a89f9e', '1f0ebb75-40f5-6516-acb8-7b4477a89f9e', '1f0ebb75-411f-60f0-923b-7b4477a89f9e', '1f0ebb75-41a7-66bc-9f66-7b4477a89f9e', '1f0ebb75-41c7-68cc-a722-7b4477a89f9e', '1f0ebb75-42a6-6a90-b7fd-7b4477a89f9e', '1f0ebb75-42aa-6e7e-afe2-7b4477a89f9e', '1f0ebb75-440a-612a-b93a-7b4477a89f9e') ORDER BY e0_.created_at DESC;

SELECT
  count(*) AS sclr_0
FROM
  ecrf_data_issue e0_

SELECT count(*) AS sclr_0 FROM ecrf_data_issue e0_;

SELECT
  t0.name AS name_1,
  t0.type AS type_2,
  t0.id AS id_3,
  t0.position AS position_4,
  t0.period AS period_5,
  t0.enabled AS enabled_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.research_id AS research_id_9
FROM
  visit t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.type AS type_2, t0.id AS id_3, t0.position AS position_4, t0.period AS period_5, t0.enabled AS enabled_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.research_id AS research_id_9 FROM visit t0 WHERE t0.id = '1ebeac78-9ea5-6938-9ae9-19b031cc137f';

SELECT
  t0.type AS type_1,
  t0.id AS id_2,
  t0.name AS name_3,
  t0.position AS position_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.parent_id AS parent_id_7,
  t0.visit_id AS visit_id_8
FROM
  section t0
WHERE
  t0.id = ?

SELECT t0.type AS type_1, t0.id AS id_2, t0.name AS name_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.parent_id AS parent_id_7, t0.visit_id AS visit_id_8 FROM section t0 WHERE t0.id = '1ebf1149-f789-6c94-baca-036d2cb24785';

SELECT
  t0.title AS title_1,
  t0.label AS label_2,
  t0.options AS options_3,
  t0.helper AS helper_4,
  t0.id AS id_5,
  t0.name AS name_6,
  t0.external AS external_7,
  t0.position AS position_8,
  t0.roles AS roles_9,
  t0.type AS type_10,
  t0.enabled AS enabled_11,
  t0.required AS required_12,
  t0.start_at AS start_at_13,
  t0.end_at AS end_at_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.section_id AS section_id_17,
  t0.template_id AS template_id_18,
  t0.query_id AS query_id_19
FROM
  element t0
WHERE
  t0.id = ?

SELECT t0.title AS title_1, t0.label AS label_2, t0.options AS options_3, t0.helper AS helper_4, t0.id AS id_5, t0.name AS name_6, t0.external AS external_7, t0.position AS position_8, t0.roles AS roles_9, t0.type AS type_10, t0.enabled AS enabled_11, t0.required AS required_12, t0.start_at AS start_at_13, t0.end_at AS end_at_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.section_id AS section_id_17, t0.template_id AS template_id_18, t0.query_id AS query_id_19 FROM element t0 WHERE t0.id = '1ed925fb-1f07-6020-be0e-33f53b83b3c3';

SELECT
  COUNT(*)
FROM
  ecrf_data_issue t0
WHERE
  t0.element_id = ?

SELECT COUNT(*) FROM ecrf_data_issue t0 WHERE t0.element_id = '1f0ebb87-f6b6-6744-bbab-7b4477a89f9e';

SELECT
  t0.random_id AS random_id_1,
  t0.random_at AS random_at_2,
  t0.participant_number AS participant_number_3,
  t0.status AS status_4,
  t0.state AS state_5,
  t0.id AS id_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.form_id AS form_id_9,
  t0.drug_group_id AS drug_group_id_10,
  t0.drug_management_id AS drug_management_id_11,
  t0.medical_center_id AS medical_center_id_12,
  t0.research_id AS research_id_13,
  t0.subject_id AS subject_id_14,
  t0.owner_id AS owner_id_15
FROM
  ecrf t0
WHERE
  t0.id = ?

SELECT t0.random_id AS random_id_1, t0.random_at AS random_at_2, t0.participant_number AS participant_number_3, t0.status AS status_4, t0.state AS state_5, t0.id AS id_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.form_id AS form_id_9, t0.drug_group_id AS drug_group_id_10, t0.drug_management_id AS drug_management_id_11, t0.medical_center_id AS medical_center_id_12, t0.research_id AS research_id_13, t0.subject_id AS subject_id_14, t0.owner_id AS owner_id_15 FROM ecrf t0 WHERE t0.id = '1ecb4b94-56cb-6168-be29-199a50de2087';

SELECT
  t0.number AS number_1,
  t0.email AS email_2,
  t0.phone AS phone_3,
  t0.latitude AS latitude_4,
  t0.longitude AS longitude_5,
  t0.status AS status_6,
  t0.id AS id_7,
  t0.name AS name_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.soft_deleted_at AS soft_deleted_at_11,
  t0.address_id AS address_id_12
FROM
  medical_center t0
WHERE
  t0.id = ?

SELECT t0.number AS number_1, t0.email AS email_2, t0.phone AS phone_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.status AS status_6, t0.id AS id_7, t0.name AS name_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.soft_deleted_at AS soft_deleted_at_11, t0.address_id AS address_id_12 FROM medical_center t0 WHERE t0.id = '1ec41fe7-b54e-6878-82cb-d35fedc398aa';

SELECT
  t0.data AS data_1,
  t0.id AS id_2,
  t0.status AS status_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.element_id AS element_id_6,
  t0.ecrf_id AS ecrf_id_7,
  t0.parent_id AS parent_id_8,
  t0.comment_id AS comment_id_9,
  t0.owner_id AS owner_id_10
FROM
  element_data t0
  INNER JOIN ecrf_data_issue_element_data ON t0.id = ecrf_data_issue_element_data.element_data_id
WHERE
  ecrf_data_issue_element_data.ecrf_data_issue_id = ?

SELECT t0.data AS data_1, t0.id AS id_2, t0.status AS status_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.element_id AS element_id_6, t0.ecrf_id AS ecrf_id_7, t0.parent_id AS parent_id_8, t0.comment_id AS comment_id_9, t0.owner_id AS owner_id_10 FROM element_data t0 INNER JOIN ecrf_data_issue_element_data ON t0.id = ecrf_data_issue_element_data.element_data_id WHERE ecrf_data_issue_element_data.ecrf_data_issue_id = '1f0ebb87-f6b6-6744-bbab-7b4477a89f9e';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.position AS position_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.soft_deleted_at AS soft_deleted_at_6
FROM
  element_data_collection t0
  INNER JOIN ecrf_data_issue_element_data_collection ON t0.id = ecrf_data_issue_element_data_collection.element_data_collection_id
WHERE
  ecrf_data_issue_element_data_collection.ecrf_data_issue_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.soft_deleted_at AS soft_deleted_at_6 FROM element_data_collection t0 INNER JOIN ecrf_data_issue_element_data_collection ON t0.id = ecrf_data_issue_element_data_collection.element_data_collection_id WHERE ecrf_data_issue_element_data_collection.ecrf_data_issue_id = '1f0ebb87-f6b6-6744-bbab-7b4477a89f9e';

SELECT
  t0.name AS name_1,
  t0.type AS type_2,
  t0.id AS id_3,
  t0.position AS position_4,
  t0.period AS period_5,
  t0.enabled AS enabled_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.research_id AS research_id_9
FROM
  visit t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.type AS type_2, t0.id AS id_3, t0.position AS position_4, t0.period AS period_5, t0.enabled AS enabled_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.research_id AS research_id_9 FROM visit t0 WHERE t0.id = '1ebeac78-9ea6-6982-91d7-19b031cc137f';

SELECT
  t0.type AS type_1,
  t0.id AS id_2,
  t0.name AS name_3,
  t0.position AS position_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.parent_id AS parent_id_7,
  t0.visit_id AS visit_id_8
FROM
  section t0
WHERE
  t0.id = ?

SELECT t0.type AS type_1, t0.id AS id_2, t0.name AS name_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.parent_id AS parent_id_7, t0.visit_id AS visit_id_8 FROM section t0 WHERE t0.id = '1ecd8051-01d0-66f6-80bc-9f90300e29d9';

SELECT
  t0.title AS title_1,
  t0.label AS label_2,
  t0.options AS options_3,
  t0.helper AS helper_4,
  t0.id AS id_5,
  t0.name AS name_6,
  t0.external AS external_7,
  t0.position AS position_8,
  t0.roles AS roles_9,
  t0.type AS type_10,
  t0.enabled AS enabled_11,
  t0.required AS required_12,
  t0.start_at AS start_at_13,
  t0.end_at AS end_at_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.section_id AS section_id_17,
  t0.template_id AS template_id_18,
  t0.query_id AS query_id_19
FROM
  element t0
WHERE
  t0.id = ?

SELECT t0.title AS title_1, t0.label AS label_2, t0.options AS options_3, t0.helper AS helper_4, t0.id AS id_5, t0.name AS name_6, t0.external AS external_7, t0.position AS position_8, t0.roles AS roles_9, t0.type AS type_10, t0.enabled AS enabled_11, t0.required AS required_12, t0.start_at AS start_at_13, t0.end_at AS end_at_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.section_id AS section_id_17, t0.template_id AS template_id_18, t0.query_id AS query_id_19 FROM element t0 WHERE t0.id = '1ecd8051-01d2-61fe-aed3-9f90300e29d9';

SELECT
  COUNT(*)
FROM
  ecrf_data_issue t0
WHERE
  t0.element_id = ?

SELECT COUNT(*) FROM ecrf_data_issue t0 WHERE t0.element_id = '1f0ebb77-18f0-6c58-a969-7b4477a89f9e';

SELECT
  t0.random_id AS random_id_1,
  t0.random_at AS random_at_2,
  t0.participant_number AS participant_number_3,
  t0.status AS status_4,
  t0.state AS state_5,
  t0.id AS id_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.form_id AS form_id_9,
  t0.drug_group_id AS drug_group_id_10,
  t0.drug_management_id AS drug_management_id_11,
  t0.medical_center_id AS medical_center_id_12,
  t0.research_id AS research_id_13,
  t0.subject_id AS subject_id_14,
  t0.owner_id AS owner_id_15
FROM
  ecrf t0
WHERE
  t0.id = ?

SELECT t0.random_id AS random_id_1, t0.random_at AS random_at_2, t0.participant_number AS participant_number_3, t0.status AS status_4, t0.state AS state_5, t0.id AS id_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.form_id AS form_id_9, t0.drug_group_id AS drug_group_id_10, t0.drug_management_id AS drug_management_id_11, t0.medical_center_id AS medical_center_id_12, t0.research_id AS research_id_13, t0.subject_id AS subject_id_14, t0.owner_id AS owner_id_15 FROM ecrf t0 WHERE t0.id = '1edaed28-69e1-62da-94b6-5f78fc85c17c';

SELECT
  t0.number AS number_1,
  t0.email AS email_2,
  t0.phone AS phone_3,
  t0.latitude AS latitude_4,
  t0.longitude AS longitude_5,
  t0.status AS status_6,
  t0.id AS id_7,
  t0.name AS name_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.soft_deleted_at AS soft_deleted_at_11,
  t0.address_id AS address_id_12
FROM
  medical_center t0
WHERE
  t0.id = ?

SELECT t0.number AS number_1, t0.email AS email_2, t0.phone AS phone_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.status AS status_6, t0.id AS id_7, t0.name AS name_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.soft_deleted_at AS soft_deleted_at_11, t0.address_id AS address_id_12 FROM medical_center t0 WHERE t0.id = '1ec47878-7386-638e-ab50-edbd32642220';

SELECT
  t0.data AS data_1,
  t0.id AS id_2,
  t0.status AS status_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.element_id AS element_id_6,
  t0.ecrf_id AS ecrf_id_7,
  t0.parent_id AS parent_id_8,
  t0.comment_id AS comment_id_9,
  t0.owner_id AS owner_id_10
FROM
  element_data t0
  INNER JOIN ecrf_data_issue_element_data ON t0.id = ecrf_data_issue_element_data.element_data_id
WHERE
  ecrf_data_issue_element_data.ecrf_data_issue_id = ?

SELECT t0.data AS data_1, t0.id AS id_2, t0.status AS status_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.element_id AS element_id_6, t0.ecrf_id AS ecrf_id_7, t0.parent_id AS parent_id_8, t0.comment_id AS comment_id_9, t0.owner_id AS owner_id_10 FROM element_data t0 INNER JOIN ecrf_data_issue_element_data ON t0.id = ecrf_data_issue_element_data.element_data_id WHERE ecrf_data_issue_element_data.ecrf_data_issue_id = '1f0ebb77-18f0-6c58-a969-7b4477a89f9e';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.position AS position_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.soft_deleted_at AS soft_deleted_at_6
FROM
  element_data_collection t0
  INNER JOIN ecrf_data_issue_element_data_collection ON t0.id = ecrf_data_issue_element_data_collection.element_data_collection_id
WHERE
  ecrf_data_issue_element_data_collection.ecrf_data_issue_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.soft_deleted_at AS soft_deleted_at_6 FROM element_data_collection t0 INNER JOIN ecrf_data_issue_element_data_collection ON t0.id = ecrf_data_issue_element_data_collection.element_data_collection_id WHERE ecrf_data_issue_element_data_collection.ecrf_data_issue_id = '1f0ebb77-18f0-6c58-a969-7b4477a89f9e';

SELECT
  COUNT(*)
FROM
  ecrf_data_issue t0
WHERE
  t0.element_id = ?

SELECT COUNT(*) FROM ecrf_data_issue t0 WHERE t0.element_id = '1f0ebb77-17f5-6b64-8308-7b4477a89f9e';

SELECT
  t0.random_id AS random_id_1,
  t0.random_at AS random_at_2,
  t0.participant_number AS participant_number_3,
  t0.status AS status_4,
  t0.state AS state_5,
  t0.id AS id_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.form_id AS form_id_9,
  t0.drug_group_id AS drug_group_id_10,
  t0.drug_management_id AS drug_management_id_11,
  t0.medical_center_id AS medical_center_id_12,
  t0.research_id AS research_id_13,
  t0.subject_id AS subject_id_14,
  t0.owner_id AS owner_id_15
FROM
  ecrf t0
WHERE
  t0.id = ?

SELECT t0.random_id AS random_id_1, t0.random_at AS random_at_2, t0.participant_number AS participant_number_3, t0.status AS status_4, t0.state AS state_5, t0.id AS id_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.form_id AS form_id_9, t0.drug_group_id AS drug_group_id_10, t0.drug_management_id AS drug_management_id_11, t0.medical_center_id AS medical_center_id_12, t0.research_id AS research_id_13, t0.subject_id AS subject_id_14, t0.owner_id AS owner_id_15 FROM ecrf t0 WHERE t0.id = '1ed513e6-7e1e-648a-a7e2-fb7b6dc4bcff';