GET https://bianco.mypreprod.xyz/

Query Metrics

36 Database Queries
10 Different statements
22.13 ms Query time
3 Invalid entities
160 Managed entities

Grouped Statements

Show all queries

Time Count Info
6.01 ms
(27.18%)
9
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"
]
3.91 ms
(17.66%)
1
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
]
2.64 ms
(11.91%)
5
SELECT t0.id AS id_1, t0.type AS type_2, t0.name AS name_3, t0.image AS image_4, t0.description AS description_5, t0.content AS content_6, t0.created AS created_7, t0.updated AS updated_8, t0.published AS published_9, t0.status AS status_10, t0.uid AS uid_11, t0.departement_id AS departement_id_12 FROM actuality t0 WHERE t0.id = ?
Parameters:
[
  66
]
2.24 ms
(10.13%)
5
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.url AS url_4, t0.status AS status_5, t0.image AS image_6, t0.created AS created_7, t0.updated AS updated_8, t0.diaporama AS diaporama_9 FROM gallery t0 WHERE t0.id = ?
Parameters:
[
  5
]
2.14 ms
(9.68%)
6
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"
]
1.96 ms
(8.88%)
6
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
]
1.27 ms
(5.73%)
1
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
]
1.02 ms
(4.60%)
1
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:
[]
0.59 ms
(2.69%)
1
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
]
0.34 ms
(1.55%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3 FROM departement 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.

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\Section\Section 6
App\Entity\Section\SectionTranslation 6
App\Entity\Gallery\GalleryTranslation 5
App\Entity\Gallery\Gallery 5
App\Entity\Advice\Testimonial 3
App\Entity\Language 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.