User Deprecated: The Liip\ImagineBundle\Templating\FilterExtension class is deprecated since version 2.7 and will be removed in 3.0; configure "liip_imagine.twig.mode" to "lazy" instead.
User Deprecated: Since symfony/framework-bundle 5.3: The "session.storage.metadata_bag" service is deprecated, create your own "session.storage.factory" instead.
User Deprecated: Since symfony/security-guard 5.3: The "Symfony\Component\Security\Guard\PasswordAuthenticatedInterface" class is deprecated, use the new authenticator system instead.
User Deprecated: Since symfony/security-bundle 5.3: The ".container.private.security.password_encoder" service is deprecated, use "security.user_password_hasher" instead.
User Deprecated: Since symfony/security-core 5.3: The "Symfony\Component\Security\Core\Encoder\UserPasswordEncoder" class is deprecated, use "Symfony\Component\PasswordHasher\Hasher\UserPasswordHasher" instead.
User Deprecated: Since symfony/security-core 5.3: The "Symfony\Component\Security\Core\Encoder\UserPasswordEncoderInterface" interface is deprecated, use "Symfony\Component\PasswordHasher\Hasher\UserPasswordHasherInterface" instead.
User Deprecated: Since symfony/security-bundle 5.3: The "security.encoder_factory.generic" service is deprecated, use "security.password_hasher_factory" instead.
User Deprecated: Since symfony/security-core 5.3: The "Symfony\Component\Security\Core\Encoder\EncoderFactory" class is deprecated, use "Symfony\Component\PasswordHasher\Hasher\PasswordHasherFactory" instead.
User Deprecated: Since symfony/security-core 5.3: The "Symfony\Component\Security\Core\Encoder\EncoderFactoryInterface" class is deprecated, use "Symfony\Component\PasswordHasher\Hasher\PasswordHasherFactoryInterface" instead.
User Deprecated: Since symfony/security-http 5.4: The "Symfony\Component\Security\Http\RememberMe\RememberMeServicesInterface" interface is deprecated, use "Symfony\Component\Security\Http\RememberMe\RememberMeHandlerInterface" instead.
User Deprecated: Since symfony/security-http 5.4: The "Symfony\Component\Security\Http\RememberMe\AbstractRememberMeServices" class is deprecated, use "Symfony\Component\Security\Http\RememberMe\AbstractRememberMeHandler" instead.
User Deprecated: Since symfony/security-http 5.4: The "Symfony\Component\Security\Http\RememberMe\TokenBasedRememberMeServices" class is deprecated, use "Symfony\Component\Security\Http\RememberMe\SignatureRememberMeHandler" instead.
User Deprecated: Since symfony/security-http 5.4: Method "Symfony\Component\Security\Http\Firewall\ContextListener::setRememberMeServices()" is deprecated, use the new remember me handlers instead.
User Deprecated: Since symfony/security-bundle 5.3: The "security.authentication.listener.guard.main" service is deprecated, use the new authenticator system instead.
User Deprecated: Since symfony/security-bundle 5.3: The "security.authentication.guard_handler" service is deprecated, use the new authenticator system instead.
User Deprecated: Since symfony/security-guard 5.3: The "Symfony\Component\Security\Guard\GuardAuthenticatorHandler" class is deprecated, use the new authenticator system instead.
User Deprecated: Since symfony/security-bundle 5.3: The "security.authentication.manager" service is deprecated, use the new authenticator system instead.
User Deprecated: Since symfony/security-core 5.3: The "Symfony\Component\Security\Core\Authentication\AuthenticationProviderManager" class is deprecated, use the new authenticator system instead.
User Deprecated: Since symfony/security-core 5.3: The "Symfony\Component\Security\Core\Event\AuthenticationFailureEvent" class is deprecated, use "Symfony\Component\Security\Http\Event\LoginFailureEvent" with the new authenticator system instead.
User Deprecated: Since symfony/security-guard 5.3: The "Symfony\Component\Security\Guard\Firewall\GuardAuthenticationListener" class is deprecated, use the new authenticator system instead.
User Deprecated: Since symfony/security-bundle 5.3: The "security.authentication.listener.rememberme.main" service is deprecated, use the new authenticator system instead.
User Deprecated: Since symfony/security-http 5.3: The "Symfony\Component\Security\Http\Firewall\RememberMeListener" class is deprecated, use the new authenticator system instead.
User Deprecated: Since symfony/security-bundle 5.3: The "security.authentication.listener.anonymous.main" service is deprecated, use the new authenticator system instead.
User Deprecated: Since symfony/security-http 5.3: The "Symfony\Component\Security\Http\Firewall\AnonymousAuthenticationListener" class is deprecated, use the new authenticator system instead.
User Deprecated: Since symfony/security-http 5.4: The $authManager argument of "Symfony\Component\Security\Http\Firewall\AccessListener::__construct" is deprecated.
User Deprecated: Since symfony/security-http 5.4: Not setting the $exceptionOnNoToken argument of "Symfony\Component\Security\Http\Firewall\AccessListener::__construct" to "false" is deprecated.
User Deprecated: Since symfony/framework-bundle 5.3: The "session.storage.factory.service" service is deprecated, use "session.storage.factory.native", "session.storage.factory.php_bridge" or "session.storage.factory.mock_file" instead.
User Deprecated: The "Sensio\Bundle\FrameworkExtraBundle\Configuration\Method" annotation is deprecated since version 5.2. Use "Symfony\Component\Routing\Annotation\Route" instead.
"SELECT t0.id AS id_1, t0.name AS name_2, t0.apc AS apc_3, t0.level_id AS level_id_4 FROM class_room t0 WHERE t0.id = ?"
(parameters:
[1 => "17"
]
, types:
[1 => 1]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.apc AS apc_3, t0.level_id AS level_id_4 FROM class_room t0 WHERE t0.id = ?"
"params" => [1 => "17"
]
"types" => [1 => 1]
]
deprecation
Deprecated: Return type of App\Entity\Sequence::jsonSerialize() should either be compatible with JsonSerializable::jsonSerialize(): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice
User Deprecated: Since symfony/security-core 5.4: Not setting the 5th argument of "Symfony\Component\Security\Core\Authorization\AuthorizationChecker::__construct" to "false" is deprecated.
"SELECT t0.id AS id_1, t0.registration_deadline AS registration_deadline_2, t0.rate AS rate_3, t0.code AS code_4, t0.wording AS wording_5, t0.start_date AS start_date_6, t0.end_date AS end_date_7, t0.activated AS activated_8, t9.id AS id_10, t9.weight AS weight_11, t9.school_year_id AS school_year_id_12 FROM school_year t0 LEFT JOIN payment_plan t9 ON t9.school_year_id = t0.id WHERE t0.activated = ? LIMIT 1"
(parameters:
[1 => 1]
, types:
[1 => 5]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.registration_deadline AS registration_deadline_2, t0.rate AS rate_3, t0.code AS code_4, t0.wording AS wording_5, t0.start_date AS start_date_6, t0.end_date AS end_date_7, t0.activated AS activated_8, t9.id AS id_10, t9.weight AS weight_11, t9.school_year_id AS school_year_id_12 FROM school_year t0 LEFT JOIN payment_plan t9 ON t9.school_year_id = t0.id WHERE t0.activated = ? LIMIT 1"
"params" => [1 => 1]
"types" => [1 => 5]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.validation_date AS validation_date_2, t0.code AS code_3, t0.wording AS wording_4, t0.start_date AS start_date_5, t0.end_date AS end_date_6, t0.activated AS activated_7, t0.quater_id AS quater_id_8 FROM sequence t0 WHERE t0.activated = ? LIMIT 1"
(parameters:
[1 => 1]
, types:
[1 => 5]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.validation_date AS validation_date_2, t0.code AS code_3, t0.wording AS wording_4, t0.start_date AS start_date_5, t0.end_date AS end_date_6, t0.activated AS activated_7, t0.quater_id AS quater_id_8 FROM sequence t0 WHERE t0.activated = ? LIMIT 1"
"params" => [1 => 1]
"types" => [1 => 5]
]
debug
Executing statement:
"SELECT s0_.id AS id_0, s0_.matricule AS matricule_1, s0_.firstname AS firstname_2, s0_.lastname AS lastname_3, s0_.particular_disease AS particular_disease_4, s0_.father_name AS father_name_5, s0_.mother_name AS mother_name_6, s0_.primary_contact AS primary_contact_7, s0_.residence AS residence_8, s0_.secondary_contact AS secondary_contact_9, s0_.other_informations AS other_informations_10, s0_.birthday AS birthday_11, s0_.gender AS gender_12, s0_.birthplace AS birthplace_13, s0_.enrolled AS enrolled_14, s0_.created_at AS created_at_15, s0_.updated_at AS updated_at_16, s0_.image_name AS image_name_17, s0_.entry_class_id AS entry_class_id_18 FROM student s0_ LEFT JOIN subscription s1_ ON s0_.id = s1_.student_id LEFT JOIN class_room c2_ ON s1_.class_room_id = c2_.id WHERE s1_.school_year_id = ? AND c2_.id = ? ORDER BY s0_.lastname ASC"
(parameters:
[1 => 72 => 17]
, types:
[1 => 12 => 1]
)
doctrine
[
"sql" => "SELECT s0_.id AS id_0, s0_.matricule AS matricule_1, s0_.firstname AS firstname_2, s0_.lastname AS lastname_3, s0_.particular_disease AS particular_disease_4, s0_.father_name AS father_name_5, s0_.mother_name AS mother_name_6, s0_.primary_contact AS primary_contact_7, s0_.residence AS residence_8, s0_.secondary_contact AS secondary_contact_9, s0_.other_informations AS other_informations_10, s0_.birthday AS birthday_11, s0_.gender AS gender_12, s0_.birthplace AS birthplace_13, s0_.enrolled AS enrolled_14, s0_.created_at AS created_at_15, s0_.updated_at AS updated_at_16, s0_.image_name AS image_name_17, s0_.entry_class_id AS entry_class_id_18 FROM student s0_ LEFT JOIN subscription s1_ ON s0_.id = s1_.student_id LEFT JOIN class_room c2_ ON s1_.class_room_id = c2_.id WHERE s1_.school_year_id = ? AND c2_.id = ? ORDER BY s0_.lastname ASC"
"params" => [1 => 72 => 17]
"types" => [1 => 12 => 1]
]
debug
Executing statement:
"SELECT a0_.id AS id_0, a0_.head_teacher AS head_teacher_1, a0_.course_id AS course_id_2, a0_.teacher_id AS teacher_id_3, a0_.year_id AS year_id_4 FROM attribution a0_ LEFT JOIN school_year s1_ ON a0_.year_id = s1_.id LEFT JOIN course c2_ ON a0_.course_id = c2_.id LEFT JOIN module m3_ ON c2_.module_id = m3_.id LEFT JOIN class_room c4_ ON m3_.room_id = c4_.id WHERE s1_.id = ? AND c4_.id = ?"
(parameters:
[1 => 72 => 17]
, types:
[1 => 12 => 1]
)
doctrine
[
"sql" => "SELECT a0_.id AS id_0, a0_.head_teacher AS head_teacher_1, a0_.course_id AS course_id_2, a0_.teacher_id AS teacher_id_3, a0_.year_id AS year_id_4 FROM attribution a0_ LEFT JOIN school_year s1_ ON a0_.year_id = s1_.id LEFT JOIN course c2_ ON a0_.course_id = c2_.id LEFT JOIN module m3_ ON c2_.module_id = m3_.id LEFT JOIN class_room c4_ ON m3_.room_id = c4_.id WHERE s1_.id = ? AND c4_.id = ?"
"params" => [1 => 72 => 17]
"types" => [1 => 12 => 1]
]
debug
Executing statement:
"SELECT COUNT(s0_.id) AS sclr_0, s0_.officialExamResult AS officialExamResult_1 FROM subscription s0_ LEFT JOIN school_year s1_ ON s0_.school_year_id = s1_.id LEFT JOIN class_room c2_ ON s0_.class_room_id = c2_.id WHERE s1_.id = ? AND c2_.id = ? GROUP BY s0_.officialExamResult"
(parameters:
[1 => 72 => 17]
, types:
[1 => 12 => 1]
)
doctrine
[
"sql" => "SELECT COUNT(s0_.id) AS sclr_0, s0_.officialExamResult AS officialExamResult_1 FROM subscription s0_ LEFT JOIN school_year s1_ ON s0_.school_year_id = s1_.id LEFT JOIN class_room c2_ ON s0_.class_room_id = c2_.id WHERE s1_.id = ? AND c2_.id = ? GROUP BY s0_.officialExamResult"
"params" => [1 => 72 => 17]
"types" => [1 => 12 => 1]
]
debug
Executing statement:
"SELECT s0_.id AS id_0, s0_.validation_date AS validation_date_1, s0_.code AS code_2, s0_.wording AS wording_3, s0_.start_date AS start_date_4, s0_.end_date AS end_date_5, s0_.activated AS activated_6, s0_.quater_id AS quater_id_7 FROM sequence s0_ LEFT JOIN quater q1_ ON s0_.quater_id = q1_.id LEFT JOIN school_year s2_ ON q1_.school_year_id = s2_.id WHERE s2_.id = ?"
(parameters:
[1 => 7]
, types:
[1 => 1]
)
doctrine
[
"sql" => "SELECT s0_.id AS id_0, s0_.validation_date AS validation_date_1, s0_.code AS code_2, s0_.wording AS wording_3, s0_.start_date AS start_date_4, s0_.end_date AS end_date_5, s0_.activated AS activated_6, s0_.quater_id AS quater_id_7 FROM sequence s0_ LEFT JOIN quater q1_ ON s0_.quater_id = q1_.id LEFT JOIN school_year s2_ ON q1_.school_year_id = s2_.id WHERE s2_.id = ?"
"params" => [1 => 7]
"types" => [1 => 1]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.moyenne AS moyenne_2, t0.competence AS competence_3, t0.abscent AS abscent_4, t0.success_h AS success_h_5, t0.success_f AS success_f_6, t0.faillures_h AS faillures_h_7, t0.faillures_f AS faillures_f_8, t0.mini AS mini_9, t0.maxi AS maxi_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sequence_id AS sequence_id_13, t0.course_id AS course_id_14, t0.class_room_id AS class_room_id_15, t0.author_id AS author_id_16 FROM evaluation t0 WHERE t0.class_room_id = ? AND t0.sequence_id = ?"
(parameters:
[1 => 172 => 38]
, types:
[1 => 12 => 1]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.moyenne AS moyenne_2, t0.competence AS competence_3, t0.abscent AS abscent_4, t0.success_h AS success_h_5, t0.success_f AS success_f_6, t0.faillures_h AS faillures_h_7, t0.faillures_f AS faillures_f_8, t0.mini AS mini_9, t0.maxi AS maxi_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sequence_id AS sequence_id_13, t0.course_id AS course_id_14, t0.class_room_id AS class_room_id_15, t0.author_id AS author_id_16 FROM evaluation t0 WHERE t0.class_room_id = ? AND t0.sequence_id = ?"
"params" => [1 => 172 => 38]
"types" => [1 => 12 => 1]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.moyenne AS moyenne_2, t0.competence AS competence_3, t0.abscent AS abscent_4, t0.success_h AS success_h_5, t0.success_f AS success_f_6, t0.faillures_h AS faillures_h_7, t0.faillures_f AS faillures_f_8, t0.mini AS mini_9, t0.maxi AS maxi_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sequence_id AS sequence_id_13, t0.course_id AS course_id_14, t0.class_room_id AS class_room_id_15, t0.author_id AS author_id_16 FROM evaluation t0 WHERE t0.class_room_id = ? AND t0.sequence_id = ?"
(parameters:
[1 => 172 => 39]
, types:
[1 => 12 => 1]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.moyenne AS moyenne_2, t0.competence AS competence_3, t0.abscent AS abscent_4, t0.success_h AS success_h_5, t0.success_f AS success_f_6, t0.faillures_h AS faillures_h_7, t0.faillures_f AS faillures_f_8, t0.mini AS mini_9, t0.maxi AS maxi_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sequence_id AS sequence_id_13, t0.course_id AS course_id_14, t0.class_room_id AS class_room_id_15, t0.author_id AS author_id_16 FROM evaluation t0 WHERE t0.class_room_id = ? AND t0.sequence_id = ?"
"params" => [1 => 172 => 39]
"types" => [1 => 12 => 1]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.moyenne AS moyenne_2, t0.competence AS competence_3, t0.abscent AS abscent_4, t0.success_h AS success_h_5, t0.success_f AS success_f_6, t0.faillures_h AS faillures_h_7, t0.faillures_f AS faillures_f_8, t0.mini AS mini_9, t0.maxi AS maxi_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sequence_id AS sequence_id_13, t0.course_id AS course_id_14, t0.class_room_id AS class_room_id_15, t0.author_id AS author_id_16 FROM evaluation t0 WHERE t0.class_room_id = ? AND t0.sequence_id = ?"
(parameters:
[1 => 172 => 42]
, types:
[1 => 12 => 1]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.moyenne AS moyenne_2, t0.competence AS competence_3, t0.abscent AS abscent_4, t0.success_h AS success_h_5, t0.success_f AS success_f_6, t0.faillures_h AS faillures_h_7, t0.faillures_f AS faillures_f_8, t0.mini AS mini_9, t0.maxi AS maxi_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sequence_id AS sequence_id_13, t0.course_id AS course_id_14, t0.class_room_id AS class_room_id_15, t0.author_id AS author_id_16 FROM evaluation t0 WHERE t0.class_room_id = ? AND t0.sequence_id = ?"
"params" => [1 => 172 => 42]
"types" => [1 => 12 => 1]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.moyenne AS moyenne_2, t0.competence AS competence_3, t0.abscent AS abscent_4, t0.success_h AS success_h_5, t0.success_f AS success_f_6, t0.faillures_h AS faillures_h_7, t0.faillures_f AS faillures_f_8, t0.mini AS mini_9, t0.maxi AS maxi_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sequence_id AS sequence_id_13, t0.course_id AS course_id_14, t0.class_room_id AS class_room_id_15, t0.author_id AS author_id_16 FROM evaluation t0 WHERE t0.class_room_id = ? AND t0.sequence_id = ?"
(parameters:
[1 => 172 => 43]
, types:
[1 => 12 => 1]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.moyenne AS moyenne_2, t0.competence AS competence_3, t0.abscent AS abscent_4, t0.success_h AS success_h_5, t0.success_f AS success_f_6, t0.faillures_h AS faillures_h_7, t0.faillures_f AS faillures_f_8, t0.mini AS mini_9, t0.maxi AS maxi_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sequence_id AS sequence_id_13, t0.course_id AS course_id_14, t0.class_room_id AS class_room_id_15, t0.author_id AS author_id_16 FROM evaluation t0 WHERE t0.class_room_id = ? AND t0.sequence_id = ?"
"params" => [1 => 172 => 43]
"types" => [1 => 12 => 1]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.moyenne AS moyenne_2, t0.competence AS competence_3, t0.abscent AS abscent_4, t0.success_h AS success_h_5, t0.success_f AS success_f_6, t0.faillures_h AS faillures_h_7, t0.faillures_f AS faillures_f_8, t0.mini AS mini_9, t0.maxi AS maxi_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sequence_id AS sequence_id_13, t0.course_id AS course_id_14, t0.class_room_id AS class_room_id_15, t0.author_id AS author_id_16 FROM evaluation t0 WHERE t0.class_room_id = ? AND t0.sequence_id = ?"
(parameters:
[1 => 172 => 44]
, types:
[1 => 12 => 1]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.moyenne AS moyenne_2, t0.competence AS competence_3, t0.abscent AS abscent_4, t0.success_h AS success_h_5, t0.success_f AS success_f_6, t0.faillures_h AS faillures_h_7, t0.faillures_f AS faillures_f_8, t0.mini AS mini_9, t0.maxi AS maxi_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sequence_id AS sequence_id_13, t0.course_id AS course_id_14, t0.class_room_id AS class_room_id_15, t0.author_id AS author_id_16 FROM evaluation t0 WHERE t0.class_room_id = ? AND t0.sequence_id = ?"
"params" => [1 => 172 => 44]
"types" => [1 => 12 => 1]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.teacher_id AS teacher_id_4, t0.class_room_id AS class_room_id_5, t0.school_year_id AS school_year_id_6 FROM main_teacher t0 WHERE t0.class_room_id = ?"
(parameters:
[1 => 17]
, types:
[1 => 1]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.teacher_id AS teacher_id_4, t0.class_room_id AS class_room_id_5, t0.school_year_id AS school_year_id_6 FROM main_teacher t0 WHERE t0.class_room_id = ?"
"params" => [1 => 17]
"types" => [1 => 1]
]
"SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.is_verified AS is_verified_4, t0.avatarPath AS avatarPath_5, t0.phoneNumber AS phoneNumber_6, t0.gender AS gender_7, t0.birthday AS birthday_8, t0.birthplace AS birthplace_9, t0.nationality AS nationality_10, t0.location AS location_11, t0.region AS region_12, t0.department AS department_13, t0.academicLevel AS academicLevel_14, t0.numCni AS numCni_15, t0.status AS status_16, t0.full_name AS full_name_17, t0.security_question AS security_question_18, t0.security_answer AS security_answer_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.image_name AS image_name_22, t0.domain_id AS domain_id_23 FROM user t0 WHERE t0.id = ?"
(parameters:
[1 => 120]
, types:
[1 => 1]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.is_verified AS is_verified_4, t0.avatarPath AS avatarPath_5, t0.phoneNumber AS phoneNumber_6, t0.gender AS gender_7, t0.birthday AS birthday_8, t0.birthplace AS birthplace_9, t0.nationality AS nationality_10, t0.location AS location_11, t0.region AS region_12, t0.department AS department_13, t0.academicLevel AS academicLevel_14, t0.numCni AS numCni_15, t0.status AS status_16, t0.full_name AS full_name_17, t0.security_question AS security_question_18, t0.security_answer AS security_answer_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.image_name AS image_name_22, t0.domain_id AS domain_id_23 FROM user t0 WHERE t0.id = ?"
"params" => [1 => 120]
"types" => [1 => 1]
]
"SELECT t0.id AS id_1, t0.registration_deadline AS registration_deadline_2, t0.rate AS rate_3, t0.code AS code_4, t0.wording AS wording_5, t0.start_date AS start_date_6, t0.end_date AS end_date_7, t0.activated AS activated_8, t9.id AS id_10, t9.weight AS weight_11, t9.school_year_id AS school_year_id_12 FROM school_year t0 LEFT JOIN payment_plan t9 ON t9.school_year_id = t0.id WHERE t0.activated = ? LIMIT 1"
(parameters:
[1 => 1]
, types:
[1 => 5]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.registration_deadline AS registration_deadline_2, t0.rate AS rate_3, t0.code AS code_4, t0.wording AS wording_5, t0.start_date AS start_date_6, t0.end_date AS end_date_7, t0.activated AS activated_8, t9.id AS id_10, t9.weight AS weight_11, t9.school_year_id AS school_year_id_12 FROM school_year t0 LEFT JOIN payment_plan t9 ON t9.school_year_id = t0.id WHERE t0.activated = ? LIMIT 1"
"params" => [1 => 1]
"types" => [1 => 5]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.officialExamResult AS officialExamResult_2, t0.finance_holder AS finance_holder_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.student_id AS student_id_6, t0.class_room_id AS class_room_id_7, t0.school_year_id AS school_year_id_8 FROM subscription t0 WHERE t0.school_year_id = ?"
(parameters:
[1 => 7]
, types:
[1 => 1]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.officialExamResult AS officialExamResult_2, t0.finance_holder AS finance_holder_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.student_id AS student_id_6, t0.class_room_id AS class_room_id_7, t0.school_year_id AS school_year_id_8 FROM subscription t0 WHERE t0.school_year_id = ?"
"params" => [1 => 7]
"types" => [1 => 1]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.registration_deadline AS registration_deadline_2, t0.rate AS rate_3, t0.code AS code_4, t0.wording AS wording_5, t0.start_date AS start_date_6, t0.end_date AS end_date_7, t0.activated AS activated_8, t9.id AS id_10, t9.weight AS weight_11, t9.school_year_id AS school_year_id_12 FROM school_year t0 LEFT JOIN payment_plan t9 ON t9.school_year_id = t0.id WHERE t0.activated = ? LIMIT 1"
(parameters:
[1 => 1]
, types:
[1 => 5]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.registration_deadline AS registration_deadline_2, t0.rate AS rate_3, t0.code AS code_4, t0.wording AS wording_5, t0.start_date AS start_date_6, t0.end_date AS end_date_7, t0.activated AS activated_8, t9.id AS id_10, t9.weight AS weight_11, t9.school_year_id AS school_year_id_12 FROM school_year t0 LEFT JOIN payment_plan t9 ON t9.school_year_id = t0.id WHERE t0.activated = ? LIMIT 1"
"params" => [1 => 1]
"types" => [1 => 5]
]
debug
Executing statement:
"SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.password AS password_2, u0_.is_verified AS is_verified_3, u0_.avatarPath AS avatarPath_4, u0_.phoneNumber AS phoneNumber_5, u0_.gender AS gender_6, u0_.birthday AS birthday_7, u0_.birthplace AS birthplace_8, u0_.nationality AS nationality_9, u0_.location AS location_10, u0_.region AS region_11, u0_.department AS department_12, u0_.academicLevel AS academicLevel_13, u0_.numCni AS numCni_14, u0_.status AS status_15, u0_.full_name AS full_name_16, u0_.security_question AS security_question_17, u0_.security_answer AS security_answer_18, u0_.created_at AS created_at_19, u0_.updated_at AS updated_at_20, u0_.image_name AS image_name_21, u0_.domain_id AS domain_id_22 FROM user u0_ LEFT JOIN attribution a1_ ON u0_.id = a1_.teacher_id LEFT JOIN school_year s2_ ON a1_.year_id = s2_.id WHERE s2_.id = ? ORDER BY u0_.full_name ASC"
(parameters:
[1 => 7]
, types:
[1 => 1]
)
doctrine
[
"sql" => "SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.password AS password_2, u0_.is_verified AS is_verified_3, u0_.avatarPath AS avatarPath_4, u0_.phoneNumber AS phoneNumber_5, u0_.gender AS gender_6, u0_.birthday AS birthday_7, u0_.birthplace AS birthplace_8, u0_.nationality AS nationality_9, u0_.location AS location_10, u0_.region AS region_11, u0_.department AS department_12, u0_.academicLevel AS academicLevel_13, u0_.numCni AS numCni_14, u0_.status AS status_15, u0_.full_name AS full_name_16, u0_.security_question AS security_question_17, u0_.security_answer AS security_answer_18, u0_.created_at AS created_at_19, u0_.updated_at AS updated_at_20, u0_.image_name AS image_name_21, u0_.domain_id AS domain_id_22 FROM user u0_ LEFT JOIN attribution a1_ ON u0_.id = a1_.teacher_id LEFT JOIN school_year s2_ ON a1_.year_id = s2_.id WHERE s2_.id = ? ORDER BY u0_.full_name ASC"
"params" => [1 => 7]
"types" => [1 => 1]
]
debug
Executing query:
"SELECT t0.id AS id_1, t0.registration_deadline AS registration_deadline_2, t0.rate AS rate_3, t0.code AS code_4, t0.wording AS wording_5, t0.start_date AS start_date_6, t0.end_date AS end_date_7, t0.activated AS activated_8, t9.id AS id_10, t9.weight AS weight_11, t9.school_year_id AS school_year_id_12 FROM school_year t0 LEFT JOIN payment_plan t9 ON t9.school_year_id = t0.id"
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.registration_deadline AS registration_deadline_2, t0.rate AS rate_3, t0.code AS code_4, t0.wording AS wording_5, t0.start_date AS start_date_6, t0.end_date AS end_date_7, t0.activated AS activated_8, t9.id AS id_10, t9.weight AS weight_11, t9.school_year_id AS school_year_id_12 FROM school_year t0 LEFT JOIN payment_plan t9 ON t9.school_year_id = t0.id"
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.registration_deadline AS registration_deadline_2, t0.rate AS rate_3, t0.code AS code_4, t0.wording AS wording_5, t0.start_date AS start_date_6, t0.end_date AS end_date_7, t0.activated AS activated_8, t9.id AS id_10, t9.weight AS weight_11, t9.school_year_id AS school_year_id_12 FROM school_year t0 LEFT JOIN payment_plan t9 ON t9.school_year_id = t0.id WHERE t0.activated = ? LIMIT 1"
(parameters:
[1 => 1]
, types:
[1 => 5]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.registration_deadline AS registration_deadline_2, t0.rate AS rate_3, t0.code AS code_4, t0.wording AS wording_5, t0.start_date AS start_date_6, t0.end_date AS end_date_7, t0.activated AS activated_8, t9.id AS id_10, t9.weight AS weight_11, t9.school_year_id AS school_year_id_12 FROM school_year t0 LEFT JOIN payment_plan t9 ON t9.school_year_id = t0.id WHERE t0.activated = ? LIMIT 1"
"params" => [1 => 1]
"types" => [1 => 5]
]
debug
Executing statement:
"SELECT COUNT(c0_.id) AS sclr_0, c0_.id AS id_1 FROM class_room c0_ INNER JOIN subscription s1_ ON c0_.id = s1_.class_room_id WHERE s1_.school_year_id = ? GROUP BY c0_.id"
(parameters:
[1 => 7]
, types:
[1 => 1]
)
doctrine
[
"sql" => "SELECT COUNT(c0_.id) AS sclr_0, c0_.id AS id_1 FROM class_room c0_ INNER JOIN subscription s1_ ON c0_.id = s1_.class_room_id WHERE s1_.school_year_id = ? GROUP BY c0_.id"
"params" => [1 => 7]
"types" => [1 => 1]
]
"SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.room_id AS room_id_4 FROM module t0 WHERE t0.room_id = ?"
(parameters:
[1 => 17]
, types:
[1 => 1]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.room_id AS room_id_4 FROM module t0 WHERE t0.room_id = ?"
"params" => [1 => 17]
"types" => [1 => 1]
]
debug
Executing statement:
"SELECT t0.id AS id_1, t0.wording AS wording_2, t0.coefficient AS coefficient_3, t0.code AS code_4, t0.domain_id AS domain_id_5, t0.module_id AS module_id_6 FROM course t0 WHERE t0.module_id = ?"
(parameters:
[1 => 10]
, types:
[1 => 1]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.wording AS wording_2, t0.coefficient AS coefficient_3, t0.code AS code_4, t0.domain_id AS domain_id_5, t0.module_id AS module_id_6 FROM course t0 WHERE t0.module_id = ?"
"params" => [1 => 10]
"types" => [1 => 1]
]
"SELECT t0.id AS id_1, t0.wording AS wording_2, t0.coefficient AS coefficient_3, t0.code AS code_4, t0.domain_id AS domain_id_5, t0.module_id AS module_id_6 FROM course t0 WHERE t0.module_id = ?"
(parameters:
[1 => 12]
, types:
[1 => 1]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.wording AS wording_2, t0.coefficient AS coefficient_3, t0.code AS code_4, t0.domain_id AS domain_id_5, t0.module_id AS module_id_6 FROM course t0 WHERE t0.module_id = ?"
"params" => [1 => 12]
"types" => [1 => 1]
]
"SELECT t0.id AS id_1, t0.wording AS wording_2, t0.coefficient AS coefficient_3, t0.code AS code_4, t0.domain_id AS domain_id_5, t0.module_id AS module_id_6 FROM course t0 WHERE t0.module_id = ?"
(parameters:
[1 => 17]
, types:
[1 => 1]
)
doctrine
[
"sql" => "SELECT t0.id AS id_1, t0.wording AS wording_2, t0.coefficient AS coefficient_3, t0.code AS code_4, t0.domain_id AS domain_id_5, t0.module_id AS module_id_6 FROM course t0 WHERE t0.module_id = ?"
"params" => [1 => 17]
"types" => [1 => 1]
]
User Deprecated: Since symfony/security-bundle 5.4: Setting the $authenticatorManagerEnabled argument of "Symfony\Bundle\SecurityBundle\DataCollector\SecurityDataCollector::__construct" to "false" is deprecated, use the new authenticator system instead.
User Deprecated: Since symfony/security-bundle 5.4: The "Symfony\Bundle\SecurityBundle\Security\FirewallConfig::allowsAnonymous()" method is deprecated.
[
"sql" => """
SELECT DISTINCT k.CONSTRAINT_NAME,\n k.COLUMN_NAME,\n k.REFERENCED_TABLE_NAME,\n k.REFERENCED_COLUMN_NAME,\n k.ORDINAL_POSITION /*!50116,\n c.UPDATE_RULE,\n c.DELETE_RULE */\nFROM information_schema.key_column_usage k /*!50116\nINNER JOIN information_schema.referential_constraints c\nON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME\nAND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = 'bethesda' */ ORDER BY k.ORDINAL_POSITION
"""
"params" => [1 => "bethesda"
2 => "doctrine_migration_versions"
]
"types" => [1 => 22 => 2]
]
debug
Executing statement:
"""
SELECT c.COLUMN_NAME AS field,\n IF(\n c.COLUMN_TYPE = 'longtext'\n AND EXISTS(\n SELECT * from information_schema.CHECK_CONSTRAINTS i_c\n WHERE i_c.CONSTRAINT_SCHEMA = 'bethesda'\n AND i_c.TABLE_NAME = c.TABLE_NAME\n AND i_c.CHECK_CLAUSE = CONCAT(\n 'json_valid(`',\n c.COLUMN_NAME,\n '`)'\n )\n ),\n 'json',\n c.COLUMN_TYPE\n ) AS type,\n c.IS_NULLABLE AS `null`,\n c.COLUMN_KEY AS `key`,\n c.COLUMN_DEFAULT AS `default`,\n c.EXTRA,\n c.COLUMN_COMMENT AS comment,\n c.CHARACTER_SET_NAME AS characterset,\n c.COLLATION_NAME AS collation\nFROM information_schema.COLUMNS c\n INNER JOIN information_schema.TABLES t\n ON t.TABLE_NAME = c.TABLE_NAME\n WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION
"""