Query Metrics
16
Database Queries
13
Different statements
14.35 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.86 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.breve AS breve_4, t0.keyword AS keyword_5, t0.link AS link_6, t0.nomcompte AS nomcompte_7, t0.numcompte AS numcompte_8, t0.rang AS rang_9, t0.principal AS principal_10, t0.date AS date_11, t0.typearticle AS typearticle_12, t0.date_event AS date_event_13, t0.user_id AS user_id_14, t0.souscategorie_id AS souscategorie_id_15, t0.imgservice_id AS imgservice_id_16, t0.type_id AS type_id_17 FROM service t0 WHERE t0.id = ?
Parameters:
[
0
]
|
2 | 0.67 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.rang AS rang_4, t0.src AS src_5, t0.alt AS alt_6, t0.position AS position_7, t0.date AS date_8, t0.user_id AS user_id_9 FROM typearticle t0 WHERE t0.id = ?
Parameters:
[
0
]
|
3 | 0.63 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.rang AS rang_4, t0.src AS src_5, t0.alt AS alt_6, t0.position AS position_7, t0.date AS date_8, t0.user_id AS user_id_9 FROM typearticle t0 WHERE t0.position = ? ORDER BY t0.rang DESC LIMIT 1
Parameters:
[
"planingcours"
]
|
4 | 0.88 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.rang AS rang_4, t0.src AS src_5, t0.alt AS alt_6, t0.position AS position_7, t0.date AS date_8, t0.user_id AS user_id_9 FROM typearticle t0 WHERE t0.position = ? ORDER BY t0.rang DESC
Parameters:
[
"planingcours"
]
|
5 | 0.79 ms |
SELECT r0_.id AS id_0, r0_.date AS date_1, r0_.src AS src_2, r0_.alt AS alt_3, r0_.nbtele AS nbtele_4, r0_.message AS message_5, r0_.typedocument AS typedocument_6, r0_.timestamp AS timestamp_7, r0_.user_id AS user_id_8, r0_.yourcv_id AS yourcv_id_9 FROM recrutement r0_ WHERE r0_.typedocument LIKE ? ORDER BY r0_.date DESC
Parameters:
[
"%depliant%"
]
|
6 | 0.69 ms |
SELECT r0_.id AS id_0, r0_.date AS date_1, r0_.src AS src_2, r0_.alt AS alt_3, r0_.nbtele AS nbtele_4, r0_.message AS message_5, r0_.typedocument AS typedocument_6, r0_.timestamp AS timestamp_7, r0_.user_id AS user_id_8, r0_.yourcv_id AS yourcv_id_9 FROM recrutement r0_ WHERE r0_.typedocument LIKE ? ORDER BY r0_.date DESC
Parameters:
[
"%planing%"
]
|
7 | 1.33 ms |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT s0_.id AS id_0, s0_.nom AS nom_1, s0_.description AS description_2, s0_.breve AS breve_3, s0_.keyword AS keyword_4, s0_.link AS link_5, s0_.nomcompte AS nomcompte_6, s0_.numcompte AS numcompte_7, s0_.rang AS rang_8, s0_.principal AS principal_9, s0_.date AS date_10, s0_.typearticle AS typearticle_11, s0_.date_event AS date_event_12, e1_.id AS id_13, e1_.nom AS nom_14, e1_.description AS description_15, e1_.typearticle AS typearticle_16, e1_.link AS link_17, e1_.breve AS breve_18, e1_.date AS date_19, e1_.rang AS rang_20 FROM service s0_ LEFT JOIN evenement e1_ ON s0_.id = e1_.service_id WHERE s0_.typearticle LIKE ? ORDER BY s0_.rang ASC) dctrn_result) dctrn_table
Parameters:
[
"%evenement%"
]
|
8 | 0.87 ms |
SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.typeservice AS typeservice_2, c0_.description AS description_3, c0_.date AS date_4, c0_.rang AS rang_5, c0_.src AS src_6, c0_.alt AS alt_7, c0_.user_id AS user_id_8 FROM categorie c0_ WHERE c0_.typeservice LIKE ? OR c0_.typeservice LIKE ? ORDER BY c0_.rang ASC LIMIT 2
Parameters:
[ "%continue%" "%diplomante%" ] |
9 | 1.60 ms |
SELECT c0_.id AS id_0, c0_.src AS src_1, c0_.alt AS alt_2, c0_.nom AS nom_3, c0_.description AS description_4, c0_.rang AS rang_5, a1_.id AS id_6, a1_.nom AS nom_7, a1_.description AS description_8, a1_.rang AS rang_9, a1_.siteweb AS siteweb_10, a1_.src AS src_11, a1_.alt AS alt_12, a1_.categorieappli_id AS categorieappli_id_13 FROM categorieappli c0_ LEFT JOIN application a1_ ON c0_.id = a1_.categorieappli_id ORDER BY c0_.rang ASC
Parameters:
[] |
10 | 0.86 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.helpdashboard AS helpdashboard_4, t0.link AS link_5, t0.date AS date_6, t0.nbvente AS nbvente_7, t0.rang AS rang_8, t0.src AS src_9, t0.alt AS alt_10, t0.user_id AS user_id_11, t0.categorie_id AS categorie_id_12, t0.cataloguechantier_id AS cataloguechantier_id_13 FROM souscategorie t0 WHERE t0.categorie_id = ?
Parameters:
[
1
]
|
11 | 0.90 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.helpdashboard AS helpdashboard_4, t0.link AS link_5, t0.date AS date_6, t0.nbvente AS nbvente_7, t0.rang AS rang_8, t0.src AS src_9, t0.alt AS alt_10, t0.user_id AS user_id_11, t0.categorie_id AS categorie_id_12, t0.cataloguechantier_id AS cataloguechantier_id_13 FROM souscategorie t0 WHERE t0.categorie_id = ?
Parameters:
[
2
]
|
12 | 0.80 ms |
SELECT a0_.id AS id_0, a0_.nom AS nom_1, a0_.description AS description_2, a0_.rang AS rang_3, a0_.siteweb AS siteweb_4, a0_.src AS src_5, a0_.alt AS alt_6, c1_.id AS id_7, c1_.src AS src_8, c1_.alt AS alt_9, c1_.nom AS nom_10, c1_.description AS description_11, c1_.rang AS rang_12, a0_.categorieappli_id AS categorieappli_id_13 FROM application a0_ LEFT JOIN categorieappli c1_ ON a0_.categorieappli_id = c1_.id ORDER BY a0_.rang ASC
Parameters:
[] |
13 | 0.68 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.breve AS breve_4, t0.keyword AS keyword_5, t0.link AS link_6, t0.nomcompte AS nomcompte_7, t0.numcompte AS numcompte_8, t0.rang AS rang_9, t0.principal AS principal_10, t0.date AS date_11, t0.typearticle AS typearticle_12, t0.date_event AS date_event_13, t0.user_id AS user_id_14, t0.souscategorie_id AS souscategorie_id_15, t0.imgservice_id AS imgservice_id_16, t0.type_id AS type_id_17 FROM service t0 WHERE t0.typearticle = ? ORDER BY t0.rang ASC LIMIT 1
Parameters:
[
"aproposinstitut"
]
|
14 | 0.86 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.valeur AS valeur_3, t0.link AS link_4, t0.description AS description_5, t0.date AS date_6, t0.rang AS rang_7, t0.src AS src_8, t0.alt AS alt_9, t0.user_id AS user_id_10 FROM parametreadmin t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
"logosm"
]
|
15 | 1.07 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.helpdashboard AS helpdashboard_4, t0.link AS link_5, t0.date AS date_6, t0.nbvente AS nbvente_7, t0.rang AS rang_8, t0.src AS src_9, t0.alt AS alt_10, t0.user_id AS user_id_11, t0.categorie_id AS categorie_id_12, t0.cataloguechantier_id AS cataloguechantier_id_13 FROM souscategorie t0 WHERE t0.categorie_id = ? ORDER BY t0.rang ASC
Parameters:
[
1
]
|
16 | 0.86 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.helpdashboard AS helpdashboard_4, t0.link AS link_5, t0.date AS date_6, t0.nbvente AS nbvente_7, t0.rang AS rang_8, t0.src AS src_9, t0.alt AS alt_10, t0.user_id AS user_id_11, t0.categorie_id AS categorie_id_12, t0.cataloguechantier_id AS cataloguechantier_id_13 FROM souscategorie t0 WHERE t0.categorie_id = ? ORDER BY t0.rang ASC
Parameters:
[
2
]
|
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\Produit\Service\Service | No errors. |
App\Entity\Users\User\User | No errors. |
App\Entity\Produit\Produit\Souscategorie | No errors. |
App\Entity\Produit\Service\Imgservice | No errors. |
App\Entity\Produit\Service\Typearticle | No errors. |
App\Entity\Produit\Service\Recrutement | No errors. |
App\Entity\Produit\Service\Yourcv | No errors. |
App\Entity\Produit\Service\Evenement | No errors. |
App\Entity\Produit\Produit\Categorie | No errors. |
App\Entity\Produit\Service\Categorieappli | No errors. |
App\Entity\Produit\Service\Application | No errors. |
App\Entity\Produit\Produit\Cataloguechantier | No errors. |
App\Entity\Produit\Produit\Produit | No errors. |
App\Entity\Produit\Produit\Caracteristique | No errors. |
App\Entity\Produit\Service\Commentaireblog | No errors. |
App\Entity\Produit\Service\Ressourcearticle | No errors. |
App\Entity\Users\Adminuser\Parametreadmin | No errors. |