Query Metrics
6
Database Queries
6
Different statements
2.68 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.36 ms |
SELECT t0.id AS id_1, t0.page AS page_2, t0.type AS type_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.image_name AS image_name_6, t0.image_original_name AS image_original_name_7, t0.image_mime_type AS image_mime_type_8, t0.image_size AS image_size_9, t0.image_dimensions AS image_dimensions_10 FROM banner t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
"horse"
]
|
| 2 | 0.34 ms |
SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.author AS author_2, p0_.date AS date_3, p0_.image_name AS image_name_4, p0_.author_image_name AS author_image_name_5, p1_.title AS title_6, p1_.description AS description_7 FROM post p0_ INNER JOIN post_translation p1_ ON p0_.id = p1_.post_id INNER JOIN locale l2_ ON p1_.locale_id = l2_.id WHERE l2_.code = ? AND p0_.id = ?
Parameters:
[ "fr_FR" "5" ] |
| 3 | 1.07 ms |
SELECT p0_.id AS id_0, p0_.type AS type_1, p0_.author AS author_2, p0_.date AS date_3, p0_.image_name AS image_name_4, p0_.author_image_name AS author_image_name_5, p1_.title AS title_6, p1_.description AS description_7 FROM post p0_ INNER JOIN post_translation p1_ ON p0_.id = p1_.post_id INNER JOIN locale l2_ ON p1_.locale_id = l2_.id WHERE l2_.code = ? ORDER BY p0_.created_at DESC LIMIT 5
Parameters:
[
"fr_FR"
]
|
| 4 | 0.45 ms |
SELECT count(DISTINCT m0_.id) AS sclr_0 FROM media m0_ WHERE m0_.product_id IS NULL AND m0_.article_id IS NULL
Parameters:
[] |
| 5 | 0.24 ms |
SELECT DISTINCT m0_.id AS id_0 FROM media m0_ WHERE m0_.product_id IS NULL AND m0_.article_id IS NULL LIMIT 6
Parameters:
[] |
| 6 | 0.21 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4 FROM locale 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 |
|---|---|
| Vich\UploaderBundle\Entity\File | No errors. |
| App\Entity\Banner\Banner | No errors. |
| App\Entity\Blog\Post | No errors. |
| App\Entity\Media | No errors. |
| App\Entity\Blog\PostTranslation | No errors. |
| App\Entity\Locale | No errors. |
| App\Entity\Category\CategoryTranslation | No errors. |
| App\Entity\Product\ProductTranslation | No errors. |
| App\Entity\Payment\PaymentMethodTranslation | No errors. |
| App\Entity\Slide\SlideTranslation | No errors. |
| App\Entity\Testimonial\TestimonialTranslation | No errors. |
| App\Entity\Article\ArticleTranslation | No errors. |
| App\Entity\Faq\FaqTranslation | No errors. |
| App\Entity\Tax\TaxTranslation | No errors. |
| App\Entity\Course\PlanTranslation | No errors. |