04-08-2026 06:24 |
0.4271s | 3.54Mo | PAGE 42 | VILLE 197799 |
MYSQL:24 |
URL:04 => SELECT * FROM youtube WHERE id_youtube = :id LIMIT 1
3 => SELECT id_categorie as id, id_categorie as value
FROM torahbox.categorie_content WHERE id_content = :id_content AND id_table = :id_table
2 => SELECT typecampagne_id as id_campagne, typecampagne_titre as nom_campagne FROM torahboxbeta.typecampagne WHERE typecampagne_id = :id LIMIT 1
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 => SHOW FULL COLUMNS FROM torahbox_stats.content
1 => INSERT INTO torahbox_stats.content (`id_content`, `id_table`, `id_membre`, `ip`, `uuid`) VALUES (:id_content, :id_table, :id_membre, :ip, :uuid)
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.id_article = '37125'
ORDER BY a.time_pub DESC, a.id_article DESC
LIMIT 0,8
1 => SELECT a.id_article, a.titre_article, a.alias_article
FROM article a
LEFT JOIN categorie_content b ON (b.id_content = a.id_article AND b.id_table = 'article')
WHERE DATE(a.time_pub) != '0000-00-00' AND a.id_article != :id_article AND b.id_categorie = :id_categorie AND b.default_categorie = '1' AND a.time_pub BETWEEN :time_pub AND '2026-08-04 06:24:15' AND a.active = '1'
ORDER BY a.time_pub ASC LIMIT 1
1 => SELECT a.id_article, a.titre_article, a.alias_article
FROM article a
LEFT JOIN categorie_content b ON (b.id_content = a.id_article AND b.id_table = 'article')
WHERE DATE(a.time_pub) != '0000-00-00' AND a.id_article != :id_article AND b.id_categorie = :id_categorie AND b.default_categorie = '1' AND a.time_pub < :time_pub AND a.active = '1'
ORDER BY a.time_pub DESC LIMIT 1
1 => SELECT id_article_groupe FROM article_groupe_content WHERE id_article = :id_article LIMIT 1
1 => SELECT a.id_categorie_content, b.id_parent, b.id_page, b.id_categorie, b.nom_categorie, a.default_categorie
FROM torahbox.categorie_content a
LEFT JOIN torahbox.categorie b ON b.id_categorie = a.id_categorie
WHERE (a.id_content = :id_content AND a.id_table = :id_table)
ORDER BY a.default_categorie DESC
1 => SELECT a.id_content
FROM categorie_content a
LEFT JOIN torahboxbeta.campagne19_livres b ON b.campagne19_livres_id = a.id_content
WHERE a.id_table = 'campagne19_livres' AND b.campagne19_livres_type = 1 AND a.id_categorie IN (196,250) AND b.campagne19_livres_status = 1
ORDER BY rand() LIMIT 1
1 => SELECT a.campagne19_livres_id
FROM torahboxbeta.campagne19_livres a
WHERE a.campagne19_livres_status = 1 AND a.campagne19_livres_type = 1
ORDER BY rand() LIMIT 1
1 => SELECT * FROM torahboxbeta.campagne19_livres WHERE campagne19_livres_id = 307 AND campagne19_livres_status IN (-1,0,1) LIMIT 1
1 => SELECT id_dedicace as id, description_dedicace as texte
FROM dedicace
WHERE id_table = :id_table AND active = 1 AND id_content = :id_content LIMIT 1
1 => SELECT id_tag as id, id_tag as value FROM tag_content WHERE id_content = :id_content AND id_table = :id_table
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-04 06:24:15' 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 = '196'
LIMIT 1) = 1 AND a.id_article != '37125'
HAVING id_categorie_default > 0
ORDER BY a.time_pub DESC, a.id_article DESC
LIMIT 0,5
