Query Metrics
45
Database Queries
22
Different statements
35.25 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.37 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.id = ?
Parameters:
[
"13"
]
|
2 | 1.76 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.contenu AS contenu_3, t0.rapport AS rapport_4, t0.rang AS rang_5, t0.choixauteur AS choixauteur_6, t0.date AS date_7, t0.nblike AS nblike_8, t0.nbvente AS nbvente_9, t0.newprise AS newprise_10, t0.lastprise AS lastprise_11, t0.difference AS difference_12, t0.prixlivraison AS prixlivraison_13, t0.nbvote AS nbvote_14, t0.totalnote AS totalnote_15, t0.user_id AS user_id_16, t0.imgproduit_id AS imgproduit_id_17, t0.souscategorie_id AS souscategorie_id_18 FROM produit t0 WHERE t0.souscategorie_id = ? ORDER BY t0.date ASC
Parameters:
[
13
]
|
3 | 0.55 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.typeservice AS typeservice_3, t0.description AS description_4, t0.date AS date_5, t0.rang AS rang_6, t0.src AS src_7, t0.alt AS alt_8, t0.user_id AS user_id_9 FROM categorie t0 WHERE t0.id = ?
Parameters:
[
2
]
|
4 | 0.55 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%" ] |
5 | 0.44 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:
[] |
6 | 0.32 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
]
|
7 | 0.33 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
]
|
8 | 0.36 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:
[] |
9 | 0.52 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"
]
|
10 | 0.47 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"
]
|
11 | 0.42 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
]
|
12 | 0.35 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
]
|
13 | 0.55 ms |
SELECT DATABASE()
Parameters:
[] |
14 | 1.91 ms |
SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME
Parameters:
[
"azcorp_institut"
]
|
15 | 0.30 ms |
SELECT DATABASE()
Parameters:
[] |
16 | 1.47 ms |
SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME
Parameters:
[
"azcorp_institut"
]
|
17 | 0.34 ms |
SELECT DATABASE()
Parameters:
[] |
18 | 1.64 ms |
SELECT t.TABLE_NAME, t.ENGINE, t.AUTO_INCREMENT, t.TABLE_COMMENT, t.CREATE_OPTIONS, t.TABLE_COLLATION, ccsa.CHARACTER_SET_NAME FROM information_schema.TABLES t INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE'
Parameters:
[ "azcorp_institut" "doctrine_migration_versions" ] |
19 | 0.28 ms |
SELECT DATABASE()
Parameters:
[] |
20 | 10.86 ms |
SELECT DISTINCT k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME, k.ORDINAL_POSITION /*!50116, c.UPDATE_RULE, c.DELETE_RULE */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME AND c.CONSTRAINT_SCHEMA = k.TABLE_SCHEMA */ WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL ORDER BY k.ORDINAL_POSITION
Parameters:
[ "azcorp_institut" "doctrine_migration_versions" ] |
21 | 1.02 ms |
SELECT COLUMN_NAME AS field, COLUMN_TYPE AS type, IS_NULLABLE AS `null`, COLUMN_KEY AS `key`, COLUMN_DEFAULT AS `default`, EXTRA, COLUMN_COMMENT AS comment, CHARACTER_SET_NAME AS characterset, COLLATION_NAME AS collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY ORDINAL_POSITION
Parameters:
[ "azcorp_institut" "doctrine_migration_versions" ] |
22 | 0.33 ms |
SELECT DATABASE()
Parameters:
[] |
23 | 0.40 ms |
SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX
Parameters:
[ "azcorp_institut" "doctrine_migration_versions" ] |
24 | 0.27 ms |
SELECT * FROM doctrine_migration_versions
Parameters:
[] |
25 | 0.30 ms |
SELECT DATABASE()
Parameters:
[] |
26 | 0.35 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%" ] |
27 | 0.28 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
]
|
28 | 0.30 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
]
|
29 | 0.72 ms |
SELECT t0.id AS id_1, t0.src AS src_2, t0.alt AS alt_3, t0.date AS date_4 FROM imgproduit t0 WHERE t0.id = ?
Parameters:
[
56
]
|
30 | 0.56 ms |
SELECT t0.id AS id_1, t0.valeur AS valeur_2, t0.date AS date_3, t0.produit_id AS produit_id_4, t0.caracteristique_id AS caracteristique_id_5, t0.user_id AS user_id_6 FROM caracteristiqueproduit t0 WHERE t0.produit_id = ?
Parameters:
[
57
]
|
31 | 0.36 ms |
SELECT t0.id AS id_1, t0.src AS src_2, t0.alt AS alt_3, t0.date AS date_4 FROM imgproduit t0 WHERE t0.id = ?
Parameters:
[
57
]
|
32 | 0.34 ms |
SELECT t0.id AS id_1, t0.valeur AS valeur_2, t0.date AS date_3, t0.produit_id AS produit_id_4, t0.caracteristique_id AS caracteristique_id_5, t0.user_id AS user_id_6 FROM caracteristiqueproduit t0 WHERE t0.produit_id = ?
Parameters:
[
58
]
|
33 | 0.61 ms |
SELECT t0.id AS id_1, t0.src AS src_2, t0.alt AS alt_3, t0.date AS date_4 FROM imgproduit t0 WHERE t0.id = ?
Parameters:
[
58
]
|
34 | 0.48 ms |
SELECT t0.id AS id_1, t0.valeur AS valeur_2, t0.date AS date_3, t0.produit_id AS produit_id_4, t0.caracteristique_id AS caracteristique_id_5, t0.user_id AS user_id_6 FROM caracteristiqueproduit t0 WHERE t0.produit_id = ?
Parameters:
[
59
]
|
35 | 0.38 ms |
SELECT t0.id AS id_1, t0.src AS src_2, t0.alt AS alt_3, t0.date AS date_4 FROM imgproduit t0 WHERE t0.id = ?
Parameters:
[
60
]
|
36 | 0.56 ms |
SELECT t0.id AS id_1, t0.valeur AS valeur_2, t0.date AS date_3, t0.produit_id AS produit_id_4, t0.caracteristique_id AS caracteristique_id_5, t0.user_id AS user_id_6 FROM caracteristiqueproduit t0 WHERE t0.produit_id = ?
Parameters:
[
61
]
|
37 | 0.41 ms |
SELECT t0.id AS id_1, t0.src AS src_2, t0.alt AS alt_3, t0.date AS date_4 FROM imgproduit t0 WHERE t0.id = ?
Parameters:
[
61
]
|
38 | 0.47 ms |
SELECT t0.id AS id_1, t0.valeur AS valeur_2, t0.date AS date_3, t0.produit_id AS produit_id_4, t0.caracteristique_id AS caracteristique_id_5, t0.user_id AS user_id_6 FROM caracteristiqueproduit t0 WHERE t0.produit_id = ?
Parameters:
[
62
]
|
39 | 0.44 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.payer AS payer_3, t0.livrer AS livrer_4, t0.sousmis AS sousmis_5, t0.coastlivraison AS coastlivraison_6, t0.montantht AS montantht_7, t0.montantttc AS montantttc_8, t0.livraisonpayer AS livraisonpayer_9, t0.tel AS tel_10, t0.destination AS destination_11, t0.user_id AS user_id_12, t0.ville_id AS ville_id_13, t0.couponcard_id AS couponcard_id_14, t0.contact_id AS contact_id_15, t0.service_id AS service_id_16 FROM panier t0 WHERE t0.id = ? AND t0.sousmis = ? LIMIT 1
Parameters:
[ 0 0 ] |
40 | 0.25 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%" ] |
41 | 0.35 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"
]
|
42 | 0.44 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.src AS src_3, t0.alt AS alt_4, t0.nbtele AS nbtele_5, t0.message AS message_6, t0.typedocument AS typedocument_7, t0.timestamp AS timestamp_8, t0.user_id AS user_id_9, t0.yourcv_id AS yourcv_id_10 FROM recrutement t0 WHERE t0.typedocument = ? ORDER BY t0.date DESC LIMIT 20
Parameters:
[
"depliant"
]
|
43 | 0.35 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.src AS src_3, t0.alt AS alt_4, t0.nbtele AS nbtele_5, t0.message AS message_6, t0.typedocument AS typedocument_7, t0.timestamp AS timestamp_8, t0.user_id AS user_id_9, t0.yourcv_id AS yourcv_id_10 FROM recrutement t0 WHERE t0.typedocument = ? ORDER BY t0.date DESC LIMIT 20
Parameters:
[
"planing"
]
|
44 | 0.21 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:
[
"aproposvideo"
]
|
45 | 0.29 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 = ? AND t0.principal = ? ORDER BY t0.rang ASC LIMIT 20
Parameters:
[ "actualite" 1 ] |
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\Produit\Souscategorie | No errors. |
App\Entity\Users\User\User | No errors. |
App\Entity\Produit\Produit\Categorie | 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\Produit\Imgproduit | No errors. |
App\Entity\Produit\Produit\Coutlivraison | No errors. |
App\Entity\Produit\Produit\Caracteristiqueproduit | No errors. |
App\Entity\Produit\Service\Categorieappli | No errors. |
App\Entity\Produit\Service\Application | No errors. |
App\Entity\Produit\Service\Service | No errors. |
App\Entity\Produit\Service\Imgservice | No errors. |
App\Entity\Produit\Service\Typearticle | No errors. |
App\Entity\Produit\Service\Evenement | No errors. |
App\Entity\Produit\Service\Commentaireblog | No errors. |
App\Entity\Produit\Service\Ressourcearticle | No errors. |
App\Entity\Users\Adminuser\Parametreadmin | No errors. |
App\Entity\Produit\Service\Pays | No errors. |
App\Entity\Users\User\Imgprofil | No errors. |
App\Entity\Produit\Service\Ville | No errors. |
App\Entity\Produit\Service\Imgevenement | No errors. |
App\Entity\Users\User\Contacts | No errors. |
App\Entity\Produit\Service\Drapeau | No errors. |
App\Entity\Produit\Service\Continent | No errors. |
App\Entity\Produit\Produit\Panier | No errors. |
App\Entity\Produit\Service\Couponcard | No errors. |
App\Entity\Produit\Service\Recrutement | No errors. |
App\Entity\Produit\Service\Yourcv | No errors. |
App\Entity\Produit\Produit\Produitpanier | No errors. |
App\Entity\Users\User\Billet | No errors. |