Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.resume AS resume_3,
  t0.article AS article_4,
  t0.photo AS photo_5,
  t0.legende AS legende_6,
  t0.linkto AS linkto_7,
  t0.libellefile1 AS libellefile1_8,
  t0.urlfile1 AS urlfile1_9,
  t0.libellefile2 AS libellefile2_10,
  t0.urlfile2 AS urlfile2_11,
  t0.keywords AS keywords_12,
  t0.filename AS filename_13,
  t0.slug AS slug_14,
  t0.type AS type_15,
  t0.count AS count_16,
  t0.vignette AS vignette_17,
  t0.archived AS archived_18,
  t0.emailcontact AS emailcontact_19,
  t0.date AS date_20,
  t0.mise_en_avant AS mise_en_avant_21,
  t0.enabled AS enabled_22,
  t0.blocked AS blocked_23,
  t0.external_link AS external_link_24,
  t0.programmation_date AS programmation_date_25,
  t0.use_youtube_thumb AS use_youtube_thumb_26,
  t0.is_only_for_subscriber AS is_only_for_subscriber_27,
  t0.created_at AS created_at_28,
  t0.updated_at AS updated_at_29,
  t0.category_id AS category_id_30
FROM
  article t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.resume AS resume_3, t0.article AS article_4, t0.photo AS photo_5, t0.legende AS legende_6, t0.linkto AS linkto_7, t0.libellefile1 AS libellefile1_8, t0.urlfile1 AS urlfile1_9, t0.libellefile2 AS libellefile2_10, t0.urlfile2 AS urlfile2_11, t0.keywords AS keywords_12, t0.filename AS filename_13, t0.slug AS slug_14, t0.type AS type_15, t0.count AS count_16, t0.vignette AS vignette_17, t0.archived AS archived_18, t0.emailcontact AS emailcontact_19, t0.date AS date_20, t0.mise_en_avant AS mise_en_avant_21, t0.enabled AS enabled_22, t0.blocked AS blocked_23, t0.external_link AS external_link_24, t0.programmation_date AS programmation_date_25, t0.use_youtube_thumb AS use_youtube_thumb_26, t0.is_only_for_subscriber AS is_only_for_subscriber_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.category_id AS category_id_30 FROM article t0 WHERE t0.slug = 'demande-daide-a-la-restructuration-du-vignoble' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  article
SET
  count = ?
WHERE
  id = ?

UPDATE article SET count = 3910 WHERE id = 2376;

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.value AS value_3
FROM
  setting t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM setting t0 WHERE t0.slug = 'theme' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.value AS value_3
FROM
  setting t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM setting t0 WHERE t0.slug = 'theme' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.value AS value_3
FROM
  setting t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM setting t0 WHERE t0.slug = 'theme' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.value AS value_3
FROM
  setting t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM setting t0 WHERE t0.slug = 'theme' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.text AS text_2,
  t0.link AS link_3,
  t0.image AS image_4,
  t0.resume AS resume_5,
  t0.texte_complet AS texte_complet_6,
  t0.colonne AS colonne_7,
  t0.position AS position_8,
  t0.type AS type_9,
  t0.link_type AS link_type_10,
  t0.display_title AS display_title_11,
  t0.is_only_for_subscriber AS is_only_for_subscriber_12,
  t0.is_only_for_admin AS is_only_for_admin_13,
  t0.parent_id AS parent_id_14,
  t15.id AS id_16,
  t15.text AS text_17,
  t15.link AS link_18,
  t15.image AS image_19,
  t15.resume AS resume_20,
  t15.texte_complet AS texte_complet_21,
  t15.colonne AS colonne_22,
  t15.position AS position_23,
  t15.type AS type_24,
  t15.link_type AS link_type_25,
  t15.display_title AS display_title_26,
  t15.is_only_for_subscriber AS is_only_for_subscriber_27,
  t15.is_only_for_admin AS is_only_for_admin_28,
  t15.parent_id AS parent_id_29
FROM
  menu t0
  LEFT JOIN menu t15 ON t0.parent_id = t15.id
WHERE
  t0.link = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.text AS text_2, t0.link AS link_3, t0.image AS image_4, t0.resume AS resume_5, t0.texte_complet AS texte_complet_6, t0.colonne AS colonne_7, t0.position AS position_8, t0.type AS type_9, t0.link_type AS link_type_10, t0.display_title AS display_title_11, t0.is_only_for_subscriber AS is_only_for_subscriber_12, t0.is_only_for_admin AS is_only_for_admin_13, t0.parent_id AS parent_id_14, t15.id AS id_16, t15.text AS text_17, t15.link AS link_18, t15.image AS image_19, t15.resume AS resume_20, t15.texte_complet AS texte_complet_21, t15.colonne AS colonne_22, t15.position AS position_23, t15.type AS type_24, t15.link_type AS link_type_25, t15.display_title AS display_title_26, t15.is_only_for_subscriber AS is_only_for_subscriber_27, t15.is_only_for_admin AS is_only_for_admin_28, t15.parent_id AS parent_id_29 FROM menu t0 LEFT JOIN menu t15 ON t0.parent_id = t15.id WHERE t0.link = '/article/demande-daide-a-la-restructuration-du-vignoble' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.value AS value_3
FROM
  setting t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM setting t0 WHERE t0.slug = 'facebook' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.value AS value_3
FROM
  setting t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM setting t0 WHERE t0.slug = 'facebook' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.value AS value_3
FROM
  setting t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM setting t0 WHERE t0.slug = 'twitter' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.value AS value_3
FROM
  setting t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM setting t0 WHERE t0.slug = 'linkedin' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.value AS value_3
FROM
  setting t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM setting t0 WHERE t0.slug = 'linkedin' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.value AS value_3
FROM
  setting t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM setting t0 WHERE t0.slug = 'instagram' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.value AS value_3
FROM
  setting t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM setting t0 WHERE t0.slug = 'instagram' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.value AS value_3
FROM
  setting t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM setting t0 WHERE t0.slug = 'mailto' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.value AS value_3
FROM
  setting t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM setting t0 WHERE t0.slug = 'mailto' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.value AS value_3
FROM
  setting t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM setting t0 WHERE t0.slug = 'youtube' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.value AS value_3
FROM
  setting t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM setting t0 WHERE t0.slug = 'youtube' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.value AS value_3
FROM
  setting t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM setting t0 WHERE t0.slug = 'espace_pro' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.text AS text_2,
  t0.link AS link_3,
  t0.image AS image_4,
  t0.resume AS resume_5,
  t0.texte_complet AS texte_complet_6,
  t0.colonne AS colonne_7,
  t0.position AS position_8,
  t0.type AS type_9,
  t0.link_type AS link_type_10,
  t0.display_title AS display_title_11,
  t0.is_only_for_subscriber AS is_only_for_subscriber_12,
  t0.is_only_for_admin AS is_only_for_admin_13,
  t0.parent_id AS parent_id_14,
  t15.id AS id_16,
  t15.text AS text_17,
  t15.link AS link_18,
  t15.image AS image_19,
  t15.resume AS resume_20,
  t15.texte_complet AS texte_complet_21,
  t15.colonne AS colonne_22,
  t15.position AS position_23,
  t15.type AS type_24,
  t15.link_type AS link_type_25,
  t15.display_title AS display_title_26,
  t15.is_only_for_subscriber AS is_only_for_subscriber_27,
  t15.is_only_for_admin AS is_only_for_admin_28,
  t15.parent_id AS parent_id_29
FROM
  menu t0
  LEFT JOIN menu t15 ON t0.parent_id = t15.id
WHERE
  t0.link = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.text AS text_2, t0.link AS link_3, t0.image AS image_4, t0.resume AS resume_5, t0.texte_complet AS texte_complet_6, t0.colonne AS colonne_7, t0.position AS position_8, t0.type AS type_9, t0.link_type AS link_type_10, t0.display_title AS display_title_11, t0.is_only_for_subscriber AS is_only_for_subscriber_12, t0.is_only_for_admin AS is_only_for_admin_13, t0.parent_id AS parent_id_14, t15.id AS id_16, t15.text AS text_17, t15.link AS link_18, t15.image AS image_19, t15.resume AS resume_20, t15.texte_complet AS texte_complet_21, t15.colonne AS colonne_22, t15.position AS position_23, t15.type AS type_24, t15.link_type AS link_type_25, t15.display_title AS display_title_26, t15.is_only_for_subscriber AS is_only_for_subscriber_27, t15.is_only_for_admin AS is_only_for_admin_28, t15.parent_id AS parent_id_29 FROM menu t0 LEFT JOIN menu t15 ON t0.parent_id = t15.id WHERE t0.link = '/article/demande-daide-a-la-restructuration-du-vignoble' LIMIT 1;

SELECT
  m0_.id AS id_0,
  m0_.text AS text_1,
  m0_.link AS link_2,
  m0_.image AS image_3,
  m0_.resume AS resume_4,
  m0_.texte_complet AS texte_complet_5,
  m0_.colonne AS colonne_6,
  m0_.position AS position_7,
  m0_.type AS type_8,
  m0_.link_type AS link_type_9,
  m0_.display_title AS display_title_10,
  m0_.is_only_for_subscriber AS is_only_for_subscriber_11,
  m0_.is_only_for_admin AS is_only_for_admin_12,
  m1_.id AS id_13,
  m1_.text AS text_14,
  m1_.link AS link_15,
  m1_.image AS image_16,
  m1_.resume AS resume_17,
  m1_.texte_complet AS texte_complet_18,
  m1_.colonne AS colonne_19,
  m1_.position AS position_20,
  m1_.type AS type_21,
  m1_.link_type AS link_type_22,
  m1_.display_title AS display_title_23,
  m1_.is_only_for_subscriber AS is_only_for_subscriber_24,
  m1_.is_only_for_admin AS is_only_for_admin_25,
  m2_.id AS id_26,
  m2_.text AS text_27,
  m2_.link AS link_28,
  m2_.image AS image_29,
  m2_.resume AS resume_30,
  m2_.texte_complet AS texte_complet_31,
  m2_.colonne AS colonne_32,
  m2_.position AS position_33,
  m2_.type AS type_34,
  m2_.link_type AS link_type_35,
  m2_.display_title AS display_title_36,
  m2_.is_only_for_subscriber AS is_only_for_subscriber_37,
  m2_.is_only_for_admin AS is_only_for_admin_38,
  m0_.parent_id AS parent_id_39,
  m1_.parent_id AS parent_id_40,
  m2_.parent_id AS parent_id_41
FROM
  menu m0_
  LEFT JOIN menu m1_ ON m0_.id = m1_.parent_id
  LEFT JOIN menu m2_ ON m1_.id = m2_.parent_id
WHERE
  m0_.parent_id IS NULL
ORDER BY
  m0_.position ASC,
  m0_.text ASC,
  m1_.colonne ASC,
  m1_.position ASC,
  m2_.colonne ASC,
  m2_.position ASC

SELECT m0_.id AS id_0, m0_.text AS text_1, m0_.link AS link_2, m0_.image AS image_3, m0_.resume AS resume_4, m0_.texte_complet AS texte_complet_5, m0_.colonne AS colonne_6, m0_.position AS position_7, m0_.type AS type_8, m0_.link_type AS link_type_9, m0_.display_title AS display_title_10, m0_.is_only_for_subscriber AS is_only_for_subscriber_11, m0_.is_only_for_admin AS is_only_for_admin_12, m1_.id AS id_13, m1_.text AS text_14, m1_.link AS link_15, m1_.image AS image_16, m1_.resume AS resume_17, m1_.texte_complet AS texte_complet_18, m1_.colonne AS colonne_19, m1_.position AS position_20, m1_.type AS type_21, m1_.link_type AS link_type_22, m1_.display_title AS display_title_23, m1_.is_only_for_subscriber AS is_only_for_subscriber_24, m1_.is_only_for_admin AS is_only_for_admin_25, m2_.id AS id_26, m2_.text AS text_27, m2_.link AS link_28, m2_.image AS image_29, m2_.resume AS resume_30, m2_.texte_complet AS texte_complet_31, m2_.colonne AS colonne_32, m2_.position AS position_33, m2_.type AS type_34, m2_.link_type AS link_type_35, m2_.display_title AS display_title_36, m2_.is_only_for_subscriber AS is_only_for_subscriber_37, m2_.is_only_for_admin AS is_only_for_admin_38, m0_.parent_id AS parent_id_39, m1_.parent_id AS parent_id_40, m2_.parent_id AS parent_id_41 FROM menu m0_ LEFT JOIN menu m1_ ON m0_.id = m1_.parent_id LEFT JOIN menu m2_ ON m1_.id = m2_.parent_id WHERE m0_.parent_id IS NULL ORDER BY m0_.position ASC, m0_.text ASC, m1_.colonne ASC, m1_.position ASC, m2_.colonne ASC, m2_.position ASC;

SELECT
  t0.id AS id_1,
  t0.text AS text_2,
  t0.link AS link_3,
  t0.image AS image_4,
  t0.resume AS resume_5,
  t0.texte_complet AS texte_complet_6,
  t0.colonne AS colonne_7,
  t0.position AS position_8,
  t0.type AS type_9,
  t0.link_type AS link_type_10,
  t0.display_title AS display_title_11,
  t0.is_only_for_subscriber AS is_only_for_subscriber_12,
  t0.is_only_for_admin AS is_only_for_admin_13,
  t0.parent_id AS parent_id_14,
  t15.id AS id_16,
  t15.text AS text_17,
  t15.link AS link_18,
  t15.image AS image_19,
  t15.resume AS resume_20,
  t15.texte_complet AS texte_complet_21,
  t15.colonne AS colonne_22,
  t15.position AS position_23,
  t15.type AS type_24,
  t15.link_type AS link_type_25,
  t15.display_title AS display_title_26,
  t15.is_only_for_subscriber AS is_only_for_subscriber_27,
  t15.is_only_for_admin AS is_only_for_admin_28,
  t15.parent_id AS parent_id_29
FROM
  menu t0
  LEFT JOIN menu t15 ON t0.parent_id = t15.id
WHERE
  t0.parent_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )
ORDER BY
  t0.colonne ASC,
  t0.position ASC

SELECT t0.id AS id_1, t0.text AS text_2, t0.link AS link_3, t0.image AS image_4, t0.resume AS resume_5, t0.texte_complet AS texte_complet_6, t0.colonne AS colonne_7, t0.position AS position_8, t0.type AS type_9, t0.link_type AS link_type_10, t0.display_title AS display_title_11, t0.is_only_for_subscriber AS is_only_for_subscriber_12, t0.is_only_for_admin AS is_only_for_admin_13, t0.parent_id AS parent_id_14, t15.id AS id_16, t15.text AS text_17, t15.link AS link_18, t15.image AS image_19, t15.resume AS resume_20, t15.texte_complet AS texte_complet_21, t15.colonne AS colonne_22, t15.position AS position_23, t15.type AS type_24, t15.link_type AS link_type_25, t15.display_title AS display_title_26, t15.is_only_for_subscriber AS is_only_for_subscriber_27, t15.is_only_for_admin AS is_only_for_admin_28, t15.parent_id AS parent_id_29 FROM menu t0 LEFT JOIN menu t15 ON t0.parent_id = t15.id WHERE t0.parent_id IN (91, 124, 125, 81, 82, 83, 84, 85, 86, 87, 126, 88, 89, 92, 110, 49, 94, 106, 95, 113, 96, 97, 98, 99, 105, 104, 114, 100, 101, 102, 103, 115, 116, 117, 118, 119, 108, 109, 121, 122, 123, 41, 42, 43, 44, 45, 62, 63, 64, 76) ORDER BY t0.colonne ASC, t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.slug AS slug_3,
  t0.type_affichage AS type_affichage_4,
  t0.photo_entete_path AS photo_entete_path_5,
  t0.titre_entete AS titre_entete_6,
  t0.sous_titre_entete AS sous_titre_entete_7,
  t0.position AS position_8,
  t0.is_only_for_subscriber AS is_only_for_subscriber_9,
  t0.parent_id AS parent_id_10
FROM
  category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.slug AS slug_3, t0.type_affichage AS type_affichage_4, t0.photo_entete_path AS photo_entete_path_5, t0.titre_entete AS titre_entete_6, t0.sous_titre_entete AS sous_titre_entete_7, t0.position AS position_8, t0.is_only_for_subscriber AS is_only_for_subscriber_9, t0.parent_id AS parent_id_10 FROM category t0 WHERE t0.id = 1530;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.slug AS slug_3,
  t0.type_affichage AS type_affichage_4,
  t0.photo_entete_path AS photo_entete_path_5,
  t0.titre_entete AS titre_entete_6,
  t0.sous_titre_entete AS sous_titre_entete_7,
  t0.position AS position_8,
  t0.is_only_for_subscriber AS is_only_for_subscriber_9,
  t0.parent_id AS parent_id_10
FROM
  category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.slug AS slug_3, t0.type_affichage AS type_affichage_4, t0.photo_entete_path AS photo_entete_path_5, t0.titre_entete AS titre_entete_6, t0.sous_titre_entete AS sous_titre_entete_7, t0.position AS position_8, t0.is_only_for_subscriber AS is_only_for_subscriber_9, t0.parent_id AS parent_id_10 FROM category t0 WHERE t0.id = 1528;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.slug AS slug_3,
  t0.type_affichage AS type_affichage_4,
  t0.photo_entete_path AS photo_entete_path_5,
  t0.titre_entete AS titre_entete_6,
  t0.sous_titre_entete AS sous_titre_entete_7,
  t0.position AS position_8,
  t0.is_only_for_subscriber AS is_only_for_subscriber_9,
  t0.parent_id AS parent_id_10
FROM
  category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.slug AS slug_3, t0.type_affichage AS type_affichage_4, t0.photo_entete_path AS photo_entete_path_5, t0.titre_entete AS titre_entete_6, t0.sous_titre_entete AS sous_titre_entete_7, t0.position AS position_8, t0.is_only_for_subscriber AS is_only_for_subscriber_9, t0.parent_id AS parent_id_10 FROM category t0 WHERE t0.id = 5;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.file_path AS file_path_3,
  t0.article_id AS article_id_4
FROM
  article_document t0
WHERE
  t0.article_id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.file_path AS file_path_3, t0.article_id AS article_id_4 FROM article_document t0 WHERE t0.article_id = 2376;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3
FROM
  contact t0
  INNER JOIN contact_article ON t0.id = contact_article.contact_id
WHERE
  contact_article.article_id = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM contact t0 INNER JOIN contact_article ON t0.id = contact_article.contact_id WHERE contact_article.article_id = 2376 ORDER BY t0.name ASC;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.value AS value_3
FROM
  setting t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM setting t0 WHERE t0.slug = 'theme' LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.created_at AS created_at_1,
  p0_.date_deb AS date_deb_2,
  p0_.date_fin AS date_fin_3,
  p0_.url AS url_4,
  p0_.urlimg AS urlimg_5,
  p0_.position AS position_6,
  p0_.typedepage AS typedepage_7,
  p0_.ordre AS ordre_8,
  p0_.nbrevue AS nbrevue_9,
  p0_.nbreclic AS nbreclic_10,
  p0_.titre AS titre_11
FROM
  publicite p0_
WHERE
  p0_.date_deb < ?
  AND p0_.date_fin > ?
  AND p0_.position = ?
ORDER BY
  RAND() ASC
LIMIT
  1

SELECT p0_.id AS id_0, p0_.created_at AS created_at_1, p0_.date_deb AS date_deb_2, p0_.date_fin AS date_fin_3, p0_.url AS url_4, p0_.urlimg AS urlimg_5, p0_.position AS position_6, p0_.typedepage AS typedepage_7, p0_.ordre AS ordre_8, p0_.nbrevue AS nbrevue_9, p0_.nbreclic AS nbreclic_10, p0_.titre AS titre_11 FROM publicite p0_ WHERE p0_.date_deb < '2025-10-18 23:52:19' AND p0_.date_fin > '2025-10-18 23:52:19' AND p0_.position = 0 ORDER BY RAND() ASC LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  publicite
SET
  nbrevue = ?
WHERE
  id = ?

UPDATE publicite SET nbrevue = 203741 WHERE id = 44;

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.slug AS slug_3,
  t0.content AS content_4,
  t0.type AS type_5,
  t0.date_created AS date_created_6,
  t0.date_updated AS date_updated_7
FROM
  block_cms t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.label AS label_2, t0.slug AS slug_3, t0.content AS content_4, t0.type AS type_5, t0.date_created AS date_created_6, t0.date_updated AS date_updated_7 FROM block_cms t0 WHERE t0.slug = 'bloc-menu-droit-le-vigneron' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.value AS value_3
FROM
  setting t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.value AS value_3 FROM setting t0 WHERE t0.slug = 'theme' LIMIT 1;

SELECT
  a0_.id AS id_0,
  a0_.categorie AS categorie_1,
  a0_.nom AS nom_2,
  a0_.prenom AS prenom_3,
  a0_.telephone AS telephone_4,
  a0_.adresse AS adresse_5,
  a0_.code_postal AS code_postal_6,
  a0_.ville AS ville_7,
  a0_.email AS email_8,
  a0_.annonce AS annonce_9,
  a0_.photo_path AS photo_path_10,
  a0_.date_debut AS date_debut_11,
  a0_.date_fin AS date_fin_12,
  a0_.display_email AS display_email_13,
  a0_.display_telephone AS display_telephone_14,
  a0_.is_paid AS is_paid_15,
  a0_.enabled AS enabled_16,
  a0_.created_at AS created_at_17,
  a0_.updated_at AS updated_at_18,
  COUNT(DISTINCT a0_.id) AS sclr_19,
  a0_.annonce_category_id AS annonce_category_id_20
FROM
  annonce a0_
WHERE
  a0_.date_debut <= ?
  AND a0_.date_fin >= ?
  AND a0_.enabled = 1
  AND a0_.is_paid = 1
ORDER BY
  a0_.date_debut DESC,
  a0_.id DESC