https://dev.toofoot.com/concept

Query Metrics

22 Database Queries
5 Different statements
3.01 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.88 ms
SELECT c0_.id AS id_0, c0_.nom_concept AS nom_concept_1, c0_.texte_co AS texte_co_2, c0_.background_color AS background_color_3, c0_.logo AS logo_4, c0_.position AS position_5, c0_.image AS image_6, c0_.video AS video_7, c0_.diplay_video AS diplay_video_8, c0_.son AS son_9, c0_.frequence AS frequence_10, c0_.son_f AS son_f_11, c0_.displayvb AS displayvb_12, c0_.videob AS videob_13, c0_.choicevb AS choicevb_14, c0_.videom AS videom_15, c0_.font AS font_16, r1_.id AS id_17, r1_.image AS image_18, r1_.texte_g AS texte_g_19, r1_.text_p AS text_p_20, r1_.position AS position_21, r1_.name AS name_22, r1_.image_mobile AS image_mobile_23, r1_.son AS son_24, r1_.frequence AS frequence_25, r1_.son_f AS son_f_26, r1_.id_concept_id AS id_concept_id_27 FROM concept c0_ LEFT JOIN realisation r1_ ON c0_.id = r1_.id_concept_id ORDER BY c0_.position ASC, r1_.position ASC
Parameters:
[]
2 0.15 ms
SELECT p0_.id AS id_0, p0_.nom AS nom_1, s1_.id AS id_2, s1_.son_h AS son_h_3, s1_.nom_page AS nom_page_4, s1_.delay AS delay_5, s1_.frequence AS frequence_6, s1_.perso_v_id AS perso_v_id_7 FROM perso_v p0_ LEFT JOIN son s1_ ON p0_.id = s1_.perso_v_id
Parameters:
[]
3 0.42 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.concept_id AS concept_id_3, t0.image_id AS image_id_4 FROM image_concept t0 WHERE t0.concept_id = ?
Parameters:
[
  9
]
4 0.20 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.name AS name_3, t0.mime_type AS mime_type_4, t0.size AS size_5 FROM image t0 WHERE t0.id = ?
Parameters:
[
  27
]
5 0.08 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.name AS name_3, t0.mime_type AS mime_type_4, t0.size AS size_5 FROM image t0 WHERE t0.id = ?
Parameters:
[
  25
]
6 0.08 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.concept_id AS concept_id_3, t0.image_id AS image_id_4 FROM image_concept t0 WHERE t0.concept_id = ?
Parameters:
[
  12
]
7 0.06 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.name AS name_3, t0.mime_type AS mime_type_4, t0.size AS size_5 FROM image t0 WHERE t0.id = ?
Parameters:
[
  3
]
8 0.08 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.concept_id AS concept_id_3, t0.image_id AS image_id_4 FROM image_concept t0 WHERE t0.concept_id = ?
Parameters:
[
  10
]
9 0.06 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.name AS name_3, t0.mime_type AS mime_type_4, t0.size AS size_5 FROM image t0 WHERE t0.id = ?
Parameters:
[
  4
]
10 0.29 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.realisation_id AS realisation_id_3, t0.image_id AS image_id_4 FROM image_realisation t0 WHERE t0.realisation_id = ?
Parameters:
[
  5
]
11 0.08 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.name AS name_3, t0.mime_type AS mime_type_4, t0.size AS size_5 FROM image t0 WHERE t0.id = ?
Parameters:
[
  15
]
12 0.06 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.name AS name_3, t0.mime_type AS mime_type_4, t0.size AS size_5 FROM image t0 WHERE t0.id = ?
Parameters:
[
  16
]
13 0.05 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.name AS name_3, t0.mime_type AS mime_type_4, t0.size AS size_5 FROM image t0 WHERE t0.id = ?
Parameters:
[
  17
]
14 0.05 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.name AS name_3, t0.mime_type AS mime_type_4, t0.size AS size_5 FROM image t0 WHERE t0.id = ?
Parameters:
[
  18
]
15 0.06 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.realisation_id AS realisation_id_3, t0.image_id AS image_id_4 FROM image_realisation t0 WHERE t0.realisation_id = ?
Parameters:
[
  10
]
16 0.05 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.name AS name_3, t0.mime_type AS mime_type_4, t0.size AS size_5 FROM image t0 WHERE t0.id = ?
Parameters:
[
  24
]
17 0.06 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.realisation_id AS realisation_id_3, t0.image_id AS image_id_4 FROM image_realisation t0 WHERE t0.realisation_id = ?
Parameters:
[
  9
]
18 0.06 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.name AS name_3, t0.mime_type AS mime_type_4, t0.size AS size_5 FROM image t0 WHERE t0.id = ?
Parameters:
[
  19
]
19 0.06 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.realisation_id AS realisation_id_3, t0.image_id AS image_id_4 FROM image_realisation t0 WHERE t0.realisation_id = ?
Parameters:
[
  8
]
20 0.05 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.name AS name_3, t0.mime_type AS mime_type_4, t0.size AS size_5 FROM image t0 WHERE t0.id = ?
Parameters:
[
  20
]
21 0.06 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.realisation_id AS realisation_id_3, t0.image_id AS image_id_4 FROM image_realisation t0 WHERE t0.realisation_id = ?
Parameters:
[
  6
]
22 0.06 ms
SELECT t0.id AS id_1, t0.path AS path_2, t0.name AS name_3, t0.mime_type AS mime_type_4, t0.size AS size_5 FROM image t0 WHERE t0.id = ?
Parameters:
[
  21
]

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
App\Entity\Concept No errors.
App\Entity\Realisation No errors.
App\Entity\ImageConcept No errors.
App\Entity\ImageRealisation No errors.
App\Entity\ImageRealisationMobile No errors.
App\Entity\PersoV No errors.
App\Entity\Son No errors.
App\Entity\Image No errors.