Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.image AS image_3,
  t0.description AS description_4,
  t0.dominant AS dominant_5,
  t0.nuancier AS nuancier_6
FROM
  m_collection t0
WHERE
  t0.nom = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.image AS image_3, t0.description AS description_4, t0.dominant AS dominant_5, t0.nuancier AS nuancier_6 FROM m_collection t0 WHERE t0.nom = 'Budget' LIMIT 1;

SELECT
  t0.reference AS reference_1,
  t0.id_collection AS id_collection_2,
  t0.nom AS nom_3,
  t0.description AS description_4,
  t0.couleur AS couleur_5,
  t0.caracteristiques AS caracteristiques_6,
  t0.image_principale AS image_principale_7,
  t0.images_secondaires AS images_secondaires_8,
  t0.schema_produit AS schema_produit_9,
  t0.fiche_technique AS fiche_technique_10,
  t0.notice_montage AS notice_montage_11,
  t0.video AS video_12,
  t0.normes AS normes_13,
  t0.famille AS famille_14,
  t0.poids AS poids_15,
  t0.taille AS taille_16,
  t0.duree AS duree_17,
  t0.prix AS prix_18,
  t0.statut AS statut_19,
  t0.actif AS actif_20,
  t0.materiaux AS materiaux_21,
  t0.kit AS kit_22,
  t0.etat AS etat_23
FROM
  m_produit t0
WHERE
  t0.id_collection = ?
  AND t0.actif = ?

SELECT t0.reference AS reference_1, t0.id_collection AS id_collection_2, t0.nom AS nom_3, t0.description AS description_4, t0.couleur AS couleur_5, t0.caracteristiques AS caracteristiques_6, t0.image_principale AS image_principale_7, t0.images_secondaires AS images_secondaires_8, t0.schema_produit AS schema_produit_9, t0.fiche_technique AS fiche_technique_10, t0.notice_montage AS notice_montage_11, t0.video AS video_12, t0.normes AS normes_13, t0.famille AS famille_14, t0.poids AS poids_15, t0.taille AS taille_16, t0.duree AS duree_17, t0.prix AS prix_18, t0.statut AS statut_19, t0.actif AS actif_20, t0.materiaux AS materiaux_21, t0.kit AS kit_22, t0.etat AS etat_23 FROM m_produit t0 WHERE t0.id_collection = 1661 AND t0.actif = 1;

SELECT
  t0.reference AS reference_1,
  t0.quantity AS quantity_2
FROM
  stocks t0
WHERE
  t0.reference IN (?)

SELECT t0.reference AS reference_1, t0.quantity AS quantity_2 FROM stocks t0 WHERE t0.reference IN ('SDSL02NR');

SELECT
  t0.reference AS reference_1,
  t0.id_collection AS id_collection_2,
  t0.nom AS nom_3,
  t0.description AS description_4,
  t0.couleur AS couleur_5,
  t0.caracteristiques AS caracteristiques_6,
  t0.image_principale AS image_principale_7,
  t0.images_secondaires AS images_secondaires_8,
  t0.schema_produit AS schema_produit_9,
  t0.fiche_technique AS fiche_technique_10,
  t0.notice_montage AS notice_montage_11,
  t0.video AS video_12,
  t0.normes AS normes_13,
  t0.famille AS famille_14,
  t0.poids AS poids_15,
  t0.taille AS taille_16,
  t0.duree AS duree_17,
  t0.prix AS prix_18,
  t0.statut AS statut_19,
  t0.actif AS actif_20,
  t0.materiaux AS materiaux_21,
  t0.kit AS kit_22,
  t0.etat AS etat_23
FROM
  m_produit t0
WHERE
  t0.reference = ?
  AND t0.actif = ?

SELECT t0.reference AS reference_1, t0.id_collection AS id_collection_2, t0.nom AS nom_3, t0.description AS description_4, t0.couleur AS couleur_5, t0.caracteristiques AS caracteristiques_6, t0.image_principale AS image_principale_7, t0.images_secondaires AS images_secondaires_8, t0.schema_produit AS schema_produit_9, t0.fiche_technique AS fiche_technique_10, t0.notice_montage AS notice_montage_11, t0.video AS video_12, t0.normes AS normes_13, t0.famille AS famille_14, t0.poids AS poids_15, t0.taille AS taille_16, t0.duree AS duree_17, t0.prix AS prix_18, t0.statut AS statut_19, t0.actif AS actif_20, t0.materiaux AS materiaux_21, t0.kit AS kit_22, t0.etat AS etat_23 FROM m_produit t0 WHERE t0.reference = 'SDSL02NR' AND t0.actif = 1;

SELECT
  JSON_EXTRACT (infos_libres, '$.UNIVERS1') AS univers1
FROM
  api_produit
WHERE
  reference = 'SDSL02NR'

SELECT JSON_EXTRACT (infos_libres, '$.UNIVERS1') AS univers1 FROM api_produit WHERE reference = 'SDSL02NR';

SELECT
  m_produit.*,
  m_collection.nom AS nom_collection
FROM
  api_produit
  LEFT JOIN m_produit ON api_produit.reference = m_produit.reference
  LEFT JOIN m_collection ON m_produit.id_collection = m_collection.id
WHERE
  (
    JSON_EXTRACT (infos_libres, '$.UNIVERS1') = 'ATELIER-MÉTIERS'
    OR JSON_EXTRACT (infos_libres, '$.UNIVERS2') = 'ATELIER-MÉTIERS'
    OR JSON_EXTRACT (infos_libres, '$.UNIVERS3') = 'ATELIER-MÉTIERS'
  )
  AND actif = 1
GROUP BY
  m_produit.famille

SELECT m_produit.*, m_collection.nom AS nom_collection FROM api_produit LEFT JOIN m_produit ON api_produit.reference = m_produit.reference LEFT JOIN m_collection ON m_produit.id_collection = m_collection.id WHERE (JSON_EXTRACT (infos_libres, '$.UNIVERS1') = 'ATELIER-MÉTIERS' OR JSON_EXTRACT (infos_libres, '$.UNIVERS2') = 'ATELIER-MÉTIERS' OR JSON_EXTRACT (infos_libres, '$.UNIVERS3') = 'ATELIER-MÉTIERS') AND actif = 1 GROUP BY m_produit.famille;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.image AS image_3,
  t0.description AS description_4,
  t0.dominant AS dominant_5,
  t0.nuancier AS nuancier_6
FROM
  m_collection t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.image AS image_3, t0.description AS description_4, t0.dominant AS dominant_5, t0.nuancier AS nuancier_6 FROM m_collection t0 WHERE t0.id = 1661 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.image AS image_3,
  t0.description AS description_4,
  t0.dominant AS dominant_5,
  t0.nuancier AS nuancier_6
FROM
  m_collection t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.image AS image_3, t0.description AS description_4, t0.dominant AS dominant_5, t0.nuancier AS nuancier_6 FROM m_collection t0 WHERE t0.id = 1627 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.image AS image_3,
  t0.description AS description_4,
  t0.dominant AS dominant_5,
  t0.nuancier AS nuancier_6
FROM
  m_collection t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.image AS image_3, t0.description AS description_4, t0.dominant AS dominant_5, t0.nuancier AS nuancier_6 FROM m_collection t0 WHERE t0.id = 1634 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.image AS image_3,
  t0.description AS description_4,
  t0.dominant AS dominant_5,
  t0.nuancier AS nuancier_6
FROM
  m_collection t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.image AS image_3, t0.description AS description_4, t0.dominant AS dominant_5, t0.nuancier AS nuancier_6 FROM m_collection t0 WHERE t0.id = 1671 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.image AS image_3,
  t0.description AS description_4,
  t0.dominant AS dominant_5,
  t0.nuancier AS nuancier_6
FROM
  m_collection t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.image AS image_3, t0.description AS description_4, t0.dominant AS dominant_5, t0.nuancier AS nuancier_6 FROM m_collection t0 WHERE t0.id = 1660 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.image AS image_3,
  t0.description AS description_4,
  t0.dominant AS dominant_5,
  t0.nuancier AS nuancier_6
FROM
  m_collection t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.image AS image_3, t0.description AS description_4, t0.dominant AS dominant_5, t0.nuancier AS nuancier_6 FROM m_collection t0 WHERE t0.id = 1672 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.image AS image_3,
  t0.description AS description_4,
  t0.dominant AS dominant_5,
  t0.nuancier AS nuancier_6
FROM
  m_collection t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.image AS image_3, t0.description AS description_4, t0.dominant AS dominant_5, t0.nuancier AS nuancier_6 FROM m_collection t0 WHERE t0.id = 1766 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.image AS image_3,
  t0.description AS description_4,
  t0.dominant AS dominant_5,
  t0.nuancier AS nuancier_6
FROM
  m_collection t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.image AS image_3, t0.description AS description_4, t0.dominant AS dominant_5, t0.nuancier AS nuancier_6 FROM m_collection t0 WHERE t0.id = 1677 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.image AS image_3,
  t0.description AS description_4,
  t0.dominant AS dominant_5,
  t0.nuancier AS nuancier_6
FROM
  m_collection t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.image AS image_3, t0.description AS description_4, t0.dominant AS dominant_5, t0.nuancier AS nuancier_6 FROM m_collection t0 WHERE t0.id = 1673 LIMIT 1;