Query Metrics
12
Database Queries
12
Different statements
67.81 ms
Query time
0
Invalid entities
15227
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
62.31 ms (91.89%) |
1 |
SELECT a0_.id AS id_0, a0_.prenom AS prenom_1, a0_.nom AS nom_2, a0_.biographie AS biographie_3, a0_.bibliographie AS bibliographie_4, a0_.date_creation AS date_creation_5, a0_.update_at AS update_at_6, a0_.is_ecrivain AS is_ecrivain_7, a0_.is_illustrateur AS is_illustrateur_8, a0_.old_id AS old_id_9, a0_.portrait AS portrait_10, a0_.id_electre AS id_electre_11, a0_.photo_ext_id AS photo_ext_id_12 FROM auteur a0_ ORDER BY a0_.nom ASC
Parameters:
[] |
|
2.14 ms (3.15%) |
1 |
SELECT e0_.id AS id_0, e0_.nom AS nom_1, e0_.old_id AS old_id_2, e0_.slug AS slug_3, e0_.date_creation AS date_creation_4, e0_.udpate_at AS udpate_at_5, e0_.alias_electre AS alias_electre_6, e0_.id_electre AS id_electre_7 FROM editeur e0_ ORDER BY e0_.nom ASC
Parameters:
[] |
|
0.83 ms (1.22%) |
1 |
SELECT d0_.id AS id_0, d0_.nom AS nom_1, d0_.old_id AS old_id_2, d0_.slug AS slug_3, d0_.id_electre AS id_electre_4 FROM distributeur d0_ ORDER BY d0_.nom ASC
Parameters:
[] |
|
0.64 ms (0.95%) |
1 |
SELECT t0.id AS id_1, t0.old_id AS old_id_2, t0.roles AS roles_3, t0.email AS email_4, t0.username AS username_5, t0.last_login AS last_login_6, t0.confirmation_token AS confirmation_token_7, t0.password_requested_at AS password_requested_at_8, t0.password AS password_9, t0.enabled AS enabled_10, t0.date_creation AS date_creation_11, t0.token_api AS token_api_12, t13.id AS id_14, t13.nom AS nom_15, t13.prenom AS prenom_16, t13.telephone AS telephone_17, t13.code_abomarque AS code_abomarque_18, t13.commentaire AS commentaire_19, t13.facebook AS facebook_20, t13.twitter AS twitter_21, t13.email AS email_22, t13.old_id AS old_id_23, t13.civilite AS civilite_24, t13.old_userid AS old_userid_25, t13.actif AS actif_26, t13.bio AS bio_27, t13.has_photo AS has_photo_28, t13.is_referent AS is_referent_29, t13.date_creation AS date_creation_30, t13.receive_nmardi AS receive_nmardi_31, t13.receive_nvendredi AS receive_nvendredi_32, t13.receive_ireseau AS receive_ireseau_33, t13.structure_id AS structure_id_34, t13.adresse_id AS adresse_id_35, t13.utilisateur_id AS utilisateur_id_36, t13.news_contact_id AS news_contact_id_37, t0.client_id AS client_id_38 FROM user t0 LEFT JOIN contact t13 ON t13.utilisateur_id = t0.id WHERE t0.id = ?
Parameters:
[
14361
]
|
|
0.54 ms (0.79%) |
1 |
SELECT g0_.id AS id_0, g0_.nom AS nom_1, g0_.nom_electre AS nom_electre_2, g0_.couleur AS couleur_3, g0_.ordre AS ordre_4, g0_.slug AS slug_5, g0_.old_id AS old_id_6, g0_.color1 AS color1_7, g0_.color2 AS color2_8, g0_.parent_id AS parent_id_9 FROM genre g0_
Parameters:
[] |
|
0.28 ms (0.41%) |
1 |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.sous_titre AS sous_titre_3, t0.date_ajout AS date_ajout_4, t0.nb_page AS nb_page_5, t0.prix AS prix_6, t0.traducteur AS traducteur_7, t0.ean AS ean_8, t0.collection AS collection_9, t0.date_parution AS date_parution_10, t0.video AS video_11, t0.audio AS audio_12, t0.poche AS poche_13, t0.url_feuilletage AS url_feuilletage_14, t0.premier_roman AS premier_roman_15, t0.update_at AS update_at_16, t0.old_id AS old_id_17, t0.slug AS slug_18, t0.is_web_only AS is_web_only_19, t0.has_couv AS has_couv_20, t0.reco_text AS reco_text_21, t0.info_techis_valid AS info_techis_valid_22, t0.mediasis_valid AS mediasis_valid_23, t0.chroniqueis_valid AS chroniqueis_valid_24, t0.maquette_ftis_valid AS maquette_ftis_valid_25, t0.maquette_mediais_valid AS maquette_mediais_valid_26, t0.maquette_chroniqueis_valid AS maquette_chroniqueis_valid_27, t0.reco_is_valid AS reco_is_valid_28, t0.maquette_reco_is_valid AS maquette_reco_is_valid_29, t0.niveau_libraire AS niveau_libraire_30, t0.jpro_video AS jpro_video_31, t0.has_thumb AS has_thumb_32, t0.image_interieur AS image_interieur_33, t0.url_interieur AS url_interieur_34, t0.genre_id AS genre_id_35, t0.type_id AS type_id_36, t0.niveau_id AS niveau_id_37, t0.distributeur_id AS distributeur_id_38, t0.ecrivain_voyageur_id AS ecrivain_voyageur_id_39, t0.jplecture_id AS jplecture_id_40, t0.j_pro_editeur_id AS j_pro_editeur_id_41, t0.categorie_id AS categorie_id_42, t0.interieur_ext_id AS interieur_ext_id_43 FROM livre t0 WHERE t0.id = ?
Parameters:
[
"25577"
]
|
|
0.26 ms (0.38%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.nom_electre AS nom_electre_3, t0.couleur AS couleur_4, t0.ordre AS ordre_5, t0.slug AS slug_6, t0.old_id AS old_id_7, t0.color1 AS color1_8, t0.color2 AS color2_9, t0.parent_id AS parent_id_10 FROM genre t0 WHERE t0.id = ?
Parameters:
[
7
]
|
|
0.21 ms (0.31%) |
1 |
SELECT r0_.id AS id_0, r0_.nom AS nom_1, r0_.numero AS numero_2, r0_.date_publication AS date_publication_3, r0_.date_bouclage AS date_bouclage_4, r0_.date_livraison AS date_livraison_5, r0_.date_butoir AS date_butoir_6, r0_.cle_pressmo AS cle_pressmo_7, r0_.repertoire AS repertoire_8, r0_.prix AS prix_9, r0_.epuise AS epuise_10 FROM revue r0_ ORDER BY r0_.date_publication DESC
Parameters:
[] |
|
0.17 ms (0.25%) |
1 |
SELECT t0.id AS id_1, t0.prenom AS prenom_2, t0.nom AS nom_3, t0.biographie AS biographie_4, t0.bibliographie AS bibliographie_5, t0.date_creation AS date_creation_6, t0.update_at AS update_at_7, t0.is_ecrivain AS is_ecrivain_8, t0.is_illustrateur AS is_illustrateur_9, t0.old_id AS old_id_10, t0.portrait AS portrait_11, t0.id_electre AS id_electre_12, t0.photo_ext_id AS photo_ext_id_13 FROM auteur t0 INNER JOIN livre_auteur ON t0.id = livre_auteur.auteur_id WHERE livre_auteur.livre_id = ?
Parameters:
[
25577
]
|
|
0.16 ms (0.23%) |
1 |
SELECT t0.id AS id_1, t0.prenom AS prenom_2, t0.nom AS nom_3, t0.biographie AS biographie_4, t0.bibliographie AS bibliographie_5, t0.date_creation AS date_creation_6, t0.update_at AS update_at_7, t0.is_ecrivain AS is_ecrivain_8, t0.is_illustrateur AS is_illustrateur_9, t0.old_id AS old_id_10, t0.portrait AS portrait_11, t0.id_electre AS id_electre_12, t0.photo_ext_id AS photo_ext_id_13 FROM auteur t0 INNER JOIN livre_illustrateur ON t0.id = livre_illustrateur.auteur_id WHERE livre_illustrateur.livre_id = ?
Parameters:
[
25577
]
|
|
0.15 ms (0.22%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.numero AS numero_3, t0.date_publication AS date_publication_4, t0.date_bouclage AS date_bouclage_5, t0.date_livraison AS date_livraison_6, t0.date_butoir AS date_butoir_7, t0.cle_pressmo AS cle_pressmo_8, t0.repertoire AS repertoire_9, t0.prix AS prix_10, t0.epuise AS epuise_11 FROM revue t0 INNER JOIN livre_revue ON t0.id = livre_revue.revue_id WHERE livre_revue.livre_id = ? ORDER BY t0.numero DESC
Parameters:
[
25577
]
|
|
0.14 ms (0.20%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.old_id AS old_id_3, t0.slug AS slug_4, t0.date_creation AS date_creation_5, t0.udpate_at AS udpate_at_6, t0.alias_electre AS alias_electre_7, t0.id_electre AS id_electre_8 FROM editeur t0 INNER JOIN livre_editeur ON t0.id = livre_editeur.editeur_id WHERE livre_editeur.livre_id = ?
Parameters:
[
25577
]
|
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\Auteur | 13728 |
| App\Entity\PhotoExtended | 684 |
| App\Entity\Editeur | 603 |
| App\Entity\Revue | 103 |
| App\Entity\Distributeur | 93 |
| App\Entity\Genre | 8 |
| App\Entity\User | 1 |
| App\Entity\Client | 1 |
| App\Entity\Contact | 1 |
| App\Entity\Structure | 1 |
| App\Entity\NewsContact | 1 |
| App\Entity\Livre | 1 |
| App\Entity\JourneePro | 1 |
| App\Entity\JProEditeur | 1 |