Query Metrics

4 Database Queries
4 Different statements
44.11 ms Query time
5 Invalid entities

Grouped Statements

Show all queries

default connection

Time Count Info
17.34 ms
(39.32%)
1
SELECT t0.id AS id_1, t0.started AS started_2, t0.ended AS ended_3, t0.ready AS ready_4, t0.url_video AS url_video_5, t0.url_video_poster AS url_video_poster_6, t0.picture AS picture_7, t0.picture_popin AS picture_popin_8, t0.text_headband AS text_headband_9, t0.url_headband AS url_headband_10, t0.date_headband AS date_headband_11, t0.subscription_started AS subscription_started_12, t0.subscription_ended AS subscription_ended_13, t0.numberlimit AS numberlimit_14, t0.title AS title_15, t0.slug AS slug_16, t0.number_day AS number_day_17, t0.description AS description_18, t0.online AS online_19, t0.number_select_discipline AS number_select_discipline_20, t0.restriction_courses AS restriction_courses_21, t0.summer AS summer_22, t0.display_popin_registration AS display_popin_registration_23, t0.type AS type_24, t0.grab_title AS grab_title_25, t0.sub_title AS sub_title_26, t0.course_id AS course_id_27, t0.discipline_id AS discipline_id_28, t0.discr FROM EventTraining t0 INNER JOIN type_offer_pack ON t0.id = type_offer_pack.pack_id WHERE type_offer_pack.type_offer_id = ? AND t0.discr IN ('pack')
Parameters:
[
  3
]
9.04 ms
(20.50%)
1
SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.price AS price_2, a1_.old_price AS old_price_3, a1_.nbr_dis AS nbr_dis_4 FROM admin_mission a1_ INNER JOIN new_offer n0_ ON a1_.id = n0_.id INNER JOIN type_offer t2_ ON n0_.type_offer_id = t2_.id WHERE t2_.slug = ? AND t2_.online = 1 AND n0_.online = 1
Parameters:
[
  "mission-bac"
]
9.00 ms
(20.40%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.lesson_title AS lesson_title_3, t0.slug AS slug_4, t0.slug_lesson AS slug_lesson_5, t0.front AS front_6, t0.order AS order_7, t0.speciality AS speciality_8, t0.exam AS exam_9, t0.main_color AS main_color_10, t0.gradient_color AS gradient_color_11, t0.published AS published_12, t0.color AS color_13, t0.style AS style_14 FROM admin_discipline t0
Parameters:
[]
8.73 ms
(19.78%)
1
SELECT t0.id AS id_1, t0.online AS online_2, t0.title AS title_3, t0.text_paid AS text_paid_4, t0.grab AS grab_5, t0.description AS description_6, t0.slug AS slug_7, t0.display_pack AS display_pack_8 FROM type_offer t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "mission-bac"
]

Database Connections

Name Service
default doctrine.dbal.default_connection
wp doctrine.dbal.wp_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\Users\User No errors.
App\Entity\Management\Subscription\Subscription
  • The association App\Entity\Management\Subscription\Subscription#student refers to the inverse side field App\Entity\Users\Child#offers which does not exist.
App\Entity\Management\Subscription\Offer No errors.
App\Entity\Management\Subscription\Mission No errors.
App\Entity\Management\Subscription\TypeOffer No errors.
App\Entity\Event\Training\AbstractEventTraining No errors.
App\Entity\Event\Training\Pack No errors.
App\Entity\Educational\Discipline
  • The mappings App\Entity\Educational\Discipline#domains and App\Entity\Educational\Domain#discipline are inconsistent with each other.
App\Entity\Educational\Domain
  • The association App\Entity\Educational\Domain#discipline refers to the inverse side field App\Entity\Educational\Discipline#domain which does not exist.
App\Entity\Users\Teacher
  • The association App\Entity\Users\Teacher#students refers to the owning side field App\Entity\Users\Child#teacher which does not exist.
App\Entity\Educational\Course
  • The mappings App\Entity\Educational\Course#students and App\Entity\Users\Child#course are inconsistent with each other.