Query Metrics
9
Database Queries
4
Different statements
18.23 ms
Query time
7
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
5.91 ms (32.45%) |
4 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.price AS price_4, t0.credit AS credit_5, t0.training_id AS training_id_6 FROM edition t0 WHERE t0.id = ?
Parameters:
[
7
]
|
5.13 ms (28.17%) |
1 |
SELECT p0_.id AS id_0, p0_.code AS code_1, p0_.concept AS concept_2, p0_.name AS name_3, p0_.price AS price_4, p0_.credit AS credit_5, p0_.start_date AS start_date_6, p0_.end_date AS end_date_7, p0_.end_date_access_moodle_course AS end_date_access_moodle_course_8, p0_.payment_type AS payment_type_9, p0_.first_period AS first_period_10, p0_.access_test_dates AS access_test_dates_11, p0_.preregistration_price AS preregistration_price_12, p0_.public_credit_price AS public_credit_price_13, p0_.private_credit_price AS private_credit_price_14, p0_.public_credit AS public_credit_15, p0_.private_credit AS private_credit_16, p0_.school_insurance_price AS school_insurance_price_17, p0_.accessories_price AS accessories_price_18, p0_.expedient_price AS expedient_price_19, p0_.ubrate_price AS ubrate_price_20, p0_.public_credit_price_with_specific_degree AS public_credit_price_with_specific_degree_21, p0_.student_email_notification AS student_email_notification_22, p0_.modality_list AS modality_list_23, p0_.modality_course_list AS modality_course_list_24, p0_.itinerary_course_list AS itinerary_course_list_25, p0_.speciality AS speciality_26, p0_.moodle_courses AS moodle_courses_27, p0_.edition_id AS edition_id_28, p0_.rectification_invoice_id AS rectification_invoice_id_29 FROM period p0_ WHERE p0_.start_date <= ? AND p0_.end_date >= ? AND p0_.first_period = 1 ORDER BY p0_.end_date ASC
Parameters:
[ "2024-12-23 04:42:46" "2024-12-23 04:42:46" ] |
4.02 ms (22.05%) |
3 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.type AS type_4, t0.registration_type AS registration_type_5, t0.url AS url_6 FROM training t0 WHERE t0.id = ?
Parameters:
[
4
]
|
3.16 ms (17.34%) |
1 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.concept AS concept_3, t0.name AS name_4, t0.price AS price_5, t0.credit AS credit_6, t0.start_date AS start_date_7, t0.end_date AS end_date_8, t0.end_date_access_moodle_course AS end_date_access_moodle_course_9, t0.payment_type AS payment_type_10, t0.first_period AS first_period_11, t0.access_test_dates AS access_test_dates_12, t0.preregistration_price AS preregistration_price_13, t0.public_credit_price AS public_credit_price_14, t0.private_credit_price AS private_credit_price_15, t0.public_credit AS public_credit_16, t0.private_credit AS private_credit_17, t0.school_insurance_price AS school_insurance_price_18, t0.accessories_price AS accessories_price_19, t0.expedient_price AS expedient_price_20, t0.ubrate_price AS ubrate_price_21, t0.public_credit_price_with_specific_degree AS public_credit_price_with_specific_degree_22, t0.student_email_notification AS student_email_notification_23, t0.modality_list AS modality_list_24, t0.modality_course_list AS modality_course_list_25, t0.itinerary_course_list AS itinerary_course_list_26, t0.speciality AS speciality_27, t0.moodle_courses AS moodle_courses_28, t0.edition_id AS edition_id_29, t0.rectification_invoice_id AS rectification_invoice_id_30 FROM period t0
Parameters:
[] |
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\Period |
|
App\Entity\Edition | No errors. |
App\Entity\RectificationInvoice |
|
App\Entity\StudentAttachmentsBase | No errors. |
App\Entity\StudentTrainingBase |
|
App\Entity\StudentTrainingMudoi |
|
App\Entity\StudentTrainingMds |
|
App\Entity\StudentTrainingCourse |
|
App\Entity\StudentTrainingStandard | No errors. |
App\Entity\Payment | No errors. |
App\Entity\Invoice |
|
App\Entity\Coupon | No errors. |
App\Entity\Training | No errors. |
App\Entity\User | No errors. |