Query Metrics
4
Database Queries
4
Different statements
44.11 ms
Query time
5
Invalid entities
Grouped Statements
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 |
|
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 |
|
App\Entity\Educational\Domain |
|
App\Entity\Users\Teacher |
|
App\Entity\Educational\Course |
|