https://koaven-fromagerie.test.ovh1.agence-11h10.fr/boutique/beurre-1-2-sel-fermier-a-la-coupe

Query Metrics

7 Database Queries
7 Different statements
3.98 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 0.46 ms
SELECT t0.date_creation AS date_creation_1, t0.date_maj AS date_maj_2, t0.id AS id_3, t0.nom AS nom_4, t0.slug AS slug_5, t0.description AS description_6, t0.prix_unitaire AS prix_unitaire_7, t0.prix_kg_l AS prix_kg_l_8, t0.poids AS poids_9, t0.display AS display_10, t0.is_poids AS is_poids_11, t0.photo AS photo_12, t0.unite_mesure AS unite_mesure_13, t0.nb_personne AS nb_personne_14, t0.categorie_id AS categorie_id_15, t0.type_id AS type_id_16, t0.origine_id AS origine_id_17, t0.lait_id AS lait_id_18, t0.lait_traitement_id AS lait_traitement_id_19, t0.theme_id AS theme_id_20 FROM produit t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "beurre-1-2-sel-fermier-a-la-coupe"
]
2 1.32 ms
SELECT p.id, p.nom, p.slug, p.description, p.prix_unitaire, p.prix_kg_l, p.poids, c.nom as nom_categorie
            FROM produit p 
            JOIN categorie c ON c.id = p.categorie_id
            WHERE p.display = true
            AND c.id = :categorie
            AND p.id != :id
            ORDER BY RAND()
            LIMIT 6
Parameters:
[
  "categorie" => 2
  "id" => 1
]
3 0.43 ms
SELECT t0.date_creation AS date_creation_1, t0.date_maj AS date_maj_2, t0.id AS id_3, t0.nom AS nom_4, t0.slug AS slug_5, t0.description AS description_6, t0.prix_unitaire AS prix_unitaire_7, t0.prix_kg_l AS prix_kg_l_8, t0.poids AS poids_9, t0.display AS display_10, t0.is_poids AS is_poids_11, t0.photo AS photo_12, t0.unite_mesure AS unite_mesure_13, t0.nb_personne AS nb_personne_14, t0.categorie_id AS categorie_id_15, t0.type_id AS type_id_16, t0.origine_id AS origine_id_17, t0.lait_id AS lait_id_18, t0.lait_traitement_id AS lait_traitement_id_19, t0.theme_id AS theme_id_20 FROM produit t0 WHERE t0.id IN (?)
Parameters:
[
  [
    "137"
    "139"
    "144"
    "14"
    "142"
    "4"
  ]
]
4 0.89 ms
SELECT t0.date_creation AS date_creation_1, t0.date_maj AS date_maj_2, t0.id AS id_3, t0.nom AS nom_4, t0.slug AS slug_5, t0.description AS description_6, t0.prix_unitaire AS prix_unitaire_7, t0.prix_kg_l AS prix_kg_l_8, t0.poids AS poids_9, t0.display AS display_10, t0.is_poids AS is_poids_11, t0.photo AS photo_12, t0.unite_mesure AS unite_mesure_13, t0.nb_personne AS nb_personne_14, t0.categorie_id AS categorie_id_15, t0.type_id AS type_id_16, t0.origine_id AS origine_id_17, t0.lait_id AS lait_id_18, t0.lait_traitement_id AS lait_traitement_id_19, t0.theme_id AS theme_id_20 FROM produit t0
Parameters:
[]
5 0.33 ms
SELECT t0.id AS id_1, t0.active AS active_2, t0.content AS content_3 FROM drive t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
6 0.35 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.display AS display_3 FROM lait t0 WHERE t0.id = ?
Parameters:
[
  2
]
7 0.20 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.display AS display_3 FROM lait_traitement t0 WHERE t0.id = ?
Parameters:
[
  2
]

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\Historisation No errors.
App\Entity\Produit
  • The mappings App\Entity\Produit#type and App\Entity\Type#produits are inconsistent with each other.
App\Entity\Categorie No errors.
App\Entity\Type
  • The association App\Entity\Type#produits refers to the owning side field App\Entity\Produit#type_id which does not exist.
App\Entity\Origine No errors.
App\Entity\Lait No errors.
App\Entity\LaitTraitement No errors.
App\Entity\ThemePlateau No errors.
App\Entity\PanierProduits No errors.
App\Entity\Drive No errors.