03-08-2026 22:12 |
0.0745s | 3.47Mo | PAGE 197 | VILLE 197799 |
MYSQL:13 |
URL:02 => 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.*, 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 a.*, d.time_pub as time_pub_reponse, d.time_check, b.prenom, b.nom, b.email,
d.auteur_reponse, d.texte_reponse, d.livre_reponse, d.checked,
e.id_auteur, CONCAT(e.titre_auteur,e.prenom_auteur,' ',e.nom_auteur) as nom_auteur,
e.titre_auteur, e.prenom_auteur, e.nom_auteur as nom_auteur2,
e.email_auteur, e.id_utilisateur
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.id_question = :id 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 COUNT(*) FROM qr_question a LEFT JOIN qr_reponse b ON b.id_reponse = a.id_reponse WHERE b.id_auteur = :id_auteur AND a.statut = 5 LIMIT 1
1 => SELECT * FROM source_content
WHERE type_source IN ('auteur','livre','paracha') AND id_content = :id AND id_table = 'qr_question'
ORDER BY type_source
1 => SELECT id_source_livre, nom_source_livre FROM source_livre WHERE id_source_livre = :id LIMIT 1
1 => SELECT a.id_tag_content, b.id_tag, b.nom_tag
FROM torahbox.tag_content a
LEFT JOIN torahbox.tag b ON b.id_tag = a.id_tag
WHERE (a.id_content = :id_content AND a.id_table = :id_table)
ORDER BY a.id_tag_content ASC
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 = 42 AND campagne19_livres_status IN (-1,0,1) LIMIT 1
