Query Metrics

5 Database Queries
5 Different statements
4.00 ms Query time
0 Invalid entities

Queries

Group similar statements

# 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.