GET https://ceibarcelona.servidortemporal.net/

Query Metrics

9 Database Queries
4 Different statements
14.60 ms Query time
7 Invalid entities

Grouped Statements

Show all queries

Time Count Info
5.68 ms
(38.93%)
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
]
3.81 ms
(26.12%)
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
]
2.71 ms
(18.54%)
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:
[]
2.39 ms
(16.41%)
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-22 12:46:38"
  "2024-12-22 12:46:38"
]

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
  • The field App\Entity\Period#rectificationInvoice is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\RectificationInvoice#period does not contain the required 'mappedBy="rectificationInvoice"' attribute.
  • If association App\Entity\Period#rectificationInvoice is many-to-one, then the inversed side App\Entity\RectificationInvoice#period has to be one-to-many.
App\Entity\Edition No errors.
App\Entity\RectificationInvoice
  • The association App\Entity\RectificationInvoice#invoice refers to the inverse side field App\Entity\Invoice#rectificationInvoice which does not exist.
  • The field App\Entity\RectificationInvoice#period is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Period#rectificationInvoice does not contain the required 'mappedBy="period"' attribute.
  • If association App\Entity\RectificationInvoice#period is many-to-one, then the inversed side App\Entity\Period#rectificationInvoice has to be one-to-many.
  • The association App\Entity\RectificationInvoice#student refers to the inverse side field App\Entity\Student#rectificationInvoice which does not exist.
App\Entity\StudentAttachmentsBase No errors.
App\Entity\StudentTrainingBase
  • The field 'App\Entity\StudentTrainingBase#spanishCollege' has the property type 'string' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
App\Entity\StudentTrainingMudoi
  • The field 'App\Entity\StudentTrainingMudoi#spanishCollege' has the property type 'string' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
App\Entity\StudentTrainingMds
  • The field 'App\Entity\StudentTrainingMds#spanishCollege' has the property type 'string' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
App\Entity\StudentTrainingCourse
  • The field 'App\Entity\StudentTrainingCourse#spanishCollege' has the property type 'string' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
App\Entity\StudentTrainingStandard No errors.
App\Entity\Payment No errors.
App\Entity\Invoice
  • The mappings App\Entity\Invoice#rectificationInvoices and App\Entity\RectificationInvoice#invoice are inconsistent with each other.
App\Entity\Coupon No errors.
App\Entity\Training No errors.
App\Entity\User No errors.