Symfony Profiler

[
  "route" => "admin_candidate_detail"
  "route_parameters" => [
    "_route" => "admin_candidate_detail"
    "_controller" => "App\Controller\Admin\CandidateCrudController::detail"
    "routeCreatedByEasyAdmin" => true
    "dashboardControllerFqcn" => "App\Controller\Admin\DashboardController"
    "crudControllerFqcn" => "App\Controller\Admin\CandidateCrudController"
    "crudAction" => "detail"
    "_locale" => "fr"
    "entityId" => "2"
  ]
  "request_uri" => "https://app.trainizer.fr/fr/admin/candidate/2"
  "method" => "GET"
]

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

[
  "key" => "_security_main"
  "token_class" => "Symfony\Component\Security\Http\Authenticator\Token\PostAuthenticationToken"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "192.168.1.131"
    "port" => 3306
    "user" => "paf_dev"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "autoformation_dev"
    "serverVersion" => "11.8.3-MariaDB"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.category AS category_2, t0.registry_number AS registry_number_3, t0.job AS job_4, t0.qualification AS qualification_5, t0.contract_label AS contract_label_6, t0.nationality AS nationality_7, t0.birth_date AS birth_date_8, t0.sex AS sex_9, t0.hired_at AS hired_at_10, t0.left_at AS left_at_11, t0.notes AS notes_12, t0.created_at AS created_at_13, t0.user_id AS user_id_14 FROM collaborator t0 WHERE t0.user_id = ?"
  "params" => [
    1 => 108
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1320
      +name: "INTEGER"
    }
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "sophiepoulakos"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.status AS status_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.email AS email_5, t0.desired_training AS desired_training_6, t0.retention_years AS retention_years_7, t0.locale AS locale_8, t0.birth_date AS birth_date_9, t0.birth_place AS birth_place_10, t0.nationality AS nationality_11, t0.phone_number AS phone_number_12, t0.street AS street_13, t0.postal_code AS postal_code_14, t0.city AS city_15, t0.country AS country_16, t0.education_level AS education_level_17, t0.situation AS situation_18, t0.financial_aid AS financial_aid_19, t0.motivation AS motivation_20, t0.token_hash AS token_hash_21, t0.token_expires_at AS token_expires_at_22, t0.seal_reference AS seal_reference_23, t0.sealed_at AS sealed_at_24, t0.seal_digest AS seal_digest_25, t0.document_path AS document_path_26, t0.document_sha256 AS document_sha256_27, t0.created_at AS created_at_28, t0.submitted_at AS submitted_at_29, t0.validated_at AS validated_at_30, t0.decided_at AS decided_at_31, t0.rejection_reason AS rejection_reason_32, t0.retention_until AS retention_until_33, t0.invited_by_id AS invited_by_id_34, t0.validated_by_id AS validated_by_id_35, t0.decided_by_id AS decided_by_id_36, t0.cohort_id AS cohort_id_37, t0.trainee_id AS trainee_id_38 FROM candidate t0 WHERE t0.id = ?"
  "params" => [
    1 => "2"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1320
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_5, t0.username AS username_6, t0.last_name AS last_name_7, t0.first_name AS first_name_8, t0.roles AS roles_9, t0.password AS password_10, t0.email AS email_11, t0.activated AS activated_12, t0.tmp_code AS tmp_code_13, t0.tmp_code_date AS tmp_code_date_14, t0.signature AS signature_15, t0.uuid AS uuid_16, t0.phone_number AS phone_number_17, t0.avatar_id AS avatar_id_18, t0.dtype, t1.role AS role_19, t1.entrance_code AS entrance_code_20, t1.entrance_code_date AS entrance_code_date_21, t1.responsible_id AS responsible_id_22, t2.role AS role_23, t2.entrance_code AS entrance_code_24, t2.entrance_code_date AS entrance_code_date_25, t2.sector_id AS sector_id_26, t3.password_save AS password_save_27, t3.documents AS documents_28, t3.diploma AS diploma_29, t3.tutorial_completed AS tutorial_completed_30, t3.financial_aid AS financial_aid_31, t3.cohort_id AS cohort_id_32, t4.role AS role_33, t4.entrance_code AS entrance_code_34, t4.entrance_code_date AS entrance_code_date_35, t4.coordinator_id AS coordinator_id_36 FROM user t0 LEFT JOIN coordinator t1 ON t0.id = t1.id LEFT JOIN responsible t2 ON t0.id = t2.id LEFT JOIN trainee t3 ON t0.id = t3.id LEFT JOIN trainer t4 ON t0.id = t4.id WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1320
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.category AS category_2, t0.registry_number AS registry_number_3, t0.job AS job_4, t0.qualification AS qualification_5, t0.contract_label AS contract_label_6, t0.nationality AS nationality_7, t0.birth_date AS birth_date_8, t0.sex AS sex_9, t0.hired_at AS hired_at_10, t0.left_at AS left_at_11, t0.notes AS notes_12, t0.created_at AS created_at_13, t0.user_id AS user_id_14 FROM collaborator t0 WHERE t0.user_id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1320
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.category AS category_2, t0.registry_number AS registry_number_3, t0.job AS job_4, t0.qualification AS qualification_5, t0.contract_label AS contract_label_6, t0.nationality AS nationality_7, t0.birth_date AS birth_date_8, t0.sex AS sex_9, t0.hired_at AS hired_at_10, t0.left_at AS left_at_11, t0.notes AS notes_12, t0.created_at AS created_at_13, t0.user_id AS user_id_14 FROM collaborator t0 WHERE t0.user_id = ?"
  "params" => [
    1 => 180
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1320
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.origin AS origin_2, t0.message AS message_3, t0.link AS link_4, t0.date AS date_5, t0.category AS category_6, t0.user_id AS user_id_7 FROM notification t0 WHERE t0.category = ? AND t0.user_id = ? ORDER BY t0.date DESC"
  "params" => [
    1 => "homework_to_do"
    2 => 108
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#3755
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1320
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.origin AS origin_2, t0.message AS message_3, t0.link AS link_4, t0.date AS date_5, t0.category AS category_6, t0.user_id AS user_id_7 FROM notification t0 WHERE t0.category = ? AND t0.user_id = ? ORDER BY t0.date DESC"
  "params" => [
    1 => "new_message"
    2 => 108
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#3755
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1320
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.origin AS origin_2, t0.message AS message_3, t0.link AS link_4, t0.date AS date_5, t0.category AS category_6, t0.user_id AS user_id_7 FROM notification t0 WHERE t0.category IN (?, ?, ?) AND t0.user_id = ? ORDER BY t0.date DESC"
  "params" => [
    1 => "internship_approval"
    2 => "internship_to_seal"
    3 => "internship_rejected"
    4 => 108
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#3755
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#3755}
    3 => Doctrine\DBAL\ParameterType {#3755}
    4 => Doctrine\DBAL\ParameterType {#1320
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.origin AS origin_2, t0.message AS message_3, t0.link AS link_4, t0.date AS date_5, t0.category AS category_6, t0.user_id AS user_id_7 FROM notification t0 WHERE t0.category = ? AND t0.user_id = ? ORDER BY t0.date DESC"
  "params" => [
    1 => "new_document"
    2 => 108
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#3755
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1320
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.origin AS origin_2, t0.message AS message_3, t0.link AS link_4, t0.date AS date_5, t0.category AS category_6, t0.user_id AS user_id_7 FROM notification t0 WHERE t0.category IN (?, ?, ?) AND t0.user_id = ? ORDER BY t0.date DESC"
  "params" => [
    1 => "planning_added"
    2 => "planning_updated"
    3 => "planning_removed"
    4 => 108
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#3755
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#3755}
    3 => Doctrine\DBAL\ParameterType {#3755}
    4 => Doctrine\DBAL\ParameterType {#1320
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3 FROM theme t0 WHERE t0.id = ?"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1320
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t1.id AS id_2, t1.username AS username_3, t1.last_name AS last_name_4, t1.first_name AS first_name_5, t1.roles AS roles_6, t1.password AS password_7, t1.email AS email_8, t1.activated AS activated_9, t1.tmp_code AS tmp_code_10, t1.tmp_code_date AS tmp_code_date_11, t1.signature AS signature_12, t1.uuid AS uuid_13, t1.phone_number AS phone_number_14, t0.role AS role_15, t0.entrance_code AS entrance_code_16, t0.entrance_code_date AS entrance_code_date_17, t1.avatar_id AS avatar_id_18, t0.sector_id AS sector_id_19, t1.dtype FROM responsible t0 INNER JOIN user t1 ON t0.id = t1.id WHERE t1.username = ? LIMIT 1"
  "params" => [
    1 => "sophiepoulakos"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#3755
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t1.id AS id_2, t1.username AS username_3, t1.last_name AS last_name_4, t1.first_name AS first_name_5, t1.roles AS roles_6, t1.password AS password_7, t1.email AS email_8, t1.activated AS activated_9, t1.tmp_code AS tmp_code_10, t1.tmp_code_date AS tmp_code_date_11, t1.signature AS signature_12, t1.uuid AS uuid_13, t1.phone_number AS phone_number_14, t0.role AS role_15, t0.entrance_code AS entrance_code_16, t0.entrance_code_date AS entrance_code_date_17, t1.avatar_id AS avatar_id_18, t0.coordinator_id AS coordinator_id_19, t1.dtype FROM trainer t0 INNER JOIN user t1 ON t0.id = t1.id WHERE t1.username = ? LIMIT 1"
  "params" => [
    1 => "sophiepoulakos"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#3755
      +name: "STRING"
    }
  ]
]

[
  "key" => "_security_main"
]