Query Metrics

11 Database Queries
8 Different statements
11.84 ms Query time
3 Invalid entities
150 Managed entities

Queries

Group similar statements

# Time Info
1 2.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.status AS status_4 FROM language t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "fr"
]
2 3.91 ms
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.description AS description_2, a0_.content AS content_3, a0_.actuality_id AS actuality_id_4, a0_.language_id AS language_id_5 FROM actuality_translation a0_ INNER JOIN actuality a1_ ON (a1_.id = a0_.actuality_id) WHERE a1_.status = ? AND a1_.type = ? AND a0_.language_id = ? ORDER BY a1_.published DESC
Parameters:
[
  1
  1
  169
]
3 1.02 ms
SELECT t0_.id AS id_0, t0_.object AS object_1, t0_.name AS name_2, t0_.phone AS phone_3, t0_.email AS email_4, t0_.content AS content_5, t0_.created AS created_6, t0_.status AS status_7, t0_.language_id AS language_id_8 FROM testimonial t0_
Parameters:
[]
4 1.27 ms
SELECT g0_.id AS id_0, g0_.name AS name_1, g0_.description AS description_2, g0_.gallery_id AS gallery_id_3, g0_.language_id AS language_id_4 FROM gallery_translation g0_ INNER JOIN gallery g1_ ON (g1_.id = g0_.gallery_id) WHERE g1_.status = ? AND g0_.language_id = ? ORDER BY g0_.id DESC LIMIT 10
Parameters:
[
  1
  169
]
5 0.59 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.url AS url_4, t0.status AS status_5 FROM partner t0 WHERE t0.status = ?
Parameters:
[
  1
]
6 0.58 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.status AS status_4 FROM language t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "fr"
]
7 0.19 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.status AS status_4 FROM language t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "fr"
]
8 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3 FROM departement t0
Parameters:
[]
9 0.64 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.status AS status_4 FROM language t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "fr"
]
10 0.46 ms
SELECT t0.id AS id_1, t0.uid AS uid_2, t0.title AS title_3, t0.image AS image_4, t0.video AS video_5, t0.display_image AS display_image_6, t0.display_video AS display_video_7 FROM section t0 WHERE t0.uid = ? LIMIT 1
Parameters:
[
  "page-home-section-light-motive"
]
11 0.57 ms
SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.content AS content_2, s0_.section_id AS section_id_3, s0_.language_id AS language_id_4 FROM section_translation s0_ WHERE s0_.section_id = ? AND s0_.language_id = ? ORDER BY s0_.id ASC
Parameters:
[
  1
  169
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Content\ActualityTranslation 60
App\Entity\Content\Actuality 60
App\Entity\Partner\Partner 14
App\Entity\Gallery\GalleryTranslation 5
App\Entity\Gallery\Gallery 5
App\Entity\Advice\Testimonial 3
App\Entity\Language 1
App\Entity\Section\Section 1
App\Entity\Section\SectionTranslation 1

Entities Mapping

Class Mapping errors
App\Entity\Language No errors.
App\Entity\Advice\Testimonial No errors.
App\Entity\Advice\Advice No errors.
App\Entity\Content\ActualityTranslation
  • The association App\Entity\Content\ActualityTranslation#actuality refers to the inverse side field App\Entity\Content\Actuality#ActualityTranslation which does not exist.
  • The association App\Entity\Content\ActualityTranslation#language refers to the inverse side field App\Entity\Language#ActualityTranslation which does not exist.
App\Entity\Content\Actuality No errors.
App\Entity\Gallery\GalleryTranslation
  • The association App\Entity\Gallery\GalleryTranslation#gallery refers to the inverse side field App\Entity\Gallery\Gallery#GalleryTranslation which does not exist.
  • The association App\Entity\Gallery\GalleryTranslation#language refers to the inverse side field App\Entity\Language#GalleryTranslation which does not exist.
App\Entity\Gallery\Gallery No errors.
App\Entity\Partner\Partner No errors.
App\Entity\Departement No errors.
App\Entity\Category\Category No errors.
App\Entity\Section\Section No errors.
App\Entity\Section\SectionTranslation
  • The association App\Entity\Section\SectionTranslation#section refers to the inverse side field App\Entity\Section\Section#SectionTranslation which does not exist.
  • The association App\Entity\Section\SectionTranslation#language refers to the inverse side field App\Entity\Language#SectionTranslation which does not exist.