Query Metrics
5
Database Queries
5
Different statements
4.00 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.85 ms |
SELECT p0_.id AS id_0, p0_.price AS price_1, p0_.original_price AS original_price_2, p0_.duration AS duration_3, p0_.sessions AS sessions_4, p0_.image_name AS image_name_5, p1_.title AS title_6, p1_.hint AS hint_7, p1_.options AS options_8 FROM plan p0_ INNER JOIN plan_translation p1_ ON p0_.id = p1_.plan_id INNER JOIN locale l2_ ON p1_.locale_id = l2_.id WHERE p0_.enabled = ? AND p0_.type = ? AND l2_.code = ? LIMIT 3
Parameters:
[ 1 "horse" "fr_FR" ] |
| 2 | 0.84 ms |
SELECT count(DISTINCT a0_.id) AS sclr_0 FROM article a0_ INNER JOIN article_translation a1_ ON a0_.id = a1_.article_id INNER JOIN locale l2_ ON a1_.locale_id = l2_.id WHERE (l2_.code = ?) AND a0_.discriminator IN ('service')
Parameters:
[
"fr_FR"
]
|
| 3 | 0.38 ms |
SELECT DISTINCT a0_.id AS id_0, a0_.created_at AS created_at_1 FROM article a0_ INNER JOIN article_translation a1_ ON a0_.id = a1_.article_id INNER JOIN locale l2_ ON a1_.locale_id = l2_.id WHERE (l2_.code = ?) AND a0_.discriminator IN ('service') ORDER BY a0_.created_at ASC LIMIT 4
Parameters:
[
"fr_FR"
]
|
| 4 | 0.66 ms |
SELECT a0_.id AS id_0, a0_.type AS type_1, a0_.date AS date_2, a0_.price AS price_3, a0_.duration AS duration_4, a0_.image_name AS image_name_5, a1_.title AS title_6, a1_.text AS text_7, a1_.description AS description_8 FROM article a0_ INNER JOIN article_translation a1_ ON a0_.id = a1_.article_id INNER JOIN locale l2_ ON a1_.locale_id = l2_.id WHERE (l2_.code = ? AND a0_.id IN (?)) AND a0_.discriminator IN ('service') ORDER BY a0_.created_at ASC
Parameters:
[ "fr_FR" [ 5 6 7 8 ] ] |
| 5 | 0.27 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\Course\Plan | No errors. |
| App\Entity\Article\Article | No errors. |
| App\Entity\Article\Service | No errors. |
| App\Entity\Booking\Booking | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Course\PlanTranslation | No errors. |
| App\Entity\Locale | No errors. |
| App\Entity\Article\ArticleTranslation | 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\Blog\PostTranslation | No errors. |
| App\Entity\Testimonial\TestimonialTranslation | No errors. |
| App\Entity\Faq\FaqTranslation | No errors. |
| App\Entity\Tax\TaxTranslation | No errors. |