Query Metrics
4
Database Queries
4
Different statements
6.15 ms
Query time
14
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 3.95 ms |
SELECT t0.id AS id_1, t0.titre_url AS titre_url_2, t0.titre AS titre_3, t0.texte AS texte_4, t0.ordre AS ordre_5, t0.actif AS actif_6, t0.langue AS langue_7, t0.largeur_grand AS largeur_grand_8, t0.largeur_petit AS largeur_petit_9 FROM actualites_cat t0 WHERE t0.id = ?
Parameters:
[
1
]
|
2 | 0.71 ms |
SELECT a0_.id AS id_0, a0_.titre_url AS titre_url_1, a0_.titre AS titre_2, a0_.texte_court AS texte_court_3, a0_.texte AS texte_4, a0_.mots_cles AS mots_cles_5, a0_.auteur AS auteur_6, a0_.auteur_lien AS auteur_lien_7, a0_.date AS date_8, a0_.date_debut AS date_debut_9, a0_.date_fin AS date_fin_10, a0_.ordre AS ordre_11, a0_.actif AS actif_12, a0_.lectures AS lectures_13, a0_.langue AS langue_14, a0_.une AS une_15, a0_.photo AS photo_16, a0_.actualites_associees AS actualites_associees_17, a0_.id_cat1 AS id_cat1_18, a0_.id_cat2 AS id_cat2_19, a0_.ecole_id AS ecole_id_20 FROM actualites a0_ WHERE a0_.actif = '1' AND a0_.id_cat1 = '1' AND a0_.ecole_id = 'haguenau' AND a0_.langue = 'fr' ORDER BY a0_.date DESC LIMIT 8
Parameters:
[] |
3 | 0.70 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.titre_url AS titre_url_3, t0.titre_select AS titre_select_4, t0.titre_page AS titre_page_5, t0.mots_cles AS mots_cles_6, t0.description AS description_7, t0.texte_court AS texte_court_8, t0.texte AS texte_9, t0.langue AS langue_10, t0.ordre AS ordre_11, t0.type AS type_12, t0.deroulant AS deroulant_13, t0.lien_page AS lien_page_14, t0.page AS page_15, t0.filtre AS filtre_16, t0.actif AS actif_17, t0.cle AS cle_18, t0.parent_page_id AS parent_page_id_19, t0.ecole_id AS ecole_id_20 FROM www_contenu t0 WHERE t0.filtre = ? AND t0.ecole_id = ? ORDER BY t0.ordre ASC
Parameters:
[ "menu" "haguenau" ] |
4 | 0.79 ms |
SELECT a0_.id AS id_0, a0_.titre_url AS titre_url_1, a0_.titre AS titre_2, a0_.texte_court AS texte_court_3, a0_.texte AS texte_4, a0_.mots_cles AS mots_cles_5, a0_.auteur AS auteur_6, a0_.auteur_lien AS auteur_lien_7, a0_.date AS date_8, a0_.date_debut AS date_debut_9, a0_.date_fin AS date_fin_10, a0_.ordre AS ordre_11, a0_.actif AS actif_12, a0_.lectures AS lectures_13, a0_.langue AS langue_14, a0_.une AS une_15, a0_.photo AS photo_16, a0_.actualites_associees AS actualites_associees_17, a0_.id_cat1 AS id_cat1_18, a0_.id_cat2 AS id_cat2_19, a0_.ecole_id AS ecole_id_20 FROM actualites a0_ WHERE a0_.actif = '1' AND a0_.id_cat1 = '1' AND a0_.ecole_id = 'haguenau' AND a0_.langue = 'fr' ORDER BY a0_.date DESC LIMIT 1
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\Actualites\ActualitesCat | No errors. |
App\Entity\Actualites\Actualites |
|
App\Entity\Ecoles\Ecoles | No errors. |
App\Entity\Www\Contenu | No errors. |
App\Entity\Actualites\ActualitesCom | No errors. |
App\Entity\Www\Login | No errors. |
App\Entity\Encarts\Encarts | No errors. |
App\Entity\ContactForm | No errors. |
App\Entity\Www\LoginHistorique | No errors. |
App\Entity\Rgpd\RgpdForm |
|
App\Entity\Www\Erreurs | No errors. |
App\Entity\Www\LoginLog |
|
App\Entity\Www\Departements | No errors. |
App\Entity\Www\Pays | No errors. |
App\Entity\Www\NotifsEmails | No errors. |
App\Entity\Www\Textes | No errors. |
App\Entity\Www\LoginIps |
|
App\Entity\Www\LoginNotifications |
|
App\Entity\Www\Langues | No errors. |
App\Entity\Www\LoginDroits |
|
App\Entity\Www\Regions | No errors. |
App\Entity\Clients\ClientsContacts | No errors. |
App\Entity\Clients\ClientsCategories | No errors. |
App\Entity\Clients\Clients |
|
App\Entity\Clients\ClientsPhotos | No errors. |
App\Entity\Clients\ClientsParrainage | No errors. |
App\Entity\Clients\ClientsAdresses | No errors. |
App\Entity\Clients\ClientsTypes | No errors. |
App\Entity\Clients\ClientsHistorique | No errors. |
App\Entity\Clients\ClientsIp | No errors. |
App\Entity\MigrationVersions | No errors. |
App\Entity\Newsletter\NewsletterClics | No errors. |
App\Entity\Newsletter\NewsletterGroupes | No errors. |
App\Entity\Newsletter\NewsletterEnvois | No errors. |
App\Entity\Newsletter\NewsletterDesinscriptions | No errors. |
App\Entity\Newsletter\NewsletterExpediteurs | No errors. |
App\Entity\Newsletter\NewsletterAdresses | No errors. |
App\Entity\Newsletter\NewsletterPiecesJointes | No errors. |
App\Entity\Newsletter\Newsletter | No errors. |
App\Entity\Gca\Societe\GcaSociete | No errors. |
App\Entity\Gca\Paiements\GcaPaiements | No errors. |
App\Entity\Gca\Paiements\GcaPaiementsTypes | No errors. |
App\Entity\Gca\Paiements\GcaDelaisReglement | No errors. |
App\Entity\Gca\Marges\GcaMarges | No errors. |
App\Entity\Gca\Statuts\GcaStatuts | No errors. |
App\Entity\Gca\Cpt\GcaCptClients | No errors. |
App\Entity\Gca\Cpt\GcaCptFournisseurs | No errors. |
App\Entity\Gca\Cpt\GcaCptTva | No errors. |
App\Entity\Gca\Cpt\GcaCptProduits | No errors. |
App\Entity\Gca\Tva\GcaTva | No errors. |
App\Entity\Gca\Articles\GcaArticles | No errors. |
App\Entity\Gca\RemisesBanque\GcaRemisesBanqueLignes | No errors. |
App\Entity\Gca\RemisesBanque\GcaRemisesBanque | No errors. |
App\Entity\Gca\Stock\GcaStockMouvements | No errors. |
App\Entity\Gca\Stock\GcaStock | No errors. |
App\Entity\Gca\Stock\GcaStockDepots | No errors. |
App\Entity\Gca\Banques\GcaBanques | No errors. |
App\Entity\Gca\Abonnements\GcaAbonnements | No errors. |
App\Entity\Gca\Documents\GcaDevisLignes | No errors. |
App\Entity\Gca\Documents\GcaDemandesPrixLignes | No errors. |
App\Entity\Gca\Documents\GcaCommandesFournisseurs | No errors. |
App\Entity\Gca\Documents\GcaCommandesLignes | No errors. |
App\Entity\Gca\Documents\GcaBlLignes | No errors. |
App\Entity\Gca\Documents\GcaFactures | No errors. |
App\Entity\Gca\Documents\GcaBl | No errors. |
App\Entity\Gca\Documents\GcaDevis | No errors. |
App\Entity\Gca\Documents\GcaBonsReception | No errors. |
App\Entity\Gca\Documents\GcaBonsReceptionLignes | No errors. |
App\Entity\Gca\Documents\GcaAvoirsLignes | No errors. |
App\Entity\Gca\Documents\GcaAvoirs | No errors. |
App\Entity\Gca\Documents\GcaFacturesLignes | No errors. |
App\Entity\Gca\Documents\GcaPapiers | No errors. |
App\Entity\Gca\Documents\GcaPapiersLignes | No errors. |
App\Entity\Gca\Documents\GcaDemandesPrix | No errors. |
App\Entity\Gca\Documents\GcaCommandes | No errors. |
App\Entity\Gca\Documents\GcaCommandesFournisseursLignes | No errors. |
App\Entity\Boutique\Bons\BtBons | No errors. |
App\Entity\Boutique\FraisPort\BtFraisPortZonesPays | No errors. |
App\Entity\Boutique\FraisPort\BtFraisPort | No errors. |
App\Entity\Boutique\FraisPort\BtFraisPortZones | No errors. |
App\Entity\Boutique\FraisPort\BtFraisPortTransporteurs | No errors. |
App\Entity\Boutique\FraisPort\BtFraisPortTypes | No errors. |
App\Entity\Boutique\Devises\BtDevises |
|
App\Entity\Boutique\Marques\BtMarques | No errors. |
App\Entity\Boutique\ListeAchats\BtListeAchats | No errors. |
App\Entity\Boutique\ListeAchats\BtListeAchatsLignes | No errors. |
App\Entity\Boutique\Paiements\BtPaiementsTypes | No errors. |
App\Entity\Boutique\Paiements\BtPaiements | No errors. |
App\Entity\Boutique\Remises\BtRemises | No errors. |
App\Entity\Boutique\Categories\BtCategories | No errors. |
App\Entity\Boutique\Tva\BtTva | No errors. |
App\Entity\Boutique\Commentaires\BtCommentaires | No errors. |
App\Entity\Boutique\Articles\BtArticlesVentesFlash | No errors. |
App\Entity\Boutique\Articles\BtArticlesCaracteristiques | No errors. |
App\Entity\Boutique\Articles\BtArticlesPrix | No errors. |
App\Entity\Boutique\Articles\BtArticlesVideos | No errors. |
App\Entity\Boutique\Articles\BtArticlesMots | No errors. |
App\Entity\Boutique\Articles\BtArticlesMedias | No errors. |
App\Entity\Boutique\Articles\BtArticlesGammes | No errors. |
App\Entity\Boutique\Articles\BtArticlesMediasTypes | No errors. |
App\Entity\Boutique\Articles\BtArticlesBtCategories | No errors. |
App\Entity\Boutique\Articles\BtArticles | No errors. |
App\Entity\Boutique\Articles\BtArticlesAssocies | No errors. |
App\Entity\Boutique\Articles\BtArticlesComposes | No errors. |
App\Entity\Boutique\Caracteristiques\BtCaracteristiquesTypes | No errors. |
App\Entity\Boutique\Caracteristiques\BtCaracteristiques | No errors. |
App\Entity\Boutique\Gammes\BtGammesTypesGroupes | No errors. |
App\Entity\Boutique\Gammes\BtGammes | No errors. |
App\Entity\Boutique\Gammes\BtGammesTypes | No errors. |
App\Entity\Boutique\Commandes\BtCommandes |
|
App\Entity\Boutique\Commandes\BtCommandesReductions |
|
App\Entity\Boutique\Commandes\BtCommandesLignes | No errors. |
App\Entity\Boutique\Commandes\BtCommandesEtatsTypes | No errors. |
App\Entity\Boutique\Commandes\BtCommandesColis |
|
App\Entity\Boutique\Commandes\BtCommandesEtats | No errors. |
App\Entity\Boutique\Recherche\BtRechercheHist | No errors. |
App\Entity\Boutique\Stock\BtStockMovement | No errors. |
App\Entity\Boutique\Stock\BtStockLocation | No errors. |
App\Entity\Boutique\Stock\BtStock | No errors. |
App\Entity\Boutique\Traductions\BtTraductions |
|
App\Entity\Boutique\Paniers\BtPaniers | No errors. |
App\Entity\Boutique\Paniers\BtPaniersLignes | No errors. |
App\Entity\Crm\CrmLignes |
|
App\Entity\Crm\Crm |
|
App\Entity\Crm\CrmStatuts | No errors. |
App\Entity\Crm\CrmTypes | No errors. |
App\Entity\Fournisseurs\FournisseursContacts | No errors. |
App\Entity\Fournisseurs\FournisseursMedias | No errors. |
App\Entity\Fournisseurs\Fournisseurs | No errors. |
Vich\UploaderBundle\Entity\File | No errors. |