03-08-2026 23:07 |
1.7957s | 3.59Mo | PAGE 5 | VILLE 197799 | LIGHT |
MYSQL:25 |
URL:16 => SELECT * FROM youtube WHERE id_youtube = :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 => SELECT COUNT(*) FROM search_log WHERE DATE(time) = CURRENT_DATE AND ip = :ip LIMIT 1
1 => SHOW FULL COLUMNS FROM search_log
1 => INSERT INTO search_log (`query`, `referer`, `ip`) VALUES (:query, :referer, :ip)
1 => SELECT id_tag, nom_tag, description_tag, search_tag
FROM tag
WHERE (nom_tag LIKE :nom OR soundex_tag = :soundex OR variante_tag LIKE CONCAT('%',:nom,'%'))
ORDER BY glossaire_tag DESC 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 * FROM page WHERE id_page = :value LIMIT 1
1 => SELECT a.id_article as value
FROM article a
WHERE a.active = 1 AND a.time_pub < '2026-08-03 23:07:06' AND (a.id_article IN (SELECT id_content FROM tag_content WHERE id_table = :id_table AND id_tag = :id_tag) OR a.id_article IN (SELECT id_content FROM categorie_content WHERE id_table = :id_table AND id_categorie = :id_categorie)) AND a.type_article IN ('article')
ORDER BY a.view_article DESC, a.time_pub DESC
LIMIT 6
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 23:07:06' AND a.active = 1 AND a.langue_article = 'FR' AND a.id_article IN (15824,2200,3445,379,2189,2188)
HAVING id_categorie_default > 0
ORDER BY a.time_pub DESC, a.id_article DESC
LIMIT 0,8
1 => SELECT a.id_article as value
FROM article a
WHERE a.active = 1 AND a.time_pub < '2026-08-03 23:07:06' AND (a.id_article IN (SELECT id_content FROM tag_content WHERE id_table = :id_table AND id_tag = :id_tag) OR a.id_article IN (SELECT id_content FROM categorie_content WHERE id_table = :id_table AND id_categorie = :id_categorie)) AND a.type_article IN ('video','youtube')
ORDER BY a.view_article DESC, a.time_pub DESC
LIMIT 6
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 23:07:06' AND a.active = 1 AND a.langue_article = 'FR' AND a.id_article IN (47988,9717,39976,32749,46738,32748)
HAVING id_categorie_default > 0
ORDER BY a.time_pub DESC, a.id_article DESC
LIMIT 0,8
1 => SELECT a.id_question as value
FROM qr_question a
WHERE a.active = 1 AND a.time_pub < '2026-08-03 23:07:06' AND (a.id_question IN (SELECT id_content FROM tag_content WHERE id_table = :id_table AND id_tag = :id_tag) OR a.id_question IN (SELECT id_content FROM categorie_content WHERE id_table = :id_table AND id_categorie = :id_categorie)) AND a.statut = 5
ORDER BY a.view DESC, a.time_pub DESC
LIMIT 6
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 qr_question a 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 23:07:06' AND a.id_question IN (8910,915,889,3836,25720,21670) ORDER BY ranking DESC, a.time_pub DESC LIMIT 0,6
1 => SELECT FOUND_ROWS() AS total
1 => https://www.googleapis.com/customsearch/v1?key=AIzaSyBntS3fl6_iJlRqlmHjxLYgSq3VT-ZDses&cx=009673669086587974970%3Aeaalbfarjzs&q=17+tamouz&start=1
