Symfony Profiler

[
  "route" => "dashboard"
  "route_parameters" => [
    "_route" => "dashboard"
    "_controller" => "App\Controller\Admin\Dashboard::index"
  ]
  "request_uri" => "https://api.preprod.refsal.pl/admin?crudAction=index&crudControllerFqcn=App%5CController%5CAdmin%5CEcrf%5CEcrfDataIssueCrud"
  "method" => "GET"
]

[
  "key" => "_security_main"
  "token_class" => "Symfony\Component\Security\Core\Authentication\Token\UsernamePasswordToken"
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_pgsql"
    "idle_connection_ttl" => 600
    "host" => "10.20.60.202"
    "port" => 5432
    "user" => "refsal_preprod"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "refsal_preprod"
    "serverVersion" => "13"
    "charset" => "utf8"
  ]
]

[
  "sql" => "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))"
  "params" => [
    1 => "1ebeac78-ac73-65d8-bf18-19b031cc137f"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "admin@neo-vinci.pl"
]

[
  "firewall_name" => "main"
  "authenticators" => 2
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "sql" => "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"
]

[
  "sql" => "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"
  "params" => [
    1 => "1f0ebb87-f6b6-6744-bbab-7b4477a89f9e"
    2 => "1f0ebb77-17f5-6b64-8308-7b4477a89f9e"
    3 => "1f0ebb77-18f0-6c58-a969-7b4477a89f9e"
    4 => "1f0ebb76-55dd-6bee-8965-7b4477a89f9e"
    5 => "1f0ebb76-543c-6d4e-93fc-7b4477a89f9e"
    6 => "1f0ebb75-9076-69f0-a4b1-7b4477a89f9e"
    7 => "1f0ebb75-9297-669e-ab7a-7b4477a89f9e"
    8 => "1f0ebb75-7a3b-62c6-a05f-7b4477a89f9e"
    9 => "1f0ebb75-77fe-6ab2-9850-7b4477a89f9e"
    10 => "1f0ebb75-5dfc-6786-b19e-7b4477a89f9e"
    11 => "1f0ebb75-5ca5-6dba-85be-7b4477a89f9e"
    12 => "1f0ebb75-4c10-62b6-8194-7b4477a89f9e"
    13 => "1f0ebb75-40c9-6830-9079-7b4477a89f9e"
    14 => "1f0ebb75-40f5-6516-acb8-7b4477a89f9e"
    15 => "1f0ebb75-411f-60f0-923b-7b4477a89f9e"
    16 => "1f0ebb75-41a7-66bc-9f66-7b4477a89f9e"
    17 => "1f0ebb75-41c7-68cc-a722-7b4477a89f9e"
    18 => "1f0ebb75-42a6-6a90-b7fd-7b4477a89f9e"
    19 => "1f0ebb75-42aa-6e7e-afe2-7b4477a89f9e"
    20 => "1f0ebb75-440a-612a-b93a-7b4477a89f9e"
  ]
  "types" => [
    1 => 2
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
    11 => 2
    12 => 2
    13 => 2
    14 => 2
    15 => 2
    16 => 2
    17 => 2
    18 => 2
    19 => 2
    20 => 2
  ]
]

[
  "sql" => "SELECT count(*) AS sclr_0 FROM ecrf_data_issue e0_"
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1ebeac78-9ea5-6938-9ae9-19b031cc137f"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1ebf1149-f789-6c94-baca-036d2cb24785"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1ed925fb-1f07-6020-be0e-33f53b83b3c3"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT COUNT(*) FROM ecrf_data_issue t0 WHERE t0.element_id = ?"
  "params" => [
    1 => "1f0ebb87-f6b6-6744-bbab-7b4477a89f9e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1ecb4b94-56cb-6168-be29-199a50de2087"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1ec41fe7-b54e-6878-82cb-d35fedc398aa"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1f0ebb87-f6b6-6744-bbab-7b4477a89f9e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1f0ebb87-f6b6-6744-bbab-7b4477a89f9e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1ebeac78-9ea6-6982-91d7-19b031cc137f"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1ecd8051-01d0-66f6-80bc-9f90300e29d9"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1ecd8051-01d2-61fe-aed3-9f90300e29d9"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT COUNT(*) FROM ecrf_data_issue t0 WHERE t0.element_id = ?"
  "params" => [
    1 => "1f0ebb77-18f0-6c58-a969-7b4477a89f9e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1edaed28-69e1-62da-94b6-5f78fc85c17c"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1ec47878-7386-638e-ab50-edbd32642220"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1f0ebb77-18f0-6c58-a969-7b4477a89f9e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1f0ebb77-18f0-6c58-a969-7b4477a89f9e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT COUNT(*) FROM ecrf_data_issue t0 WHERE t0.element_id = ?"
  "params" => [
    1 => "1f0ebb77-17f5-6b64-8308-7b4477a89f9e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1ed513e6-7e1e-648a-a7e2-fb7b6dc4bcff"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1f0ebb77-17f5-6b64-8308-7b4477a89f9e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1f0ebb77-17f5-6b64-8308-7b4477a89f9e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1ebeac78-9ea6-67c0-9a50-19b031cc137f"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1ecd804e-63d2-6eec-9395-fdc1e62d03f4"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1ecd804e-63d4-6ba2-8f73-fdc1e62d03f4"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT COUNT(*) FROM ecrf_data_issue t0 WHERE t0.element_id = ?"
  "params" => [
    1 => "1f0ebb76-55dd-6bee-8965-7b4477a89f9e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1f0ebb76-55dd-6bee-8965-7b4477a89f9e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1f0ebb76-55dd-6bee-8965-7b4477a89f9e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT COUNT(*) FROM ecrf_data_issue t0 WHERE t0.element_id = ?"
  "params" => [
    1 => "1f0ebb76-543c-6d4e-93fc-7b4477a89f9e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1f0ebb76-543c-6d4e-93fc-7b4477a89f9e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1f0ebb76-543c-6d4e-93fc-7b4477a89f9e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1ebeac78-9ea6-6608-8dca-19b031cc137f"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1ecd8021-f961-658a-a11e-efd909c96f8e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1ecd8029-5ef2-6ef6-8248-6749a4a3c1c5"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT COUNT(*) FROM ecrf_data_issue t0 WHERE t0.element_id = ?"
  "params" => [
    1 => "1f0ebb75-9076-69f0-a4b1-7b4477a89f9e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1f0ebb75-9076-69f0-a4b1-7b4477a89f9e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1f0ebb75-9076-69f0-a4b1-7b4477a89f9e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT COUNT(*) FROM ecrf_data_issue t0 WHERE t0.element_id = ?"
  "params" => [
    1 => "1f0ebb75-9297-669e-ab7a-7b4477a89f9e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1f0ebb75-9297-669e-ab7a-7b4477a89f9e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1f0ebb75-9297-669e-ab7a-7b4477a89f9e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1ebf51ff-d876-6c16-b0f1-2fe206ac0212"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1ecb3f7a-a718-6772-9053-49ac026a7013"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT COUNT(*) FROM ecrf_data_issue t0 WHERE t0.element_id = ?"
  "params" => [
    1 => "1f0ebb75-7a3b-62c6-a05f-7b4477a89f9e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1f0ebb75-7a3b-62c6-a05f-7b4477a89f9e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1f0ebb75-7a3b-62c6-a05f-7b4477a89f9e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT COUNT(*) FROM ecrf_data_issue t0 WHERE t0.element_id = ?"
  "params" => [
    1 => "1f0ebb75-77fe-6ab2-9850-7b4477a89f9e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1f0ebb75-77fe-6ab2-9850-7b4477a89f9e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1f0ebb75-77fe-6ab2-9850-7b4477a89f9e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1ec0b3db-566c-6c72-841e-657eb08aff69"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1ecb3f79-7e3c-62dc-8fa0-0f7803ea45c0"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT COUNT(*) FROM ecrf_data_issue t0 WHERE t0.element_id = ?"
  "params" => [
    1 => "1f0ebb75-5dfc-6786-b19e-7b4477a89f9e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1f0ebb75-5dfc-6786-b19e-7b4477a89f9e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1f0ebb75-5dfc-6786-b19e-7b4477a89f9e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT COUNT(*) FROM ecrf_data_issue t0 WHERE t0.element_id = ?"
  "params" => [
    1 => "1f0ebb75-5ca5-6dba-85be-7b4477a89f9e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1f0ebb75-5ca5-6dba-85be-7b4477a89f9e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1f0ebb75-5ca5-6dba-85be-7b4477a89f9e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1ebf5195-d164-6f14-83c6-a3aa482e7f89"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1ecb3f78-326e-6068-938a-595e6bdf1e0d"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT COUNT(*) FROM ecrf_data_issue t0 WHERE t0.element_id = ?"
  "params" => [
    1 => "1f0ebb75-4c10-62b6-8194-7b4477a89f9e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1f0ebb75-4c10-62b6-8194-7b4477a89f9e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1f0ebb75-4c10-62b6-8194-7b4477a89f9e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1ebf114c-64cb-640e-96f7-2bbe8c7f0ad4"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1ecb3f76-c158-619a-8ef2-7bf135c2cfef"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT COUNT(*) FROM ecrf_data_issue t0 WHERE t0.element_id = ?"
  "params" => [
    1 => "1f0ebb75-42aa-6e7e-afe2-7b4477a89f9e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1f02f2f6-f208-6626-90fd-d9ae9dd43a14"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1ec4783a-8a18-684c-b6eb-2bc44302992b"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1f0ebb75-42aa-6e7e-afe2-7b4477a89f9e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1f0ebb75-42aa-6e7e-afe2-7b4477a89f9e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT COUNT(*) FROM ecrf_data_issue t0 WHERE t0.element_id = ?"
  "params" => [
    1 => "1f0ebb75-42a6-6a90-b7fd-7b4477a89f9e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1f02f253-950a-61a2-bcfb-eb9f5f56c466"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1ec8b3f7-4eaf-6c72-8c02-adaf61bda56e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1f0ebb75-42a6-6a90-b7fd-7b4477a89f9e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1f0ebb75-42a6-6a90-b7fd-7b4477a89f9e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT COUNT(*) FROM ecrf_data_issue t0 WHERE t0.element_id = ?"
  "params" => [
    1 => "1f0ebb75-41c7-68cc-a722-7b4477a89f9e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1f003372-34fc-6c80-b003-578dcbe743a8"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1f0ebb75-41c7-68cc-a722-7b4477a89f9e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1f0ebb75-41c7-68cc-a722-7b4477a89f9e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT COUNT(*) FROM ecrf_data_issue t0 WHERE t0.element_id = ?"
  "params" => [
    1 => "1f0ebb75-41a7-66bc-9f66-7b4477a89f9e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1effd94d-ce4d-68d2-913b-cf847a51b6f3"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1f0ebb75-41a7-66bc-9f66-7b4477a89f9e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1f0ebb75-41a7-66bc-9f66-7b4477a89f9e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT COUNT(*) FROM ecrf_data_issue t0 WHERE t0.element_id = ?"
  "params" => [
    1 => "1f0ebb75-411f-60f0-923b-7b4477a89f9e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1efe57ea-ae74-628a-826d-158fb2140df9"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1f0ebb75-411f-60f0-923b-7b4477a89f9e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1f0ebb75-411f-60f0-923b-7b4477a89f9e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT COUNT(*) FROM ecrf_data_issue t0 WHERE t0.element_id = ?"
  "params" => [
    1 => "1f0ebb75-40c9-6830-9079-7b4477a89f9e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1efce71a-eda4-614a-8b8a-4b4600dafd38"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1f0ebb75-40c9-6830-9079-7b4477a89f9e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1f0ebb75-40c9-6830-9079-7b4477a89f9e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT COUNT(*) FROM ecrf_data_issue t0 WHERE t0.element_id = ?"
  "params" => [
    1 => "1f0ebb75-40f5-6516-acb8-7b4477a89f9e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1efd9b09-c568-6c6e-897d-e91026091a98"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1f0ebb75-40f5-6516-acb8-7b4477a89f9e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1f0ebb75-40f5-6516-acb8-7b4477a89f9e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT COUNT(*) FROM ecrf_data_issue t0 WHERE t0.element_id = ?"
  "params" => [
    1 => "1f0ebb75-440a-612a-b93a-7b4477a89f9e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1f067962-a2fa-63a4-bdfe-5327ea1b9d04"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1f0ebb75-440a-612a-b93a-7b4477a89f9e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => "1f0ebb75-440a-612a-b93a-7b4477a89f9e"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT COUNT(e0_.id) AS sclr_0 FROM ecrf_data_issue e0_ WHERE (e0_.flags)::jsonb @> (?)::jsonb = true"
  "params" => [
    1 => ""count_mismatch""
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT COUNT(e0_.id) AS sclr_0 FROM ecrf_data_issue e0_ WHERE (e0_.flags)::jsonb @> (?)::jsonb = true"
  "params" => [
    1 => ""duplicate""
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT COUNT(e0_.id) AS sclr_0 FROM ecrf_data_issue e0_ WHERE (e0_.flags)::jsonb @> (?)::jsonb = true"
  "params" => [
    1 => ""overuse""
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT COUNT(e0_.id) AS sclr_0 FROM ecrf_data_issue e0_ WHERE (e0_.flags)::jsonb @> (?)::jsonb = true"
  "params" => [
    1 => ""ecrf_detached""
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT COUNT(e0_.id) AS sclr_0 FROM ecrf_data_issue e0_ WHERE (e0_.flags)::jsonb @> (?)::jsonb = true"
  "params" => [
    1 => ""section_detached""
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT COUNT(e0_.id) AS sclr_0 FROM ecrf_data_issue e0_ WHERE (e0_.flags)::jsonb @> (?)::jsonb = true"
  "params" => [
    1 => ""visit_detached""
  ]
  "types" => [
    1 => 2
  ]
]

[
  "key" => "_security_main"
]

[
  "sql" => "SELECT CURRENT_DATABASE()"
]

[
  "sql" => """
    SELECT quote_ident(table_name) AS table_name,\n
           table_schema AS schema_name\n
    FROM information_schema.tables\n
    WHERE table_catalog = ?\n
      AND table_schema NOT LIKE 'pg\_%'\n
      AND table_schema != 'information_schema'\n
      AND table_name != 'geometry_columns'\n
      AND table_name != 'spatial_ref_sys'\n
      AND table_type = 'BASE TABLE'\n
    ORDER BY\n
      quote_ident(table_name)
    """
  "params" => [
    1 => "refsal_preprod"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => """
    SELECT schema_name\n
    FROM   information_schema.schemata\n
    WHERE  schema_name NOT LIKE 'pg\_%'\n
    AND    schema_name != 'information_schema'
    """
]

[
  "sql" => "SHOW search_path"
]

[
  "sql" => "SELECT CURRENT_DATABASE()"
]

[
  "sql" => """
    SELECT quote_ident(table_name) AS table_name,\n
           table_schema AS schema_name\n
    FROM information_schema.tables\n
    WHERE table_catalog = ?\n
      AND table_schema NOT LIKE 'pg\_%'\n
      AND table_schema != 'information_schema'\n
      AND table_name != 'geometry_columns'\n
      AND table_name != 'spatial_ref_sys'\n
      AND table_type = 'BASE TABLE'\n
    ORDER BY\n
      quote_ident(table_name)
    """
  "params" => [
    1 => "refsal_preprod"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT CURRENT_DATABASE()"
]

[
  "sql" => """
    SELECT n.nspname AS schema_name,\n
           c.relname AS table_name,\n
           CASE c.relpersistence WHEN 'u' THEN true ELSE false END as unlogged,\n
           obj_description(c.oid, 'pg_class') AS comment\n
    FROM pg_class c\n
         INNER JOIN pg_namespace n\n
             ON n.oid = c.relnamespace WHERE c.relkind = 'r' AND n.nspname = ANY(current_schemas(false)) AND c.relname = 'doctrine_migration_versions' AND n.nspname NOT IN ('pg_catalog', 'information_schema', 'pg_toast')
    """
]

[
  "sql" => "SELECT CURRENT_DATABASE()"
]

[
  "sql" => """
    SELECT                  quote_ident(r.conname) as conname,\n
                      pg_get_constraintdef(r.oid, true) as condef\n
                      FROM pg_constraint r\n
                          JOIN pg_class AS tc ON tc.oid = r.conrelid\n
                          JOIN pg_namespace tn ON tn.oid = tc.relnamespace\n
                      WHERE r.conrelid IN\n
                      (\n
                          SELECT c.oid\n
                          FROM pg_class c, pg_namespace n WHERE n.oid = c.relnamespace AND n.nspname = ANY(current_schemas(false)) AND c.relname = 'doctrine_migration_versions' AND n.nspname NOT IN ('pg_catalog', 'information_schema', 'pg_toast')) AND r.contype = 'f' ORDER BY quote_ident(r.conname)
    """
]

[
  "sql" => """
    SELECT            a.attnum,\n
                quote_ident(a.attname) AS field,\n
                t.typname AS type,\n
                format_type(a.atttypid, a.atttypmod) AS complete_type,\n
                (SELECT tc.collcollate FROM pg_catalog.pg_collation tc WHERE tc.oid = a.attcollation) AS collation,\n
                (SELECT t1.typname FROM pg_catalog.pg_type t1 WHERE t1.oid = t.typbasetype) AS domain_type,\n
                (SELECT format_type(t2.typbasetype, t2.typtypmod) FROM\n
                  pg_catalog.pg_type t2 WHERE t2.typtype = 'd' AND t2.oid = a.atttypid) AS domain_complete_type,\n
                a.attnotnull AS isnotnull,\n
                (SELECT 't'\n
                 FROM pg_index\n
                 WHERE c.oid = pg_index.indrelid\n
                    AND pg_index.indkey[0] = a.attnum\n
                    AND pg_index.indisprimary = 't'\n
                ) AS pri,\n
                (    SELECT\n
            CASE\n
                WHEN a.attgenerated = 's' THEN NULL\n
                ELSE pg_get_expr(adbin, adrelid)\n
            END\n
         FROM pg_attrdef\n
         WHERE c.oid = pg_attrdef.adrelid\n
            AND pg_attrdef.adnum=a.attnum) AS default,\n
                (SELECT pg_description.description\n
                    FROM pg_description WHERE pg_description.objoid = c.oid AND a.attnum = pg_description.objsubid\n
                ) AS comment\n
                FROM pg_attribute a\n
                    INNER JOIN pg_class c\n
                        ON c.oid = a.attrelid\n
                    INNER JOIN pg_type t\n
                        ON t.oid = a.atttypid\n
                    INNER JOIN pg_namespace n\n
                        ON n.oid = c.relnamespace\n
                    LEFT JOIN pg_depend d\n
                        ON d.objid = c.oid\n
                            AND d.deptype = 'e'\n
                            AND d.classid = (SELECT oid FROM pg_class WHERE relname = 'pg_class') WHERE a.attnum > 0 AND c.relkind = 'r' AND d.refobjid IS NULL AND n.nspname = ANY(current_schemas(false)) AND c.relname = 'doctrine_migration_versions' AND n.nspname NOT IN ('pg_catalog', 'information_schema', 'pg_toast') ORDER BY a.attnum
    """
]

[
  "sql" => "SELECT CURRENT_DATABASE()"
]

[
  "sql" => """
    SELECT                   quote_ident(ic.relname) AS relname,\n
                       i.indisunique,\n
                       i.indisprimary,\n
                       i.indkey,\n
                       i.indrelid,\n
                       pg_get_expr(indpred, indrelid) AS "where"\n
                  FROM pg_index i\n
                       JOIN pg_class AS tc ON tc.oid = i.indrelid\n
                       JOIN pg_namespace tn ON tn.oid = tc.relnamespace\n
                       JOIN pg_class AS ic ON ic.oid = i.indexrelid\n
                 WHERE ic.oid IN (\n
                    SELECT indexrelid\n
                    FROM pg_index i, pg_class c, pg_namespace n WHERE c.oid = i.indrelid AND c.relnamespace = n.oid AND n.nspname = ANY(current_schemas(false)) AND c.relname = 'doctrine_migration_versions' AND n.nspname NOT IN ('pg_catalog', 'information_schema', 'pg_toast')) ORDER BY quote_ident(ic.relname)
    """
]

[
  "sql" => """
    SELECT attnum,\n
           quote_ident(attname) AS attname\n
    FROM pg_attribute\n
    WHERE attrelid = 3717713\n
      AND attnum IN (1)\n
    ORDER BY attnum
    """
]

[
  "sql" => "SELECT * FROM doctrine_migration_versions"
]

[
  "sql" => "SELECT CURRENT_DATABASE()"
]