Symfony Profiler

[
  "route" => "app_admin_enrollment_index"
  "route_parameters" => [
    "_route" => "app_admin_enrollment_index"
    "_controller" => "App\Controller\Admin\EnrollmentController::index"
  ]
  "request_uri" => "https://dev.follow.ufa-schuman.com/admin/enrollments"
  "method" => "GET"
]

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

[
  "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" => "127.0.0.1"
    "port" => 3306
    "user" => "bdd_dev_follow"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "charset" => "utf8mb4"
      "collation" => "utf8mb4_unicode_ci"
      "engine" => "InnoDB"
    ]
    "dbname" => "bdd_dev_follow"
    "serverVersion" => "mariadb-10.11.18"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.is_active AS is_active_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.disabled_at AS disabled_at_10, t0.last_login_at AS last_login_at_11 FROM app_user t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#757
      +name: "INTEGER"
    }
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "admin@example.test"
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.label AS label_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.effective_start_date AS effective_start_date_4, p0_.effective_end_date AS effective_end_date_5, p0_.is_active AS is_active_6, p0_.is_archived AS is_archived_7, p0_.created_at AS created_at_8, p0_.updated_at AS updated_at_9 FROM promo p0_ ORDER BY p0_.is_archived ASC, p0_.is_active DESC, p0_.start_date DESC"
]

[
  "sql" => "SELECT p0_.id AS id_0, p0_.label AS label_1, p0_.start_date AS start_date_2, p0_.end_date AS end_date_3, p0_.effective_start_date AS effective_start_date_4, p0_.effective_end_date AS effective_end_date_5, p0_.is_active AS is_active_6, p0_.is_archived AS is_archived_7, p0_.created_at AS created_at_8, p0_.updated_at AS updated_at_9 FROM promo p0_ WHERE p0_.is_active = ? AND p0_.is_archived = ? LIMIT 1"
  "params" => [
    1 => 1
    2 => 0
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1189
      +name: "BOOLEAN"
    }
    2 => Doctrine\DBAL\ParameterType {#1189}
  ]
]

[
  "sql" => "SELECT e0_.id AS id_0, e0_.assigned_at AS assigned_at_1, e0_.is_active AS is_active_2, e0_.handicap_description AS handicap_description_3, e0_.aesh_support AS aesh_support_4, e0_.created_at AS created_at_5, e0_.updated_at AS updated_at_6, a1_.id AS id_7, a1_.email AS email_8, a1_.roles AS roles_9, a1_.password AS password_10, a1_.first_name AS first_name_11, a1_.last_name AS last_name_12, a1_.is_active AS is_active_13, a1_.created_at AS created_at_14, a1_.updated_at AS updated_at_15, a1_.disabled_at AS disabled_at_16, a1_.last_login_at AS last_login_at_17, p2_.id AS id_18, p2_.label AS label_19, p2_.start_date AS start_date_20, p2_.end_date AS end_date_21, p2_.effective_start_date AS effective_start_date_22, p2_.effective_end_date AS effective_end_date_23, p2_.is_active AS is_active_24, p2_.is_archived AS is_archived_25, p2_.created_at AS created_at_26, p2_.updated_at AS updated_at_27, s3_.id AS id_28, s3_.name AS name_29, s3_.follow_up_periodicity_weeks AS follow_up_periodicity_weeks_30, s3_.watch_enabled AS watch_enabled_31, s3_.stages_enabled AS stages_enabled_32, s3_.is_active AS is_active_33, s3_.created_at AS created_at_34, s3_.updated_at AS updated_at_35, e0_.student_id AS student_id_36, e0_.promo_id AS promo_id_37, e0_.school_class_id AS school_class_id_38 FROM enrollment e0_ LEFT JOIN app_user a1_ ON e0_.student_id = a1_.id LEFT JOIN promo p2_ ON e0_.promo_id = p2_.id LEFT JOIN school_class s3_ ON e0_.school_class_id = s3_.id WHERE e0_.promo_id = ? ORDER BY p2_.start_date DESC, s3_.name ASC, a1_.last_name ASC, a1_.first_name ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#757
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT s0_.enrollment_id AS sclr_0, COUNT(s0_.id) AS sclr_1 FROM student_convocation s0_ WHERE s0_.enrollment_id IN (?, ?, ?) AND s0_.archived_at IS NULL GROUP BY s0_.enrollment_id"
  "params" => [
    1 => 3
    2 => 1
    3 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#757
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#757}
    3 => Doctrine\DBAL\ParameterType {#757}
  ]
]

[
  "sql" => "SELECT a0_.enrollment_id AS sclr_0, COUNT(a0_.id) AS sclr_1 FROM ancillary_fee a0_ WHERE a0_.enrollment_id IN (?, ?, ?) GROUP BY a0_.enrollment_id"
  "params" => [
    1 => 3
    2 => 1
    3 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#757
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#757}
    3 => Doctrine\DBAL\ParameterType {#757}
  ]
]

[
  "sql" => "SELECT a0_.enrollment_id AS sclr_0, SUM(a0_.amount) AS sclr_1 FROM ancillary_fee a0_ WHERE a0_.enrollment_id IN (?, ?, ?) AND a0_.status IN (?, ?, ?) GROUP BY a0_.enrollment_id"
  "params" => [
    1 => 3
    2 => 1
    3 => 2
    4 => "SUBMITTED"
    5 => "APPROVED"
    6 => "LOCKED"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#757
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#757}
    3 => Doctrine\DBAL\ParameterType {#757}
    4 => Doctrine\DBAL\ParameterType {#1190
      +name: "STRING"
    }
    5 => Doctrine\DBAL\ParameterType {#1190}
    6 => Doctrine\DBAL\ParameterType {#1190}
  ]
]

[
  "sql" => "SELECT a0_.id AS id_0, a0_.type AS type_1, a0_.label AS label_2, a0_.description AS description_3, a0_.amount AS amount_4, a0_.status AS status_5, a0_.accounting_comment AS accounting_comment_6, a0_.processed_at AS processed_at_7, a0_.locked_at AS locked_at_8, a0_.created_at AS created_at_9, a0_.updated_at AS updated_at_10, a0_.cancelled_at AS cancelled_at_11, e1_.id AS id_12, e1_.assigned_at AS assigned_at_13, e1_.is_active AS is_active_14, e1_.handicap_description AS handicap_description_15, e1_.aesh_support AS aesh_support_16, e1_.created_at AS created_at_17, e1_.updated_at AS updated_at_18, a0_.student_id AS student_id_19, a0_.promo_id AS promo_id_20, a0_.enrollment_id AS enrollment_id_21, a0_.school_class_id AS school_class_id_22, a0_.created_by_id AS created_by_id_23, a0_.processed_by_id AS processed_by_id_24, a0_.locked_by_id AS locked_by_id_25, a0_.cancelled_by_id AS cancelled_by_id_26, e1_.student_id AS student_id_27, e1_.promo_id AS promo_id_28, e1_.school_class_id AS school_class_id_29 FROM ancillary_fee a0_ LEFT JOIN enrollment e1_ ON a0_.enrollment_id = e1_.id WHERE a0_.enrollment_id IN (?, ?, ?) ORDER BY a0_.created_at DESC"
  "params" => [
    1 => 3
    2 => 1
    3 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#757
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#757}
    3 => Doctrine\DBAL\ParameterType {#757}
  ]
]

[
  "sql" => "SELECT e0_.id AS id_0, e0_.assigned_at AS assigned_at_1, e0_.is_active AS is_active_2, e0_.handicap_description AS handicap_description_3, e0_.aesh_support AS aesh_support_4, e0_.created_at AS created_at_5, e0_.updated_at AS updated_at_6, a1_.id AS id_7, a1_.email AS email_8, a1_.roles AS roles_9, a1_.password AS password_10, a1_.first_name AS first_name_11, a1_.last_name AS last_name_12, a1_.is_active AS is_active_13, a1_.created_at AS created_at_14, a1_.updated_at AS updated_at_15, a1_.disabled_at AS disabled_at_16, a1_.last_login_at AS last_login_at_17, p2_.id AS id_18, p2_.label AS label_19, p2_.start_date AS start_date_20, p2_.end_date AS end_date_21, p2_.effective_start_date AS effective_start_date_22, p2_.effective_end_date AS effective_end_date_23, p2_.is_active AS is_active_24, p2_.is_archived AS is_archived_25, p2_.created_at AS created_at_26, p2_.updated_at AS updated_at_27, s3_.id AS id_28, s3_.name AS name_29, s3_.follow_up_periodicity_weeks AS follow_up_periodicity_weeks_30, s3_.watch_enabled AS watch_enabled_31, s3_.stages_enabled AS stages_enabled_32, s3_.is_active AS is_active_33, s3_.created_at AS created_at_34, s3_.updated_at AS updated_at_35, e0_.student_id AS student_id_36, e0_.promo_id AS promo_id_37, e0_.school_class_id AS school_class_id_38 FROM enrollment e0_ LEFT JOIN app_user a1_ ON e0_.student_id = a1_.id LEFT JOIN promo p2_ ON e0_.promo_id = p2_.id LEFT JOIN school_class s3_ ON e0_.school_class_id = s3_.id WHERE e0_.is_active = ? ORDER BY p2_.start_date DESC, s3_.name ASC, a1_.last_name ASC, a1_.first_name ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1189
      +name: "BOOLEAN"
    }
  ]
]

[
  "sql" => "SELECT f0_.id AS id_0, f0_.period_start AS period_start_1, f0_.period_end AS period_end_2, f0_.status AS status_3, f0_.validated_at AS validated_at_4, f0_.model_pdf_path AS model_pdf_path_5, f0_.signed_pdf_path AS signed_pdf_path_6, f0_.signed_pdf_uploaded_at AS signed_pdf_uploaded_at_7, f0_.created_at AS created_at_8, f0_.updated_at AS updated_at_9, e1_.id AS id_10, e1_.assigned_at AS assigned_at_11, e1_.is_active AS is_active_12, e1_.handicap_description AS handicap_description_13, e1_.aesh_support AS aesh_support_14, e1_.created_at AS created_at_15, e1_.updated_at AS updated_at_16, a2_.id AS id_17, a2_.email AS email_18, a2_.roles AS roles_19, a2_.password AS password_20, a2_.first_name AS first_name_21, a2_.last_name AS last_name_22, a2_.is_active AS is_active_23, a2_.created_at AS created_at_24, a2_.updated_at AS updated_at_25, a2_.disabled_at AS disabled_at_26, a2_.last_login_at AS last_login_at_27, p3_.id AS id_28, p3_.label AS label_29, p3_.start_date AS start_date_30, p3_.end_date AS end_date_31, p3_.effective_start_date AS effective_start_date_32, p3_.effective_end_date AS effective_end_date_33, p3_.is_active AS is_active_34, p3_.is_archived AS is_archived_35, p3_.created_at AS created_at_36, p3_.updated_at AS updated_at_37, s4_.id AS id_38, s4_.name AS name_39, s4_.follow_up_periodicity_weeks AS follow_up_periodicity_weeks_40, s4_.watch_enabled AS watch_enabled_41, s4_.stages_enabled AS stages_enabled_42, s4_.is_active AS is_active_43, s4_.created_at AS created_at_44, s4_.updated_at AS updated_at_45, f0_.enrollment_id AS enrollment_id_46, f0_.student_id AS student_id_47, f0_.promo_id AS promo_id_48, f0_.school_class_id AS school_class_id_49, e1_.student_id AS student_id_50, e1_.promo_id AS promo_id_51, e1_.school_class_id AS school_class_id_52 FROM follow_up_sheet f0_ LEFT JOIN enrollment e1_ ON f0_.enrollment_id = e1_.id LEFT JOIN app_user a2_ ON f0_.student_id = a2_.id LEFT JOIN promo p3_ ON f0_.promo_id = p3_.id LEFT JOIN school_class s4_ ON f0_.school_class_id = s4_.id WHERE f0_.enrollment_id IN (?, ?, ?) ORDER BY a2_.last_name ASC, a2_.first_name ASC, f0_.period_start ASC"
  "params" => [
    1 => 3
    2 => 1
    3 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#757
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#757}
    3 => Doctrine\DBAL\ParameterType {#757}
  ]
]

[
  "sql" => "SELECT f0_.id AS id_0, f0_.period_start AS period_start_1, f0_.period_end AS period_end_2, f0_.status AS status_3, f0_.validated_at AS validated_at_4, f0_.model_pdf_path AS model_pdf_path_5, f0_.signed_pdf_path AS signed_pdf_path_6, f0_.signed_pdf_uploaded_at AS signed_pdf_uploaded_at_7, f0_.created_at AS created_at_8, f0_.updated_at AS updated_at_9, e1_.id AS id_10, e1_.assigned_at AS assigned_at_11, e1_.is_active AS is_active_12, e1_.handicap_description AS handicap_description_13, e1_.aesh_support AS aesh_support_14, e1_.created_at AS created_at_15, e1_.updated_at AS updated_at_16, a2_.id AS id_17, a2_.email AS email_18, a2_.roles AS roles_19, a2_.password AS password_20, a2_.first_name AS first_name_21, a2_.last_name AS last_name_22, a2_.is_active AS is_active_23, a2_.created_at AS created_at_24, a2_.updated_at AS updated_at_25, a2_.disabled_at AS disabled_at_26, a2_.last_login_at AS last_login_at_27, p3_.id AS id_28, p3_.label AS label_29, p3_.start_date AS start_date_30, p3_.end_date AS end_date_31, p3_.effective_start_date AS effective_start_date_32, p3_.effective_end_date AS effective_end_date_33, p3_.is_active AS is_active_34, p3_.is_archived AS is_archived_35, p3_.created_at AS created_at_36, p3_.updated_at AS updated_at_37, s4_.id AS id_38, s4_.name AS name_39, s4_.follow_up_periodicity_weeks AS follow_up_periodicity_weeks_40, s4_.watch_enabled AS watch_enabled_41, s4_.stages_enabled AS stages_enabled_42, s4_.is_active AS is_active_43, s4_.created_at AS created_at_44, s4_.updated_at AS updated_at_45, f0_.enrollment_id AS enrollment_id_46, f0_.student_id AS student_id_47, f0_.promo_id AS promo_id_48, f0_.school_class_id AS school_class_id_49, e1_.student_id AS student_id_50, e1_.promo_id AS promo_id_51, e1_.school_class_id AS school_class_id_52 FROM follow_up_sheet f0_ LEFT JOIN enrollment e1_ ON f0_.enrollment_id = e1_.id LEFT JOIN app_user a2_ ON f0_.student_id = a2_.id LEFT JOIN promo p3_ ON f0_.promo_id = p3_.id LEFT JOIN school_class s4_ ON f0_.school_class_id = s4_.id WHERE f0_.enrollment_id IN (?, ?, ?) ORDER BY a2_.last_name ASC, a2_.first_name ASC, f0_.period_start ASC"
  "params" => [
    1 => 3
    2 => 1
    3 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#757
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#757}
    3 => Doctrine\DBAL\ParameterType {#757}
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.start_date AS start_date_1, s0_.end_date AS end_date_2, s0_.status AS status_3, s0_.break_reason AS break_reason_4, s0_.contract_cost AS contract_cost_5, s0_.broken_at AS broken_at_6, s0_.ended_at AS ended_at_7, s0_.created_at AS created_at_8, s0_.updated_at AS updated_at_9, c1_.id AS id_10, c1_.name AS name_11, c1_.generic_email AS generic_email_12, c1_.address AS address_13, c1_.postal_code AS postal_code_14, c1_.city AS city_15, c1_.siret AS siret_16, c1_.naf_ape AS naf_ape_17, c1_.legal_form AS legal_form_18, c1_.sector AS sector_19, c1_.is_active AS is_active_20, c1_.created_at AS created_at_21, c1_.updated_at AS updated_at_22, c2_.id AS id_23, c2_.first_name AS first_name_24, c2_.last_name AS last_name_25, c2_.email AS email_26, c2_.phone AS phone_27, c2_.is_active AS is_active_28, c2_.created_at AS created_at_29, c2_.updated_at AS updated_at_30, e3_.id AS id_31, e3_.assigned_at AS assigned_at_32, e3_.is_active AS is_active_33, e3_.handicap_description AS handicap_description_34, e3_.aesh_support AS aesh_support_35, e3_.created_at AS created_at_36, e3_.updated_at AS updated_at_37, s0_.student_id AS student_id_38, s0_.enrollment_id AS enrollment_id_39, s0_.promo_id AS promo_id_40, s0_.company_id AS company_id_41, s0_.company_tutor_id AS company_tutor_id_42, c2_.company_id AS company_id_43, e3_.student_id AS student_id_44, e3_.promo_id AS promo_id_45, e3_.school_class_id AS school_class_id_46 FROM student_contract s0_ LEFT JOIN company c1_ ON s0_.company_id = c1_.id LEFT JOIN company_tutor c2_ ON s0_.company_tutor_id = c2_.id LEFT JOIN enrollment e3_ ON s0_.enrollment_id = e3_.id WHERE s0_.enrollment_id IN (?, ?, ?) AND s0_.status = ?"
  "params" => [
    1 => 3
    2 => 1
    3 => 2
    4 => "ACTIVE"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#757
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#757}
    3 => Doctrine\DBAL\ParameterType {#757}
    4 => Doctrine\DBAL\ParameterType {#1190
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.line_number AS line_number_1, c0_.raw_last_name AS raw_last_name_2, c0_.raw_first_name AS raw_first_name_3, c0_.raw_class_name AS raw_class_name_4, c0_.meal_count AS meal_count_5, c0_.extra_meal_count AS extra_meal_count_6, c0_.total_meal_count AS total_meal_count_7, c0_.imported_unit_price AS imported_unit_price_8, c0_.imported_total AS imported_total_9, c0_.expected_unit_price AS expected_unit_price_10, c0_.expected_total AS expected_total_11, c0_.has_active_contract AS has_active_contract_12, c0_.anomaly AS anomaly_13, c0_.status AS status_14, c0_.status_reason AS status_reason_15, c0_.processing_comment AS processing_comment_16, c0_.corrected_unit_price AS corrected_unit_price_17, c0_.corrected_total AS corrected_total_18, c0_.processed_at AS processed_at_19, c0_.created_at AS created_at_20, c1_.id AS id_21, c1_.billing_month AS billing_month_22, c1_.imported_at AS imported_at_23, c1_.original_filename AS original_filename_24, c1_.total_rows AS total_rows_25, c1_.matched_rows AS matched_rows_26, c1_.ignored_rows AS ignored_rows_27, c1_.error_rows AS error_rows_28, c1_.anomaly_rows AS anomaly_rows_29, c1_.status AS status_30, c1_.is_current AS is_current_31, c1_.created_at AS created_at_32, p2_.id AS id_33, p2_.label AS label_34, p2_.start_date AS start_date_35, p2_.end_date AS end_date_36, p2_.effective_start_date AS effective_start_date_37, p2_.effective_end_date AS effective_end_date_38, p2_.is_active AS is_active_39, p2_.is_archived AS is_archived_40, p2_.created_at AS created_at_41, p2_.updated_at AS updated_at_42, a3_.id AS id_43, a3_.email AS email_44, a3_.roles AS roles_45, a3_.password AS password_46, a3_.first_name AS first_name_47, a3_.last_name AS last_name_48, a3_.is_active AS is_active_49, a3_.created_at AS created_at_50, a3_.updated_at AS updated_at_51, a3_.disabled_at AS disabled_at_52, a3_.last_login_at AS last_login_at_53, s4_.id AS id_54, s4_.name AS name_55, s4_.follow_up_periodicity_weeks AS follow_up_periodicity_weeks_56, s4_.watch_enabled AS watch_enabled_57, s4_.stages_enabled AS stages_enabled_58, s4_.is_active AS is_active_59, s4_.created_at AS created_at_60, s4_.updated_at AS updated_at_61, a5_.id AS id_62, a5_.email AS email_63, a5_.roles AS roles_64, a5_.password AS password_65, a5_.first_name AS first_name_66, a5_.last_name AS last_name_67, a5_.is_active AS is_active_68, a5_.created_at AS created_at_69, a5_.updated_at AS updated_at_70, a5_.disabled_at AS disabled_at_71, a5_.last_login_at AS last_login_at_72, c0_.batch_id AS batch_id_73, c0_.matched_student_id AS matched_student_id_74, c0_.matched_enrollment_id AS matched_enrollment_id_75, c0_.matched_school_class_id AS matched_school_class_id_76, c0_.processed_by_id AS processed_by_id_77, c1_.promo_id AS promo_id_78, c1_.imported_by_id AS imported_by_id_79 FROM canteen_import_line c0_ LEFT JOIN canteen_import_batch c1_ ON c0_.batch_id = c1_.id LEFT JOIN promo p2_ ON c1_.promo_id = p2_.id LEFT JOIN app_user a3_ ON c0_.matched_student_id = a3_.id LEFT JOIN school_class s4_ ON c0_.matched_school_class_id = s4_.id LEFT JOIN app_user a5_ ON c0_.processed_by_id = a5_.id WHERE c0_.anomaly = ? AND c1_.is_current = ? ORDER BY c1_.billing_month DESC, s4_.name ASC, a3_.last_name ASC"
  "params" => [
    1 => 1
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1189
      +name: "BOOLEAN"
    }
    2 => Doctrine\DBAL\ParameterType {#1189}
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.billing_month AS billing_month_1, c0_.imported_at AS imported_at_2, c0_.original_filename AS original_filename_3, c0_.total_rows AS total_rows_4, c0_.matched_rows AS matched_rows_5, c0_.ignored_rows AS ignored_rows_6, c0_.error_rows AS error_rows_7, c0_.anomaly_rows AS anomaly_rows_8, c0_.status AS status_9, c0_.is_current AS is_current_10, c0_.created_at AS created_at_11, p1_.id AS id_12, p1_.label AS label_13, p1_.start_date AS start_date_14, p1_.end_date AS end_date_15, p1_.effective_start_date AS effective_start_date_16, p1_.effective_end_date AS effective_end_date_17, p1_.is_active AS is_active_18, p1_.is_archived AS is_archived_19, p1_.created_at AS created_at_20, p1_.updated_at AS updated_at_21, a2_.id AS id_22, a2_.email AS email_23, a2_.roles AS roles_24, a2_.password AS password_25, a2_.first_name AS first_name_26, a2_.last_name AS last_name_27, a2_.is_active AS is_active_28, a2_.created_at AS created_at_29, a2_.updated_at AS updated_at_30, a2_.disabled_at AS disabled_at_31, a2_.last_login_at AS last_login_at_32, c0_.promo_id AS promo_id_33, c0_.imported_by_id AS imported_by_id_34 FROM canteen_import_batch c0_ LEFT JOIN promo p1_ ON c0_.promo_id = p1_.id LEFT JOIN app_user a2_ ON c0_.imported_by_id = a2_.id ORDER BY c0_.imported_at DESC, p1_.start_date DESC"
]

[
  "sql" => "SELECT a0_.id AS id_0, a0_.type AS type_1, a0_.label AS label_2, a0_.description AS description_3, a0_.amount AS amount_4, a0_.status AS status_5, a0_.accounting_comment AS accounting_comment_6, a0_.processed_at AS processed_at_7, a0_.locked_at AS locked_at_8, a0_.created_at AS created_at_9, a0_.updated_at AS updated_at_10, a0_.cancelled_at AS cancelled_at_11, a1_.id AS id_12, a1_.email AS email_13, a1_.roles AS roles_14, a1_.password AS password_15, a1_.first_name AS first_name_16, a1_.last_name AS last_name_17, a1_.is_active AS is_active_18, a1_.created_at AS created_at_19, a1_.updated_at AS updated_at_20, a1_.disabled_at AS disabled_at_21, a1_.last_login_at AS last_login_at_22, p2_.id AS id_23, p2_.label AS label_24, p2_.start_date AS start_date_25, p2_.end_date AS end_date_26, p2_.effective_start_date AS effective_start_date_27, p2_.effective_end_date AS effective_end_date_28, p2_.is_active AS is_active_29, p2_.is_archived AS is_archived_30, p2_.created_at AS created_at_31, p2_.updated_at AS updated_at_32, s3_.id AS id_33, s3_.name AS name_34, s3_.follow_up_periodicity_weeks AS follow_up_periodicity_weeks_35, s3_.watch_enabled AS watch_enabled_36, s3_.stages_enabled AS stages_enabled_37, s3_.is_active AS is_active_38, s3_.created_at AS created_at_39, s3_.updated_at AS updated_at_40, a4_.id AS id_41, a4_.email AS email_42, a4_.roles AS roles_43, a4_.password AS password_44, a4_.first_name AS first_name_45, a4_.last_name AS last_name_46, a4_.is_active AS is_active_47, a4_.created_at AS created_at_48, a4_.updated_at AS updated_at_49, a4_.disabled_at AS disabled_at_50, a4_.last_login_at AS last_login_at_51, a5_.id AS id_52, a5_.email AS email_53, a5_.roles AS roles_54, a5_.password AS password_55, a5_.first_name AS first_name_56, a5_.last_name AS last_name_57, a5_.is_active AS is_active_58, a5_.created_at AS created_at_59, a5_.updated_at AS updated_at_60, a5_.disabled_at AS disabled_at_61, a5_.last_login_at AS last_login_at_62, a6_.id AS id_63, a6_.email AS email_64, a6_.roles AS roles_65, a6_.password AS password_66, a6_.first_name AS first_name_67, a6_.last_name AS last_name_68, a6_.is_active AS is_active_69, a6_.created_at AS created_at_70, a6_.updated_at AS updated_at_71, a6_.disabled_at AS disabled_at_72, a6_.last_login_at AS last_login_at_73, a0_.student_id AS student_id_74, a0_.promo_id AS promo_id_75, a0_.enrollment_id AS enrollment_id_76, a0_.school_class_id AS school_class_id_77, a0_.created_by_id AS created_by_id_78, a0_.processed_by_id AS processed_by_id_79, a0_.locked_by_id AS locked_by_id_80, a0_.cancelled_by_id AS cancelled_by_id_81 FROM ancillary_fee a0_ LEFT JOIN app_user a1_ ON a0_.student_id = a1_.id LEFT JOIN promo p2_ ON a0_.promo_id = p2_.id LEFT JOIN school_class s3_ ON a0_.school_class_id = s3_.id LEFT JOIN app_user a4_ ON a0_.created_by_id = a4_.id LEFT JOIN app_user a5_ ON a0_.processed_by_id = a5_.id LEFT JOIN app_user a6_ ON a0_.locked_by_id = a6_.id WHERE a0_.status = ? ORDER BY a0_.created_at DESC, a1_.last_name ASC"
  "params" => [
    1 => "SUBMITTED"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1190
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.subject AS subject_1, s0_.message AS message_2, s0_.scheduled_at AS scheduled_at_3, s0_.sent_at AS sent_at_4, s0_.summary AS summary_5, s0_.summary_updated_at AS summary_updated_at_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.archived_at AS archived_at_9, a1_.id AS id_10, a1_.email AS email_11, a1_.roles AS roles_12, a1_.password AS password_13, a1_.first_name AS first_name_14, a1_.last_name AS last_name_15, a1_.is_active AS is_active_16, a1_.created_at AS created_at_17, a1_.updated_at AS updated_at_18, a1_.disabled_at AS disabled_at_19, a1_.last_login_at AS last_login_at_20, p2_.id AS id_21, p2_.label AS label_22, p2_.start_date AS start_date_23, p2_.end_date AS end_date_24, p2_.effective_start_date AS effective_start_date_25, p2_.effective_end_date AS effective_end_date_26, p2_.is_active AS is_active_27, p2_.is_archived AS is_archived_28, p2_.created_at AS created_at_29, p2_.updated_at AS updated_at_30, e3_.id AS id_31, e3_.assigned_at AS assigned_at_32, e3_.is_active AS is_active_33, e3_.handicap_description AS handicap_description_34, e3_.aesh_support AS aesh_support_35, e3_.created_at AS created_at_36, e3_.updated_at AS updated_at_37, s4_.id AS id_38, s4_.name AS name_39, s4_.follow_up_periodicity_weeks AS follow_up_periodicity_weeks_40, s4_.watch_enabled AS watch_enabled_41, s4_.stages_enabled AS stages_enabled_42, s4_.is_active AS is_active_43, s4_.created_at AS created_at_44, s4_.updated_at AS updated_at_45, a5_.id AS id_46, a5_.email AS email_47, a5_.roles AS roles_48, a5_.password AS password_49, a5_.first_name AS first_name_50, a5_.last_name AS last_name_51, a5_.is_active AS is_active_52, a5_.created_at AS created_at_53, a5_.updated_at AS updated_at_54, a5_.disabled_at AS disabled_at_55, a5_.last_login_at AS last_login_at_56, a6_.id AS id_57, a6_.email AS email_58, a6_.roles AS roles_59, a6_.password AS password_60, a6_.first_name AS first_name_61, a6_.last_name AS last_name_62, a6_.is_active AS is_active_63, a6_.created_at AS created_at_64, a6_.updated_at AS updated_at_65, a6_.disabled_at AS disabled_at_66, a6_.last_login_at AS last_login_at_67, a7_.id AS id_68, a7_.email AS email_69, a7_.roles AS roles_70, a7_.password AS password_71, a7_.first_name AS first_name_72, a7_.last_name AS last_name_73, a7_.is_active AS is_active_74, a7_.created_at AS created_at_75, a7_.updated_at AS updated_at_76, a7_.disabled_at AS disabled_at_77, a7_.last_login_at AS last_login_at_78, s0_.student_id AS student_id_79, s0_.promo_id AS promo_id_80, s0_.enrollment_id AS enrollment_id_81, s0_.created_by_id AS created_by_id_82, s0_.summary_updated_by_id AS summary_updated_by_id_83, s0_.archived_by_id AS archived_by_id_84, e3_.student_id AS student_id_85, e3_.promo_id AS promo_id_86, e3_.school_class_id AS school_class_id_87 FROM student_convocation s0_ LEFT JOIN app_user a1_ ON s0_.student_id = a1_.id LEFT JOIN promo p2_ ON s0_.promo_id = p2_.id LEFT JOIN enrollment e3_ ON s0_.enrollment_id = e3_.id LEFT JOIN school_class s4_ ON e3_.school_class_id = s4_.id LEFT JOIN app_user a5_ ON s0_.created_by_id = a5_.id LEFT JOIN app_user a6_ ON s0_.summary_updated_by_id = a6_.id LEFT JOIN app_user a7_ ON s0_.archived_by_id = a7_.id WHERE s0_.archived_at IS NULL ORDER BY s0_.created_at DESC, a1_.last_name ASC, a1_.first_name ASC"
]

[
  "sql" => "SELECT s0_.id AS id_0, s0_.subject AS subject_1, s0_.message AS message_2, s0_.scheduled_at AS scheduled_at_3, s0_.sent_at AS sent_at_4, s0_.summary AS summary_5, s0_.summary_updated_at AS summary_updated_at_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.archived_at AS archived_at_9, a1_.id AS id_10, a1_.email AS email_11, a1_.roles AS roles_12, a1_.password AS password_13, a1_.first_name AS first_name_14, a1_.last_name AS last_name_15, a1_.is_active AS is_active_16, a1_.created_at AS created_at_17, a1_.updated_at AS updated_at_18, a1_.disabled_at AS disabled_at_19, a1_.last_login_at AS last_login_at_20, p2_.id AS id_21, p2_.label AS label_22, p2_.start_date AS start_date_23, p2_.end_date AS end_date_24, p2_.effective_start_date AS effective_start_date_25, p2_.effective_end_date AS effective_end_date_26, p2_.is_active AS is_active_27, p2_.is_archived AS is_archived_28, p2_.created_at AS created_at_29, p2_.updated_at AS updated_at_30, e3_.id AS id_31, e3_.assigned_at AS assigned_at_32, e3_.is_active AS is_active_33, e3_.handicap_description AS handicap_description_34, e3_.aesh_support AS aesh_support_35, e3_.created_at AS created_at_36, e3_.updated_at AS updated_at_37, s4_.id AS id_38, s4_.name AS name_39, s4_.follow_up_periodicity_weeks AS follow_up_periodicity_weeks_40, s4_.watch_enabled AS watch_enabled_41, s4_.stages_enabled AS stages_enabled_42, s4_.is_active AS is_active_43, s4_.created_at AS created_at_44, s4_.updated_at AS updated_at_45, a5_.id AS id_46, a5_.email AS email_47, a5_.roles AS roles_48, a5_.password AS password_49, a5_.first_name AS first_name_50, a5_.last_name AS last_name_51, a5_.is_active AS is_active_52, a5_.created_at AS created_at_53, a5_.updated_at AS updated_at_54, a5_.disabled_at AS disabled_at_55, a5_.last_login_at AS last_login_at_56, a6_.id AS id_57, a6_.email AS email_58, a6_.roles AS roles_59, a6_.password AS password_60, a6_.first_name AS first_name_61, a6_.last_name AS last_name_62, a6_.is_active AS is_active_63, a6_.created_at AS created_at_64, a6_.updated_at AS updated_at_65, a6_.disabled_at AS disabled_at_66, a6_.last_login_at AS last_login_at_67, a7_.id AS id_68, a7_.email AS email_69, a7_.roles AS roles_70, a7_.password AS password_71, a7_.first_name AS first_name_72, a7_.last_name AS last_name_73, a7_.is_active AS is_active_74, a7_.created_at AS created_at_75, a7_.updated_at AS updated_at_76, a7_.disabled_at AS disabled_at_77, a7_.last_login_at AS last_login_at_78, s0_.student_id AS student_id_79, s0_.promo_id AS promo_id_80, s0_.enrollment_id AS enrollment_id_81, s0_.created_by_id AS created_by_id_82, s0_.summary_updated_by_id AS summary_updated_by_id_83, s0_.archived_by_id AS archived_by_id_84, e3_.student_id AS student_id_85, e3_.promo_id AS promo_id_86, e3_.school_class_id AS school_class_id_87 FROM student_convocation s0_ LEFT JOIN app_user a1_ ON s0_.student_id = a1_.id LEFT JOIN promo p2_ ON s0_.promo_id = p2_.id LEFT JOIN enrollment e3_ ON s0_.enrollment_id = e3_.id LEFT JOIN school_class s4_ ON e3_.school_class_id = s4_.id LEFT JOIN app_user a5_ ON s0_.created_by_id = a5_.id LEFT JOIN app_user a6_ ON s0_.summary_updated_by_id = a6_.id LEFT JOIN app_user a7_ ON s0_.archived_by_id = a7_.id WHERE s0_.archived_at IS NULL ORDER BY s0_.created_at DESC, a1_.last_name ASC, a1_.first_name ASC"
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.watch_definition AS watch_definition_1, t0_.tool_definition AS tool_definition_2, t0_.watch_subject AS watch_subject_3, t0_.implemented_tools AS implemented_tools_4, t0_.version AS version_5, t0_.created_at AS created_at_6, t0_.updated_at AS updated_at_7, a1_.id AS id_8, a1_.email AS email_9, a1_.roles AS roles_10, a1_.password AS password_11, a1_.first_name AS first_name_12, a1_.last_name AS last_name_13, a1_.is_active AS is_active_14, a1_.created_at AS created_at_15, a1_.updated_at AS updated_at_16, a1_.disabled_at AS disabled_at_17, a1_.last_login_at AS last_login_at_18, t0_.student_id AS student_id_19 FROM technology_watch_profile t0_ LEFT JOIN app_user a1_ ON t0_.student_id = a1_.id WHERE t0_.student_id IN (?, ?) ORDER BY a1_.last_name ASC, a1_.first_name ASC"
  "params" => [
    1 => 5
    2 => 6
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#757
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#757}
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.description AS description_2, t0_.required_article_count AS required_article_count_3, t0_.end_date AS end_date_4, t0_.created_at AS created_at_5, t0_.updated_at AS updated_at_6, t0_.notification_sent_at AS notification_sent_at_7, t0_.reminder_sent_at AS reminder_sent_at_8, t0_.report_sent_at AS report_sent_at_9, t0_.archived_at AS archived_at_10, p1_.id AS id_11, p1_.label AS label_12, p1_.start_date AS start_date_13, p1_.end_date AS end_date_14, p1_.effective_start_date AS effective_start_date_15, p1_.effective_end_date AS effective_end_date_16, p1_.is_active AS is_active_17, p1_.is_archived AS is_archived_18, p1_.created_at AS created_at_19, p1_.updated_at AS updated_at_20, s2_.id AS id_21, s2_.name AS name_22, s2_.follow_up_periodicity_weeks AS follow_up_periodicity_weeks_23, s2_.watch_enabled AS watch_enabled_24, s2_.stages_enabled AS stages_enabled_25, s2_.is_active AS is_active_26, s2_.created_at AS created_at_27, s2_.updated_at AS updated_at_28, a3_.id AS id_29, a3_.email AS email_30, a3_.roles AS roles_31, a3_.password AS password_32, a3_.first_name AS first_name_33, a3_.last_name AS last_name_34, a3_.is_active AS is_active_35, a3_.created_at AS created_at_36, a3_.updated_at AS updated_at_37, a3_.disabled_at AS disabled_at_38, a3_.last_login_at AS last_login_at_39, t0_.promo_id AS promo_id_40, t0_.school_class_id AS school_class_id_41, t0_.created_by_id AS created_by_id_42, t0_.archived_by_id AS archived_by_id_43 FROM technology_watch_campaign t0_ LEFT JOIN promo p1_ ON t0_.promo_id = p1_.id LEFT JOIN school_class s2_ ON t0_.school_class_id = s2_.id LEFT JOIN app_user a3_ ON t0_.created_by_id = a3_.id WHERE t0_.archived_at IS NULL ORDER BY t0_.end_date DESC, t0_.created_at DESC"
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.article_count AS article_count_1, t0_.result AS result_2, t0_.evaluated_at AS evaluated_at_3, t0_.notification_sent_at AS notification_sent_at_4, t0_.reminder_sent_at AS reminder_sent_at_5, t0_.created_at AS created_at_6, t0_.updated_at AS updated_at_7, a1_.id AS id_8, a1_.email AS email_9, a1_.roles AS roles_10, a1_.password AS password_11, a1_.first_name AS first_name_12, a1_.last_name AS last_name_13, a1_.is_active AS is_active_14, a1_.created_at AS created_at_15, a1_.updated_at AS updated_at_16, a1_.disabled_at AS disabled_at_17, a1_.last_login_at AS last_login_at_18, t0_.campaign_id AS campaign_id_19, t0_.student_id AS student_id_20 FROM technology_watch_campaign_student t0_ LEFT JOIN app_user a1_ ON t0_.student_id = a1_.id WHERE t0_.campaign_id = ? ORDER BY a1_.last_name ASC, a1_.first_name ASC"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#757
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.grade AS grade_1, t0_.comment AS comment_2, t0_.evaluated_at AS evaluated_at_3, t0_.updated_at AS updated_at_4, a1_.id AS id_5, a1_.email AS email_6, a1_.roles AS roles_7, a1_.password AS password_8, a1_.first_name AS first_name_9, a1_.last_name AS last_name_10, a1_.is_active AS is_active_11, a1_.created_at AS created_at_12, a1_.updated_at AS updated_at_13, a1_.disabled_at AS disabled_at_14, a1_.last_login_at AS last_login_at_15, a2_.id AS id_16, a2_.email AS email_17, a2_.roles AS roles_18, a2_.password AS password_19, a2_.first_name AS first_name_20, a2_.last_name AS last_name_21, a2_.is_active AS is_active_22, a2_.created_at AS created_at_23, a2_.updated_at AS updated_at_24, a2_.disabled_at AS disabled_at_25, a2_.last_login_at AS last_login_at_26, t0_.campaign_id AS campaign_id_27, t0_.student_id AS student_id_28, t0_.evaluated_by_id AS evaluated_by_id_29 FROM technology_watch_campaign_evaluation t0_ LEFT JOIN app_user a1_ ON t0_.student_id = a1_.id LEFT JOIN app_user a2_ ON t0_.evaluated_by_id = a2_.id WHERE t0_.campaign_id = ? ORDER BY a1_.last_name ASC, a1_.first_name ASC"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#757
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.article_count AS article_count_1, t0_.result AS result_2, t0_.evaluated_at AS evaluated_at_3, t0_.notification_sent_at AS notification_sent_at_4, t0_.reminder_sent_at AS reminder_sent_at_5, t0_.created_at AS created_at_6, t0_.updated_at AS updated_at_7, a1_.id AS id_8, a1_.email AS email_9, a1_.roles AS roles_10, a1_.password AS password_11, a1_.first_name AS first_name_12, a1_.last_name AS last_name_13, a1_.is_active AS is_active_14, a1_.created_at AS created_at_15, a1_.updated_at AS updated_at_16, a1_.disabled_at AS disabled_at_17, a1_.last_login_at AS last_login_at_18, t0_.campaign_id AS campaign_id_19, t0_.student_id AS student_id_20 FROM technology_watch_campaign_student t0_ LEFT JOIN app_user a1_ ON t0_.student_id = a1_.id WHERE t0_.campaign_id = ? ORDER BY a1_.last_name ASC, a1_.first_name ASC"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#757
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.grade AS grade_1, t0_.comment AS comment_2, t0_.evaluated_at AS evaluated_at_3, t0_.updated_at AS updated_at_4, a1_.id AS id_5, a1_.email AS email_6, a1_.roles AS roles_7, a1_.password AS password_8, a1_.first_name AS first_name_9, a1_.last_name AS last_name_10, a1_.is_active AS is_active_11, a1_.created_at AS created_at_12, a1_.updated_at AS updated_at_13, a1_.disabled_at AS disabled_at_14, a1_.last_login_at AS last_login_at_15, a2_.id AS id_16, a2_.email AS email_17, a2_.roles AS roles_18, a2_.password AS password_19, a2_.first_name AS first_name_20, a2_.last_name AS last_name_21, a2_.is_active AS is_active_22, a2_.created_at AS created_at_23, a2_.updated_at AS updated_at_24, a2_.disabled_at AS disabled_at_25, a2_.last_login_at AS last_login_at_26, t0_.campaign_id AS campaign_id_27, t0_.student_id AS student_id_28, t0_.evaluated_by_id AS evaluated_by_id_29 FROM technology_watch_campaign_evaluation t0_ LEFT JOIN app_user a1_ ON t0_.student_id = a1_.id LEFT JOIN app_user a2_ ON t0_.evaluated_by_id = a2_.id WHERE t0_.campaign_id = ? ORDER BY a1_.last_name ASC, a1_.first_name ASC"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#757
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT u0_.id AS id_0, u0_.alert_key AS alert_key_1, u0_.read_at AS read_at_2, u0_.dismissed_at AS dismissed_at_3, u0_.created_at AS created_at_4, u0_.updated_at AS updated_at_5, u0_.user_id AS user_id_6 FROM user_alert_state u0_ WHERE u0_.user_id = ? AND u0_.alert_key IN (?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => 1
    2 => "follow_up_admin_9b8a8f5fbf23"
    3 => "follow_up_admin_8e7b405a8078"
    4 => "contract_admin_78c52a66163b"
    5 => "canteen_admin_e526459c9088"
    6 => "canteen_admin_e58179be868e"
    7 => "ancillary_fee_admin_021e0af576a4"
    8 => "convocation_admin_4283efc3d9ae"
    9 => "convocation_admin_8cbe452cac84"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#757
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1190
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#1190}
    4 => Doctrine\DBAL\ParameterType {#1190}
    5 => Doctrine\DBAL\ParameterType {#1190}
    6 => Doctrine\DBAL\ParameterType {#1190}
    7 => Doctrine\DBAL\ParameterType {#1190}
    8 => Doctrine\DBAL\ParameterType {#1190}
    9 => Doctrine\DBAL\ParameterType {#1190}
  ]
]

[
  "key" => "_security_main"
]