https://abcm-vitrine.atiweb.fr/

Query Metrics

10 Database Queries
8 Different statements
8.11 ms Query time
14 Invalid entities

Grouped Statements

Show all queries

Time Count Info
3.12 ms
(38.44%)
1
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.cle = ? AND t0.langue = ? LIMIT 1
Parameters:
[
  "home"
  "fr"
]
1.16 ms
(14.33%)
3
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.fichier AS fichier_3, t0.ordre AS ordre_4, t0.note AS note_5, t0.id_fournisseur AS id_fournisseur_6 FROM fournisseurs_medias t0 WHERE t0.id_fournisseur = ?
Parameters:
[
  1
]
0.91 ms
(11.16%)
1
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_.langue = 'fr' ORDER BY a0_.date DESC LIMIT 4
Parameters:
[]
0.67 ms
(8.23%)
1
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 IS NULL ORDER BY t0.ordre ASC
Parameters:
[
  "menu"
]
0.65 ms
(7.99%)
1
SELECT t0.id AS id_1, t0.societe AS societe_2, t0.nom_url AS nom_url_3, t0.tva_intracomm AS tva_intracomm_4, t0.siret AS siret_5, t0.num_compta AS num_compta_6, t0.nom AS nom_7, t0.prenom AS prenom_8, t0.civilite AS civilite_9, t0.fonction AS fonction_10, t0.adresse AS adresse_11, t0.adresse2 AS adresse2_12, t0.code_postal AS code_postal_13, t0.ville AS ville_14, t0.pays AS pays_15, t0.telephone AS telephone_16, t0.mobile AS mobile_17, t0.fax AS fax_18, t0.email AS email_19, t0.pass AS pass_20, t0.newsletter AS newsletter_21, t0.groupe_newsletter AS groupe_newsletter_22, t0.date AS date_23, t0.connecte AS connecte_24, t0.hors_taxes AS hors_taxes_25, t0.site_web AS site_web_26, t0.actif AS actif_27, t0.note AS note_28, t0.cle AS cle_29, t0.paiement AS paiement_30, t0.old_id AS old_id_31 FROM fournisseurs t0 WHERE t0.actif = ?
Parameters:
[
  1
]
0.61 ms
(7.46%)
1
SELECT DISTINCT e0_.id AS id_0, e0_.date_debut AS date_debut_1, e0_.date_fin AS date_fin_2, e0_.id_actualite AS id_actualite_3, e0_.titre AS titre_4, e0_.texte AS texte_5, e0_.image AS image_6, e0_.lien AS lien_7, e0_.ordre AS ordre_8, e0_.actif AS actif_9, e0_.langue AS langue_10, e0_.ecole_id AS ecole_id_11 FROM encarts e0_ WHERE e0_.actif = '1' AND e0_.ecole_id IS NULL ORDER BY e0_.ordre ASC LIMIT 4
Parameters:
[]
0.53 ms
(6.52%)
1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.nom_url AS nom_url_3, t0.nom_de AS nom_de_4, t0.nom_de_url AS nom_de_url_5, t0.texte AS texte_6, t0.texte_de AS texte_de_7, t0.photo AS photo_8, t0.ordre AS ordre_9, t0.actif AS actif_10, t0.latitude AS latitude_11, t0.longitude AS longitude_12, t0.couleur AS couleur_13, t0.adresse AS adresse_14, t0.code_postal AS code_postal_15, t0.ville AS ville_16, t0.pays AS pays_17, t0.email AS email_18, t0.tel1 AS tel1_19, t0.tel2 AS tel2_20, t0.facebook AS facebook_21, t0.asso_nom AS asso_nom_22, t0.asso_adresse AS asso_adresse_23, t0.asso_code_postal AS asso_code_postal_24, t0.asso_ville AS asso_ville_25, t0.asso_email AS asso_email_26, t0.asso_tel1 AS asso_tel1_27, t0.asso_tel2 AS asso_tel2_28, t0.site_url AS site_url_29, t0.site_titre AS site_titre_30, t0.texte_asso AS texte_asso_31 FROM ecoles t0 WHERE t0.actif = ? ORDER BY t0.ordre ASC, t0.nom ASC
Parameters:
[
  1
]
0.48 ms
(5.87%)
1
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 = '' 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\Www\Contenu No errors.
App\Entity\Ecoles\Ecoles No errors.
App\Entity\Actualites\Actualites
  • The mappings App\Entity\Actualites\Actualites#idCat2 and App\Entity\Actualites\ActualitesCat#actualites are inconsistent with each other.
App\Entity\Actualites\ActualitesCat No errors.
App\Entity\Actualites\ActualitesCom No errors.
App\Entity\Encarts\Encarts No errors.
App\Entity\Www\Login No errors.
App\Entity\ContactForm No errors.
App\Entity\Fournisseurs\Fournisseurs No errors.
App\Entity\Fournisseurs\FournisseursContacts No errors.
App\Entity\Fournisseurs\FournisseursMedias No errors.
App\Entity\Www\LoginHistorique No errors.
App\Entity\Rgpd\RgpdForm
  • The field App\Entity\Rgpd\RgpdForm#contactForm is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\ContactForm#rgpdForm does not contain the required 'mappedBy="contactForm"' attribute.
App\Entity\Www\Erreurs No errors.
App\Entity\Www\LoginLog
  • The association App\Entity\Www\LoginLog#login refers to the inverse side field App\Entity\Www\Login#logs which does not exist.
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
  • The association App\Entity\Www\LoginIps#login refers to the inverse side field App\Entity\Www\Login#ips which does not exist.
App\Entity\Www\LoginNotifications
  • The association App\Entity\Www\LoginNotifications#login refers to the inverse side field App\Entity\Www\Login#notifications which does not exist.
App\Entity\Www\Langues No errors.
App\Entity\Www\LoginDroits
  • The association App\Entity\Www\LoginDroits#login refers to the inverse side field App\Entity\Www\Login#droits which does not exist.
App\Entity\Www\Regions No errors.
App\Entity\Clients\ClientsContacts No errors.
App\Entity\Clients\ClientsCategories No errors.
App\Entity\Clients\Clients
  • The mappings App\Entity\Clients\Clients#commandes and App\Entity\Boutique\Commandes\BtCommandes#client are inconsistent with each other.
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
  • The association App\Entity\Boutique\Devises\BtDevises#pays refers to the inverse side field App\Entity\Www\Pays#btDevises which does not exist.
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
  • The association App\Entity\Boutique\Commandes\BtCommandes#client refers to the inverse side field App\Entity\Clients\Clients#btCommandes which does not exist.
  • The association App\Entity\Boutique\Commandes\BtCommandes#transporteur refers to the inverse side field App\Entity\Boutique\FraisPort\BtFraisPortTransporteurs#btCommandes which does not exist.
App\Entity\Boutique\Commandes\BtCommandesReductions
  • The association App\Entity\Boutique\Commandes\BtCommandesReductions#commande refers to the inverse side field App\Entity\Boutique\Commandes\BtCommandes#reductions which does not exist.
App\Entity\Boutique\Commandes\BtCommandesLignes No errors.
App\Entity\Boutique\Commandes\BtCommandesEtatsTypes No errors.
App\Entity\Boutique\Commandes\BtCommandesColis
  • The association App\Entity\Boutique\Commandes\BtCommandesColis#commande refers to the inverse side field App\Entity\Boutique\Commandes\BtCommandes#btCommandesColis which does not exist.
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
  • The association App\Entity\Boutique\Traductions\BtTraductions#article refers to the inverse side field App\Entity\Boutique\Articles\BtArticles#traductions which does not exist.
  • The association App\Entity\Boutique\Traductions\BtTraductions#categorie refers to the inverse side field App\Entity\Boutique\Categories\BtCategories#traductions which does not exist.
  • The association App\Entity\Boutique\Traductions\BtTraductions#gammes refers to the inverse side field App\Entity\Boutique\Gammes\BtGammes#traductions which does not exist.
  • The association App\Entity\Boutique\Traductions\BtTraductions#gammeType refers to the inverse side field App\Entity\Boutique\Gammes\BtGammesTypes#traductions which does not exist.
App\Entity\Boutique\Paniers\BtPaniers No errors.
App\Entity\Boutique\Paniers\BtPaniersLignes No errors.
App\Entity\Crm\CrmLignes
  • The association App\Entity\Crm\CrmLignes#article refers to the inverse side field App\Entity\Boutique\Articles\BtArticles#crmLignes which does not exist.
App\Entity\Crm\Crm
  • The association App\Entity\Crm\Crm#type refers to the inverse side field App\Entity\Crm\CrmTypes#crm which does not exist.
  • The association App\Entity\Crm\Crm#client refers to the inverse side field App\Entity\Clients\Clients#crm which does not exist.
  • The association App\Entity\Crm\Crm#statut refers to the inverse side field App\Entity\Crm\CrmStatuts#crm which does not exist.
App\Entity\Crm\CrmStatuts No errors.
App\Entity\Crm\CrmTypes No errors.
Vich\UploaderBundle\Entity\File No errors.