Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.adresse AS adresse_3,
  t0.cp AS cp_4,
  t0.mail AS mail_5,
  t0.tel AS tel_6,
  t0.ville AS ville_7,
  t0.code AS code_8,
  t0.etat AS etat_9,
  t0.presentationhtml AS presentationhtml_10,
  t0.lienweb AS lienweb_11,
  t0.couleur AS couleur_12,
  t0.guid AS guid_13,
  t0.textfacturepied AS textfacturepied_14,
  t0.messbienvenu AS messbienvenu_15,
  t0.textinscription AS textinscription_16,
  t0.theme_id AS theme_id_17
FROM
  clubs t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.adresse AS adresse_3, t0.cp AS cp_4, t0.mail AS mail_5, t0.tel AS tel_6, t0.ville AS ville_7, t0.code AS code_8, t0.etat AS etat_9, t0.presentationhtml AS presentationhtml_10, t0.lienweb AS lienweb_11, t0.couleur AS couleur_12, t0.guid AS guid_13, t0.textfacturepied AS textfacturepied_14, t0.messbienvenu AS messbienvenu_15, t0.textinscription AS textinscription_16, t0.theme_id AS theme_id_17 FROM clubs t0 WHERE t0.code = '86.0001' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO stats (
  chemin, referer, ip, clinav, datetime,
  page, idvisiteur, club_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO stats (chemin, referer, ip, clinav, datetime, page, idvisiteur, club_id) VALUES ('/86.0001_club/', 'Lien direct', '82.156.88.97', 'Mozilla/5.0 (iPhone; CPU iPhone OS 13_2_3 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.0.3 Mobile/15E148 Safari/604.1', '2026-05-31 00:56:52', 'Accueil', '6a1b6b341cfe6', 1);

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.adresse AS adresse_3,
  t0.cp AS cp_4,
  t0.mail AS mail_5,
  t0.tel AS tel_6,
  t0.ville AS ville_7,
  t0.code AS code_8,
  t0.etat AS etat_9,
  t0.presentationhtml AS presentationhtml_10,
  t0.lienweb AS lienweb_11,
  t0.couleur AS couleur_12,
  t0.guid AS guid_13,
  t0.textfacturepied AS textfacturepied_14,
  t0.messbienvenu AS messbienvenu_15,
  t0.textinscription AS textinscription_16,
  t0.theme_id AS theme_id_17
FROM
  clubs t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.adresse AS adresse_3, t0.cp AS cp_4, t0.mail AS mail_5, t0.tel AS tel_6, t0.ville AS ville_7, t0.code AS code_8, t0.etat AS etat_9, t0.presentationhtml AS presentationhtml_10, t0.lienweb AS lienweb_11, t0.couleur AS couleur_12, t0.guid AS guid_13, t0.textfacturepied AS textfacturepied_14, t0.messbienvenu AS messbienvenu_15, t0.textinscription AS textinscription_16, t0.theme_id AS theme_id_17 FROM clubs t0 WHERE t0.code = '86.0001' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.description AS description_3,
  t0.prix AS prix_4,
  t0.categorie AS categorie_5,
  t0.etat AS etat_6,
  t0.vendeur_type AS vendeur_type_7,
  t0.ville AS ville_8,
  t0.created_at AS created_at_9,
  t0.club_id AS club_id_10,
  t0.adherent_id AS adherent_id_11
FROM
  annonces t0
WHERE
  t0.club_id = ?
  AND t0.etat = ?
  AND t0.vendeur_type = ?
ORDER BY
  t0.created_at DESC
LIMIT
  4

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.prix AS prix_4, t0.categorie AS categorie_5, t0.etat AS etat_6, t0.vendeur_type AS vendeur_type_7, t0.ville AS ville_8, t0.created_at AS created_at_9, t0.club_id AS club_id_10, t0.adherent_id AS adherent_id_11 FROM annonces t0 WHERE t0.club_id = 1 AND t0.etat = 'ACTIVE' AND t0.vendeur_type = 'CLUB' ORDER BY t0.created_at DESC LIMIT 4;

SELECT
  t0.id AS id_1,
  t0.horaires AS horaires_2,
  t0.nbplace AS nbplace_3,
  t0.etat AS etat_4,
  t0.jour AS jour_5,
  t0.heure_debut AS heure_debut_6,
  t0.heure_fin AS heure_fin_7,
  t0.club_id AS club_id_8,
  t0.site_id AS site_id_9,
  t0.sport_id AS sport_id_10,
  t0.entraineur_id AS entraineur_id_11,
  t0.niveau_id AS niveau_id_12
FROM
  cours t0
WHERE
  t0.club_id = ?

SELECT t0.id AS id_1, t0.horaires AS horaires_2, t0.nbplace AS nbplace_3, t0.etat AS etat_4, t0.jour AS jour_5, t0.heure_debut AS heure_debut_6, t0.heure_fin AS heure_fin_7, t0.club_id AS club_id_8, t0.site_id AS site_id_9, t0.sport_id AS sport_id_10, t0.entraineur_id AS entraineur_id_11, t0.niveau_id AS niveau_id_12 FROM cours t0 WHERE t0.club_id = 1;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.description AS description_3,
  t0.logo AS logo_4,
  t0.fiche_pratique AS fiche_pratique_5
FROM
  sports t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.logo AS logo_4, t0.fiche_pratique AS fiche_pratique_5 FROM sports t0 WHERE t0.id = 7;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.description AS description_3,
  t0.logo AS logo_4,
  t0.fiche_pratique AS fiche_pratique_5
FROM
  sports t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.logo AS logo_4, t0.fiche_pratique AS fiche_pratique_5 FROM sports t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.description AS description_3,
  t0.logo AS logo_4,
  t0.fiche_pratique AS fiche_pratique_5
FROM
  sports t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.logo AS logo_4, t0.fiche_pratique AS fiche_pratique_5 FROM sports t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.description AS description_3,
  t0.logo AS logo_4,
  t0.fiche_pratique AS fiche_pratique_5
FROM
  sports t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.logo AS logo_4, t0.fiche_pratique AS fiche_pratique_5 FROM sports t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.description AS description_3,
  t0.logo AS logo_4,
  t0.fiche_pratique AS fiche_pratique_5
FROM
  sports t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.logo AS logo_4, t0.fiche_pratique AS fiche_pratique_5 FROM sports t0 WHERE t0.id = 6;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.adresse AS adresse_3,
  t0.cp AS cp_4,
  t0.ville AS ville_5,
  t0.etat AS etat_6,
  t0.club_id AS club_id_7
FROM
  sites t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.adresse AS adresse_3, t0.cp AS cp_4, t0.ville AS ville_5, t0.etat AS etat_6, t0.club_id AS club_id_7 FROM sites t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.montant AS montant_2,
  t0.description AS description_3,
  t0.dtpublication AS dtpublication_4,
  t0.nom AS nom_5,
  t0.dtdebut AS dtdebut_6,
  t0.dtfin AS dtfin_7,
  t0.etat AS etat_8,
  t0.club_id AS club_id_9
FROM
  forfaits t0
WHERE
  t0.club_id = ?

SELECT t0.id AS id_1, t0.montant AS montant_2, t0.description AS description_3, t0.dtpublication AS dtpublication_4, t0.nom AS nom_5, t0.dtdebut AS dtdebut_6, t0.dtfin AS dtfin_7, t0.etat AS etat_8, t0.club_id AS club_id_9 FROM forfaits t0 WHERE t0.club_id = 1;

SELECT
  t0.id AS id_1,
  t0.horaires AS horaires_2,
  t0.nbplace AS nbplace_3,
  t0.etat AS etat_4,
  t0.jour AS jour_5,
  t0.heure_debut AS heure_debut_6,
  t0.heure_fin AS heure_fin_7,
  t0.club_id AS club_id_8,
  t0.site_id AS site_id_9,
  t0.sport_id AS sport_id_10,
  t0.entraineur_id AS entraineur_id_11,
  t0.niveau_id AS niveau_id_12
FROM
  cours t0
  INNER JOIN forfaits_cours ON t0.id = forfaits_cours.cours_id
WHERE
  forfaits_cours.forfaits_id = ?

SELECT t0.id AS id_1, t0.horaires AS horaires_2, t0.nbplace AS nbplace_3, t0.etat AS etat_4, t0.jour AS jour_5, t0.heure_debut AS heure_debut_6, t0.heure_fin AS heure_fin_7, t0.club_id AS club_id_8, t0.site_id AS site_id_9, t0.sport_id AS sport_id_10, t0.entraineur_id AS entraineur_id_11, t0.niveau_id AS niveau_id_12 FROM cours t0 INNER JOIN forfaits_cours ON t0.id = forfaits_cours.cours_id WHERE forfaits_cours.forfaits_id = 1;

SELECT
  t0.id AS id_1,
  t0.horaires AS horaires_2,
  t0.nbplace AS nbplace_3,
  t0.etat AS etat_4,
  t0.jour AS jour_5,
  t0.heure_debut AS heure_debut_6,
  t0.heure_fin AS heure_fin_7,
  t0.club_id AS club_id_8,
  t0.site_id AS site_id_9,
  t0.sport_id AS sport_id_10,
  t0.entraineur_id AS entraineur_id_11,
  t0.niveau_id AS niveau_id_12
FROM
  cours t0
  INNER JOIN forfaits_cours ON t0.id = forfaits_cours.cours_id
WHERE
  forfaits_cours.forfaits_id = ?

SELECT t0.id AS id_1, t0.horaires AS horaires_2, t0.nbplace AS nbplace_3, t0.etat AS etat_4, t0.jour AS jour_5, t0.heure_debut AS heure_debut_6, t0.heure_fin AS heure_fin_7, t0.club_id AS club_id_8, t0.site_id AS site_id_9, t0.sport_id AS sport_id_10, t0.entraineur_id AS entraineur_id_11, t0.niveau_id AS niveau_id_12 FROM cours t0 INNER JOIN forfaits_cours ON t0.id = forfaits_cours.cours_id WHERE forfaits_cours.forfaits_id = 3;

SELECT
  t0.id AS id_1,
  t0.dtcreate AS dtcreate_2,
  t0.titre AS titre_3,
  t0.accroche AS accroche_4,
  t0.contenu AS contenu_5,
  t0.niveau AS niveau_6,
  t0.code AS code_7,
  t0.type AS type_8,
  t0.auteur_id AS auteur_id_9,
  t0.clubliaison_id AS clubliaison_id_10,
  t0.sport_id AS sport_id_11,
  t0.contact_id AS contact_id_12
FROM
  blogs t0
WHERE
  t0.clubliaison_id = ?

SELECT t0.id AS id_1, t0.dtcreate AS dtcreate_2, t0.titre AS titre_3, t0.accroche AS accroche_4, t0.contenu AS contenu_5, t0.niveau AS niveau_6, t0.code AS code_7, t0.type AS type_8, t0.auteur_id AS auteur_id_9, t0.clubliaison_id AS clubliaison_id_10, t0.sport_id AS sport_id_11, t0.contact_id AS contact_id_12 FROM blogs t0 WHERE t0.clubliaison_id = 1;