Query Metrics
28
Database Queries
19
Different statements
63.01 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 10.37 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.breve AS breve_3, t0.keyword AS keyword_4, t0.link AS link_5, t0.nomcompte AS nomcompte_6, t0.numcompte AS numcompte_7, t0.description AS description_8, t0.rang AS rang_9, t0.date AS date_10, t0.typearticle AS typearticle_11, t0.type_id AS type_id_12, t0.user_id AS user_id_13, t0.imgservice_id AS imgservice_id_14, t0.produit_id AS produit_id_15 FROM service t0 WHERE t0.id = ?
Parameters:
[
"3"
]
|
2 | 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 = ?
Parameters:
[
"presentation"
]
|
3 | 1.68 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.link AS link_4, t0.typearticle AS typearticle_5, t0.date AS date_6, t0.rang AS rang_7, t0.breve AS breve_8, t0.user_id AS user_id_9, t0.service_id AS service_id_10, t0.imgevenement_id AS imgevenement_id_11 FROM evenement t0 WHERE t0.service_id = ?
Parameters:
[
3
]
|
4 | 2.13 ms |
SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.description AS description_2, c0_.date AS date_3, c0_.rang AS rang_4, c0_.src AS src_5, c0_.alt AS alt_6, s1_.id AS id_7, s1_.nom AS nom_8, s1_.typebusiness AS typebusiness_9, s1_.description AS description_10, s1_.helpdashboard AS helpdashboard_11, s1_.link AS link_12, s1_.date AS date_13, s1_.nbvente AS nbvente_14, s1_.rang AS rang_15, s1_.src AS src_16, s1_.alt AS alt_17, c0_.user_id AS user_id_18, s1_.user_id AS user_id_19, s1_.categorie_id AS categorie_id_20 FROM categorie c0_ LEFT JOIN souscategorie s1_ ON c0_.id = s1_.categorie_id ORDER BY c0_.rang ASC
Parameters:
[] |
5 | 1.19 ms |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.date AS date_4, t0.transaction AS transaction_5, t0.valide AS valide_6, t0.lut AS lut_7, t0.depot AS depot_8, t0.retrait AS retrait_9, t0.timestamp AS timestamp_10, t0.user_id AS user_id_11, t0.auteur_id AS auteur_id_12, t0.billet_id AS billet_id_13, t0.service_id AS service_id_14 FROM notification t0 WHERE t0.user_id IS NULL AND t0.lut = ? ORDER BY t0.date DESC
Parameters:
[
"false"
]
|
6 | 1.18 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 ASC
Parameters:
[
"interface"
]
|
7 | 1.00 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.date AS date_4, t0.rang AS rang_5, t0.src AS src_6, t0.alt AS alt_7, t0.user_id AS user_id_8 FROM categorie t0 WHERE t0.rang = ? LIMIT 1
Parameters:
[
2
]
|
8 | 1.22 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.typebusiness AS typebusiness_3, t0.description AS description_4, t0.helpdashboard AS helpdashboard_5, t0.link AS link_6, t0.date AS date_7, t0.nbvente AS nbvente_8, t0.rang AS rang_9, t0.src AS src_10, t0.alt AS alt_11, t0.user_id AS user_id_12, t0.categorie_id AS categorie_id_13 FROM souscategorie t0 WHERE t0.categorie_id = ? ORDER BY t0.rang ASC
Parameters:
[
1
]
|
9 | 1.51 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.typebusiness AS typebusiness_3, t0.description AS description_4, t0.helpdashboard AS helpdashboard_5, t0.link AS link_6, t0.date AS date_7, t0.nbvente AS nbvente_8, t0.rang AS rang_9, t0.src AS src_10, t0.alt AS alt_11, t0.user_id AS user_id_12, t0.categorie_id AS categorie_id_13 FROM souscategorie t0 WHERE t0.categorie_id = ? ORDER BY t0.rang ASC
Parameters:
[
2
]
|
10 | 0.58 ms |
SELECT DATABASE()
Parameters:
[] |
11 | 1.61 ms |
SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME
Parameters:
[
"afhunt_factory"
]
|
12 | 0.52 ms |
SELECT DATABASE()
Parameters:
[] |
13 | 1.35 ms |
SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME
Parameters:
[
"afhunt_factory"
]
|
14 | 0.36 ms |
SELECT DATABASE()
Parameters:
[] |
15 | 1.16 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:
[ "afhunt_factory" "doctrine_migration_versions" ] |
16 | 0.62 ms |
SELECT DATABASE()
Parameters:
[] |
17 | 24.17 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:
[ "afhunt_factory" "doctrine_migration_versions" ] |
18 | 1.85 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:
[ "afhunt_factory" "doctrine_migration_versions" ] |
19 | 0.72 ms |
SELECT DATABASE()
Parameters:
[] |
20 | 1.12 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:
[ "afhunt_factory" "doctrine_migration_versions" ] |
21 | 0.79 ms |
SELECT * FROM doctrine_migration_versions
Parameters:
[] |
22 | 0.73 ms |
SELECT DATABASE()
Parameters:
[] |
23 | 0.95 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.link AS link_4, t0.typearticle AS typearticle_5, t0.date AS date_6, t0.rang AS rang_7, t0.breve AS breve_8, t0.user_id AS user_id_9, t0.service_id AS service_id_10, t0.imgevenement_id AS imgevenement_id_11 FROM evenement t0 WHERE t0.service_id = ? AND t0.typearticle = ? ORDER BY t0.rang ASC
Parameters:
[ 3 "autres" ] |
24 | 0.93 ms |
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, rang_8 FROM (SELECT s0_.id AS id_0, s0_.nom AS nom_1, s0_.breve AS breve_2, s0_.keyword AS keyword_3, s0_.link AS link_4, s0_.nomcompte AS nomcompte_5, s0_.numcompte AS numcompte_6, s0_.description AS description_7, s0_.rang AS rang_8, s0_.date AS date_9, s0_.typearticle AS typearticle_10, t1_.id AS id_11, t1_.nom AS nom_12, t1_.description AS description_13, t1_.rang AS rang_14, t1_.src AS src_15, t1_.alt AS alt_16, t1_.position AS position_17, t1_.date AS date_18 FROM service s0_ LEFT JOIN typearticle t1_ ON s0_.type_id = t1_.id WHERE s0_.typearticle LIKE ?) dctrn_result_inner ORDER BY rang_8 ASC) dctrn_result LIMIT 500
Parameters:
[
"%presentation%"
]
|
25 | 1.63 ms |
SELECT s0_.id AS id_0, s0_.nom AS nom_1, s0_.breve AS breve_2, s0_.keyword AS keyword_3, s0_.link AS link_4, s0_.nomcompte AS nomcompte_5, s0_.numcompte AS numcompte_6, s0_.description AS description_7, s0_.rang AS rang_8, s0_.date AS date_9, s0_.typearticle AS typearticle_10, t1_.id AS id_11, t1_.nom AS nom_12, t1_.description AS description_13, t1_.rang AS rang_14, t1_.src AS src_15, t1_.alt AS alt_16, t1_.position AS position_17, t1_.date AS date_18, s0_.type_id AS type_id_19, s0_.user_id AS user_id_20, s0_.imgservice_id AS imgservice_id_21, s0_.produit_id AS produit_id_22, t1_.user_id AS user_id_23 FROM service s0_ LEFT JOIN typearticle t1_ ON s0_.type_id = t1_.id WHERE s0_.typearticle LIKE ? AND s0_.id IN (?, ?) ORDER BY s0_.rang ASC
Parameters:
[ "%presentation%" 2 3 ] |
26 | 0.67 ms |
SELECT t0.id AS id_1, t0.src AS src_2, t0.alt AS alt_3 FROM imgservice t0 WHERE t0.id = ?
Parameters:
[
3
]
|
27 | 0.57 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.link AS link_4, t0.typearticle AS typearticle_5, t0.date AS date_6, t0.rang AS rang_7, t0.breve AS breve_8, t0.user_id AS user_id_9, t0.service_id AS service_id_10, t0.imgevenement_id AS imgevenement_id_11 FROM evenement t0 WHERE t0.service_id = ? AND t0.typearticle = ? ORDER BY t0.rang ASC
Parameters:
[ 3 "autres" ] |
28 | 1.52 ms |
SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.description AS description_2, c0_.date AS date_3, c0_.rang AS rang_4, c0_.src AS src_5, c0_.alt AS alt_6, s1_.id AS id_7, s1_.nom AS nom_8, s1_.typebusiness AS typebusiness_9, s1_.description AS description_10, s1_.helpdashboard AS helpdashboard_11, s1_.link AS link_12, s1_.date AS date_13, s1_.nbvente AS nbvente_14, s1_.rang AS rang_15, s1_.src AS src_16, s1_.alt AS alt_17, c0_.user_id AS user_id_18, s1_.user_id AS user_id_19, s1_.categorie_id AS categorie_id_20 FROM categorie c0_ LEFT JOIN souscategorie s1_ ON c0_.id = s1_.categorie_id ORDER BY c0_.rang ASC
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.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\Produit\Service\Service | No errors. |
App\Entity\Produit\Service\Typearticle | No errors. |
App\Entity\Users\User\User | No errors. |
App\Entity\Produit\Service\Imgservice | No errors. |
App\Entity\Produit\Produit\Produit | No errors. |
App\Entity\Produit\Service\Evenement | No errors. |
App\Entity\Produit\Service\Imgevenement | No errors. |
App\Entity\Produit\Produit\Categorie | No errors. |
App\Entity\Produit\Produit\Souscategorie | No errors. |
App\Entity\Produit\Produit\Caracteristique | No errors. |
App\Entity\Users\User\Notification | No errors. |
App\Entity\Users\User\Billet | No errors. |
App\Entity\Produit\Service\Pays | No errors. |
App\Entity\Users\User\Imgprofil | No errors. |
App\Entity\Produit\Produit\Caracteristiqueproduit | No errors. |
App\Entity\Produit\Produit\Imgproduit | No errors. |
App\Entity\Produit\Produit\Coutlivraison | No errors. |
App\Entity\Produit\Produit\Cataloguechantier | No errors. |
App\Entity\Users\User\Reponsebillet | No errors. |
App\Entity\Produit\Produit\Panier | 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\Produitpanier | No errors. |
App\Entity\Produit\Service\Couponcard | No errors. |
App\Entity\Produit\Produit\Collectionproduit | No errors. |