Query Metrics
6
Database Queries
6
Different statements
2.40 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.70 ms |
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.date_publication AS date_publication_2, b0_.content AS content_3, b0_.file AS file_4, b0_.published AS published_5, b0_.intro AS intro_6, b0_.picture AS picture_7, b0_.picture_alt AS picture_alt_8, b0_.meta_description AS meta_description_9, b0_.frontpage AS frontpage_10, b0_.text_file AS text_file_11, b0_.category_id AS category_id_12 FROM blog_article b0_ WHERE b0_.frontpage = 1 AND b0_.published = 1 AND b0_.date_publication <= CURRENT_DATE
Parameters:
[] |
| 2 | 0.55 ms |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.level AS level_2, s0_.price_ht AS price_ht_3, s0_.tva AS tva_4, s0_.description AS description_5, s0_.picture AS picture_6, s0_.picture_alt AS picture_alt_7, s0_.published AS published_8, s0_.date_publication AS date_publication_9, s0_.file AS file_10, s0_.is_on_homepage AS is_on_homepage_11, s0_.is_physical AS is_physical_12, s0_.is_quantity AS is_quantity_13, s0_.category_id AS category_id_14 FROM sewing s0_ WHERE s0_.published = 1 AND s0_.date_publication <= CURRENT_DATE AND s0_.is_on_homepage = 1
Parameters:
[] |
| 3 | 0.25 ms |
SELECT t0.id AS id_1, t0.rating AS rating_2, t0.comment AS comment_3, t0.date AS date_4, t0.formation_id AS formation_id_5, t0.client_id AS client_id_6 FROM formation_review t0
Parameters:
[] |
| 4 | 0.25 ms |
SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.introduction AS introduction_2, f0_.description AS description_3, f0_.meta_description AS meta_description_4, f0_.picture AS picture_5, f0_.picture_alt AS picture_alt_6, f0_.price_ht AS price_ht_7, f0_.tva AS tva_8, f0_.is_published AS is_published_9, f0_.iframe AS iframe_10, f0_.level_id AS level_id_11 FROM formation f0_ WHERE f0_.is_published = 1 ORDER BY f0_.id DESC LIMIT 3
Parameters:
[] |
| 5 | 0.37 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.published AS published_4, t0.date_publication AS date_publication_5 FROM notification t0 WHERE t0.published = ? ORDER BY t0.date_publication DESC
Parameters:
[
1
]
|
| 6 | 0.27 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.address AS address_4, t0.postcode AS postcode_5, t0.city AS city_6, t0.phone AS phone_7, t0.user_id AS user_id_8 FROM client t0 WHERE t0.id = ?
Parameters:
[
3
]
|
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\Notification | No errors. |
| App\Entity\User | No errors. |
| App\Entity\BlogArticle | No errors. |
| App\Entity\Sewing | No errors. |
| App\Entity\FormationReview | No errors. |
| App\Entity\Formation | No errors. |
| App\Entity\BlogCategory | No errors. |
| App\Entity\SewingCategory | No errors. |
| App\Entity\SewingGallery | No errors. |
| App\Entity\Client | No errors. |
| App\Entity\FormationLevel | No errors. |
| App\Entity\FormationSection | No errors. |
| App\Entity\ClientFormationState | No errors. |
| App\Entity\Order | No errors. |
| App\Entity\ClientMessage | No errors. |