Symfony Profiler

SELECT
  a0_.nom AS nom_0,
  a0_.nom_canonique AS nom_canonique_1,
  a0_.montant AS montant_2,
  a0_.reference AS reference_3,
  a0_.descriptif AS descriptif_4,
  a0_.gamme AS gamme_5,
  a0_.id AS id_6,
  a0_.vedete AS vedete_7,
  a0_.bigblue AS bigblue_8,
  a0_.pourcentage AS pourcentage_9,
  a0_.nouveaute AS nouveaute_10,
  a0_.actif AS actif_11,
  a0_.dateajout AS dateajout_12,
  a0_.livraison_gratuite AS livraison_gratuite_13,
  a0_.nombre_etoile AS nombre_etoile_14,
  a0_.id_marque AS id_marque_15,
  a0_.id_etat AS id_etat_16,
  a0_.commande_id AS commande_id_17
FROM
  article a0_
WHERE
  a0_.id = ?
  AND a0_.actif = ?
ORDER BY
  a0_.id ASC

SELECT a0_.nom AS nom_0, a0_.nom_canonique AS nom_canonique_1, a0_.montant AS montant_2, a0_.reference AS reference_3, a0_.descriptif AS descriptif_4, a0_.gamme AS gamme_5, a0_.id AS id_6, a0_.vedete AS vedete_7, a0_.bigblue AS bigblue_8, a0_.pourcentage AS pourcentage_9, a0_.nouveaute AS nouveaute_10, a0_.actif AS actif_11, a0_.dateajout AS dateajout_12, a0_.livraison_gratuite AS livraison_gratuite_13, a0_.nombre_etoile AS nombre_etoile_14, a0_.id_marque AS id_marque_15, a0_.id_etat AS id_etat_16, a0_.commande_id AS commande_id_17 FROM article a0_ WHERE a0_.id = 892 AND a0_.actif = 1 ORDER BY a0_.id ASC;

SELECT
  t0.nom AS nom_1,
  t0.type AS type_2,
  t0.path AS path_3,
  t0.id AS id_4,
  t0.image AS image_5,
  t0.caroussel_id AS caroussel_id_6,
  t0.article_idarticle AS article_idarticle_7,
  t0.id_categorie AS id_categorie_8,
  t0.produit_mannuels_id AS produit_mannuels_id_9
FROM
  image t0
WHERE
  t0.id = ?

SELECT t0.nom AS nom_1, t0.type AS type_2, t0.path AS path_3, t0.id AS id_4, t0.image AS image_5, t0.caroussel_id AS caroussel_id_6, t0.article_idarticle AS article_idarticle_7, t0.id_categorie AS id_categorie_8, t0.produit_mannuels_id AS produit_mannuels_id_9 FROM image t0 WHERE t0.id = 1708;

SELECT
  t0.nom AS nom_1,
  t0.type AS type_2,
  t0.path AS path_3,
  t0.id AS id_4,
  t0.image AS image_5,
  t0.caroussel_id AS caroussel_id_6,
  t0.article_idarticle AS article_idarticle_7,
  t0.id_categorie AS id_categorie_8,
  t0.produit_mannuels_id AS produit_mannuels_id_9
FROM
  image t0
WHERE
  t0.caroussel_id = ?

SELECT t0.nom AS nom_1, t0.type AS type_2, t0.path AS path_3, t0.id AS id_4, t0.image AS image_5, t0.caroussel_id AS caroussel_id_6, t0.article_idarticle AS article_idarticle_7, t0.id_categorie AS id_categorie_8, t0.produit_mannuels_id AS produit_mannuels_id_9 FROM image t0 WHERE t0.caroussel_id = 3;

SELECT
  m0_.id AS id_0,
  m0_.nom AS nom_1,
  m0_.nom_canonique AS nom_canonique_2,
  m0_.logo AS logo_3,
  a1_.nom AS nom_4,
  a1_.nom_canonique AS nom_canonique_5,
  a1_.montant AS montant_6,
  a1_.reference AS reference_7,
  a1_.descriptif AS descriptif_8,
  a1_.gamme AS gamme_9,
  a1_.id AS id_10,
  a1_.vedete AS vedete_11,
  a1_.bigblue AS bigblue_12,
  a1_.pourcentage AS pourcentage_13,
  a1_.nouveaute AS nouveaute_14,
  a1_.actif AS actif_15,
  a1_.dateajout AS dateajout_16,
  a1_.livraison_gratuite AS livraison_gratuite_17,
  a1_.nombre_etoile AS nombre_etoile_18,
  m0_.immage AS immage_19,
  a1_.id_marque AS id_marque_20,
  a1_.id_etat AS id_etat_21,
  a1_.commande_id AS commande_id_22
FROM
  marque m0_
  LEFT JOIN article a1_ ON m0_.id = a1_.id_marque
LIMIT
  4

SELECT m0_.id AS id_0, m0_.nom AS nom_1, m0_.nom_canonique AS nom_canonique_2, m0_.logo AS logo_3, a1_.nom AS nom_4, a1_.nom_canonique AS nom_canonique_5, a1_.montant AS montant_6, a1_.reference AS reference_7, a1_.descriptif AS descriptif_8, a1_.gamme AS gamme_9, a1_.id AS id_10, a1_.vedete AS vedete_11, a1_.bigblue AS bigblue_12, a1_.pourcentage AS pourcentage_13, a1_.nouveaute AS nouveaute_14, a1_.actif AS actif_15, a1_.dateajout AS dateajout_16, a1_.livraison_gratuite AS livraison_gratuite_17, a1_.nombre_etoile AS nombre_etoile_18, m0_.immage AS immage_19, a1_.id_marque AS id_marque_20, a1_.id_etat AS id_etat_21, a1_.commande_id AS commande_id_22 FROM marque m0_ LEFT JOIN article a1_ ON m0_.id = a1_.id_marque LIMIT 4;

SELECT
  t0.nom AS nom_1,
  t0.type AS type_2,
  t0.path AS path_3,
  t0.id AS id_4,
  t0.image AS image_5,
  t0.caroussel_id AS caroussel_id_6,
  t0.article_idarticle AS article_idarticle_7,
  t0.id_categorie AS id_categorie_8,
  t0.produit_mannuels_id AS produit_mannuels_id_9
FROM
  image t0
WHERE
  t0.article_idarticle = ?

SELECT t0.nom AS nom_1, t0.type AS type_2, t0.path AS path_3, t0.id AS id_4, t0.image AS image_5, t0.caroussel_id AS caroussel_id_6, t0.article_idarticle AS article_idarticle_7, t0.id_categorie AS id_categorie_8, t0.produit_mannuels_id AS produit_mannuels_id_9 FROM image t0 WHERE t0.article_idarticle = 892;

SELECT
  t0.id AS id_1,
  t0.evenement AS evenement_2,
  t0.validite AS validite_3,
  t0.dateajout AS dateajout_4,
  t0.datedebut AS datedebut_5,
  t0.datefin AS datefin_6,
  t0.explication AS explication_7,
  t0.urlvideos AS urlvideos_8,
  t0.image AS image_9
FROM
  topbannieres t0
WHERE
  t0.validite = ?
ORDER BY
  t0.dateajout DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.evenement AS evenement_2, t0.validite AS validite_3, t0.dateajout AS dateajout_4, t0.datedebut AS datedebut_5, t0.datefin AS datefin_6, t0.explication AS explication_7, t0.urlvideos AS urlvideos_8, t0.image AS image_9 FROM topbannieres t0 WHERE t0.validite = 1 ORDER BY t0.dateajout DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.nom_canonique AS nom_canonique_3,
  t0.code_couleur_apli AS code_couleur_apli_4,
  t0.active AS active_5,
  t0.categorie_id AS categorie_id_6,
  t0.image AS image_7,
  t0.image_accueil AS image_accueil_8,
  t0.logo_apli AS logo_apli_9
FROM
  sous_categorie t0
WHERE
  t0.categorie_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.nom_canonique AS nom_canonique_3, t0.code_couleur_apli AS code_couleur_apli_4, t0.active AS active_5, t0.categorie_id AS categorie_id_6, t0.image AS image_7, t0.image_accueil AS image_accueil_8, t0.logo_apli AS logo_apli_9 FROM sous_categorie t0 WHERE t0.categorie_id = 3;

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.code AS code_3,
  t0.description AS description_4,
  t0.position AS position_5,
  t0.slideauto AS slideauto_6,
  t0.pagination AS pagination_7,
  t0.control AS control_8,
  t0.valide AS valide_9,
  t0.intervalle AS intervalle_10,
  t0.height AS height_11,
  t0.bottomcontent AS bottomcontent_12,
  t0.bottomcolor AS bottomcolor_13,
  t0.bottomtext AS bottomtext_14,
  t0.bottombg AS bottombg_15,
  t0.link AS link_16,
  t0.categorie_id AS categorie_id_17,
  t0.souscategorie_id AS souscategorie_id_18
FROM
  hh_caroussels t0
WHERE
  t0.souscategorie_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.code AS code_3, t0.description AS description_4, t0.position AS position_5, t0.slideauto AS slideauto_6, t0.pagination AS pagination_7, t0.control AS control_8, t0.valide AS valide_9, t0.intervalle AS intervalle_10, t0.height AS height_11, t0.bottomcontent AS bottomcontent_12, t0.bottomcolor AS bottomcolor_13, t0.bottomtext AS bottomtext_14, t0.bottombg AS bottombg_15, t0.link AS link_16, t0.categorie_id AS categorie_id_17, t0.souscategorie_id AS souscategorie_id_18 FROM hh_caroussels t0 WHERE t0.souscategorie_id = 47 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.description AS description_3,
  t0.code AS code_4,
  t0.dateajout AS dateajout_5,
  t0.actif AS actif_6,
  t0.taillepoids AS taillepoids_7,
  t0.avantages AS avantages_8,
  t0.prix AS prix_9,
  t0.nbjoursdelai AS nbjoursdelai_10,
  t0.souscategorie_id AS souscategorie_id_11
FROM
  produit_mannuels t0
WHERE
  t0.souscategorie_id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.code AS code_4, t0.dateajout AS dateajout_5, t0.actif AS actif_6, t0.taillepoids AS taillepoids_7, t0.avantages AS avantages_8, t0.prix AS prix_9, t0.nbjoursdelai AS nbjoursdelai_10, t0.souscategorie_id AS souscategorie_id_11 FROM produit_mannuels t0 WHERE t0.souscategorie_id = 47;

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2
FROM
  annonces t0

SELECT t0.id AS id_1, t0.titre AS titre_2 FROM annonces t0;

SELECT
  t0.nom AS nom_1,
  t0.nom_canonique AS nom_canonique_2,
  t0.code_image AS code_image_3,
  t0.id AS id_4,
  t0.code_couleur_apli AS code_couleur_apli_5,
  t0.active AS active_6,
  t0.immage AS immage_7,
  t0.image_du_sous_menu AS image_du_sous_menu_8,
  t0.logo AS logo_9,
  t0.logo_apli AS logo_apli_10,
  t0.logo_apli_accueil AS logo_apli_accueil_11,
  t0.image_background_apli AS image_background_apli_12
FROM
  categorie t0
WHERE
  t0.nom_canonique = ?
LIMIT
  1

SELECT t0.nom AS nom_1, t0.nom_canonique AS nom_canonique_2, t0.code_image AS code_image_3, t0.id AS id_4, t0.code_couleur_apli AS code_couleur_apli_5, t0.active AS active_6, t0.immage AS immage_7, t0.image_du_sous_menu AS image_du_sous_menu_8, t0.logo AS logo_9, t0.logo_apli AS logo_apli_10, t0.logo_apli_accueil AS logo_apli_accueil_11, t0.image_background_apli AS image_background_apli_12 FROM categorie t0 WHERE t0.nom_canonique = 'equ' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.nom_canonique AS nom_canonique_3,
  t0.code_couleur_apli AS code_couleur_apli_4,
  t0.active AS active_5,
  t0.categorie_id AS categorie_id_6,
  t0.image AS image_7,
  t0.image_accueil AS image_accueil_8,
  t0.logo_apli AS logo_apli_9
FROM
  sous_categorie t0
WHERE
  t0.nom_canonique = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.nom_canonique AS nom_canonique_3, t0.code_couleur_apli AS code_couleur_apli_4, t0.active AS active_5, t0.categorie_id AS categorie_id_6, t0.image AS image_7, t0.image_accueil AS image_accueil_8, t0.logo_apli AS logo_apli_9 FROM sous_categorie t0 WHERE t0.nom_canonique = 'réfrigérateurs&congélateurs' LIMIT 1;

SELECT
  article_idarticle
FROM
  `article_has_sous_categorie`
where
  `sous_categorie_id` = 47

SELECT  article_idarticle FROM `article_has_sous_categorie` where `sous_categorie_id` = 47;

SELECT
  t0.nom AS nom_1,
  t0.nom_canonique AS nom_canonique_2,
  t0.code_image AS code_image_3,
  t0.id AS id_4,
  t0.code_couleur_apli AS code_couleur_apli_5,
  t0.active AS active_6,
  t0.immage AS immage_7,
  t0.image_du_sous_menu AS image_du_sous_menu_8,
  t0.logo AS logo_9,
  t0.logo_apli AS logo_apli_10,
  t0.logo_apli_accueil AS logo_apli_accueil_11,
  t0.image_background_apli AS image_background_apli_12
FROM
  categorie t0
WHERE
  t0.active = ?

SELECT t0.nom AS nom_1, t0.nom_canonique AS nom_canonique_2, t0.code_image AS code_image_3, t0.id AS id_4, t0.code_couleur_apli AS code_couleur_apli_5, t0.active AS active_6, t0.immage AS immage_7, t0.image_du_sous_menu AS image_du_sous_menu_8, t0.logo AS logo_9, t0.logo_apli AS logo_apli_10, t0.logo_apli_accueil AS logo_apli_accueil_11, t0.image_background_apli AS image_background_apli_12 FROM categorie t0 WHERE t0.active = 1;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.nom_canonique AS nom_canonique_3,
  t0.immage AS immage_4
FROM
  etat t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.nom_canonique AS nom_canonique_3, t0.immage AS immage_4 FROM etat t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.code AS code_3,
  t0.description AS description_4,
  t0.position AS position_5,
  t0.slideauto AS slideauto_6,
  t0.pagination AS pagination_7,
  t0.control AS control_8,
  t0.valide AS valide_9,
  t0.intervalle AS intervalle_10,
  t0.height AS height_11,
  t0.bottomcontent AS bottomcontent_12,
  t0.bottomcolor AS bottomcolor_13,
  t0.bottomtext AS bottomtext_14,
  t0.bottombg AS bottombg_15,
  t0.link AS link_16,
  t0.categorie_id AS categorie_id_17,
  t0.souscategorie_id AS souscategorie_id_18
FROM
  hh_caroussels t0
WHERE
  t0.valide = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.code AS code_3, t0.description AS description_4, t0.position AS position_5, t0.slideauto AS slideauto_6, t0.pagination AS pagination_7, t0.control AS control_8, t0.valide AS valide_9, t0.intervalle AS intervalle_10, t0.height AS height_11, t0.bottomcontent AS bottomcontent_12, t0.bottomcolor AS bottomcolor_13, t0.bottomtext AS bottomtext_14, t0.bottombg AS bottombg_15, t0.link AS link_16, t0.categorie_id AS categorie_id_17, t0.souscategorie_id AS souscategorie_id_18 FROM hh_caroussels t0 WHERE t0.valide = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.nom_canonique AS nom_canonique_3,
  t0.logo AS logo_4,
  t0.immage AS immage_5
FROM
  marque t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.nom_canonique AS nom_canonique_3, t0.logo AS logo_4, t0.immage AS immage_5 FROM marque t0 WHERE t0.id = 46;