10 => SELECT id_fichier, type_fichier, source_fichier, taille_fichier, duree_fichier FROM fichier WHERE id_article = :id_article AND active = 1

---

4 => SELECT * FROM page_module WHERE id_page_bloc = :id_page_bloc AND active =1 ORDER BY ordre ASC

---

1 => SELECT a.*, b.pays_id FROM torahboxbeta.ville a LEFT JOIN torahboxbeta.pays b ON b.pays_iso2 = a.pays_iso_ville WHERE a.id_ville = :id_ville LIMIT 1

---

1 => SELECT id_dedicace as id, description_dedicace as texte FROM dedicace WHERE id_table = :id_table AND active = 1 AND ((date_debut = :date AND date_fin = '0000-00-00') OR (:date BETWEEN date_debut AND date_fin)) LIMIT 1

---

1 => SELECT date_categorie, description_categorie FROM categorie WHERE id_categorie = :id_categorie LIMIT 1

---

1 => SELECT * FROM page WHERE id_page = :value LIMIT 1

---

1 => SELECT * FROM page_bloc WHERE id_page = :id_page AND active = 1 ORDER BY ordre ASC

---

1 => SELECT a.*, 0 as count_quizz, m.alias_media, CONCAT(b.titre_auteur,b.prenom_auteur,' ',b.nom_auteur) as nom_auteur, b.titre_auteur, b.prenom_auteur, b.nom_auteur as nom_auteur2, b.nom_en_auteur, b.id_auteur, b.publicite_auteur, b.sexe_auteur, b.langue_auteur, (SELECT id_categorie FROM torahbox.categorie_content WHERE id_content = a.id_article AND id_table = 'article' AND default_categorie = 1) as id_categorie_default FROM torahbox.article a LEFT JOIN auteur b ON b.id_auteur = a.id_auteur LEFT JOIN media m ON m.id_media = a.id_media WHERE a.site_article IN (0,1,2) AND a.time_pub != '0000-00-00 00:00:00' AND a.time_pub <= '2026-08-03 16:08:46' AND a.active = 1 AND a.langue_article = 'FR' AND (SELECT COUNT(id_categorie) FROM categorie_content WHERE id_content = a.id_article AND id_table = 'article' AND id_categorie = '210' LIMIT 1) = 1 AND a.type_article IN ('audio_video','video','youtube') AND (SELECT COUNT(id_categorie) FROM categorie_content WHERE id_content = a.id_article AND id_table = 'article' AND id_categorie = '198' LIMIT 1) = 1 HAVING id_categorie_default > 0 ORDER BY a.time_pub DESC, a.id_article DESC LIMIT 0,10

---

1 => SHOW FULL COLUMNS FROM categorie_content

---

1 => SHOW FULL COLUMNS FROM qr_question

---

1 => SHOW FULL COLUMNS FROM tb.membre

---

1 => SHOW FULL COLUMNS FROM qr_reponse

---

1 => SHOW FULL COLUMNS FROM auteur

---

1 => SELECT SQL_CALC_FOUND_ROWS a.*, d.texte_reponse, b.prenom, b.nom, e.id_auteur, (SELECT id_categorie FROM categorie_content WHERE id_table = 'qr_question' AND id_content = a.id_question ORDER BY default_categorie DESC LIMIT 1) as id_categorie, e.titre_auteur, e.prenom_auteur, e.nom_auteur as nom_auteur2, IF(a.pinned>0 AND DATE_ADD(a.time_pinned,INTERVAL a.pinned DAY) >= CURRENT_DATE,1,0) as ranking, CONCAT(e.titre_auteur,e.prenom_auteur,' ',e.nom_auteur) as nom_auteur FROM categorie_content c LEFT JOIN qr_question a ON a.id_question = c.id_content LEFT JOIN tb.membre b ON b.id = a.id_membre LEFT JOIN qr_reponse d ON d.id_reponse = a.id_reponse LEFT JOIN auteur e ON e.id_auteur = d.id_auteur WHERE a.statut = 5 AND a.active = 1 AND a.time_pub <= '2026-08-03 16:08:46' AND c.id_categorie = 198 AND c.id_table = 'qr_question' ORDER BY ranking DESC, a.time_pub DESC LIMIT 0,10

---

1 => SELECT FOUND_ROWS() AS total

---

1 => SELECT a.*, 0 as count_quizz, m.alias_media, CONCAT(b.titre_auteur,b.prenom_auteur,' ',b.nom_auteur) as nom_auteur, b.titre_auteur, b.prenom_auteur, b.nom_auteur as nom_auteur2, b.nom_en_auteur, b.id_auteur, b.publicite_auteur, b.sexe_auteur, b.langue_auteur, (SELECT id_categorie FROM torahbox.categorie_content WHERE id_content = a.id_article AND id_table = 'article' AND default_categorie = 1) as id_categorie_default FROM torahbox.article a LEFT JOIN auteur b ON b.id_auteur = a.id_auteur LEFT JOIN media m ON m.id_media = a.id_media WHERE a.site_article IN (0,1) AND a.time_pub != '0000-00-00 00:00:00' AND a.time_pub <= '2026-08-03 16:08:46' AND a.active = 1 AND a.langue_article = 'FR' AND (SELECT COUNT(id_categorie) FROM categorie_content WHERE id_content = a.id_article AND id_table = 'article' AND id_categorie = '198' LIMIT 1) = 1 AND a.type_article IN ('article','youtube') HAVING id_categorie_default > 0 ORDER BY a.time_pub DESC, a.id_article DESC LIMIT 0,12

---

1 => SELECT * FROM youtube WHERE id_youtube = :id LIMIT 1

---