1 |
0.31 ms |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.image AS image_3, t0.texte AS texte_4, t0.ordre AS ordre_5, t0.actif AS actif_6, t0.parent_id AS parent_id_7 FROM blog_rubrique t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.image AS image_3, t0.texte AS texte_4, t0.ordre AS ordre_5, t0.actif AS actif_6, t0.parent_id AS parent_id_7 FROM blog_rubrique t0 WHERE t0.id = '3';
|
2 |
0.25 ms |
SELECT b0_.id AS id_0, b0_.sur_titre AS sur_titre_1, b0_.titre AS titre_2, b0_.sous_titre AS sous_titre_3, b0_.chapeau AS chapeau_4, b0_.texte AS texte_5, b0_.date_crea AS date_crea_6, b0_.date_modif AS date_modif_7, b0_.date_publication AS date_publication_8, b0_.en_ligne AS en_ligne_9, b0_.auteur_id AS auteur_id_10 FROM blog_publication b0_ INNER JOIN blog_publication_blog_rubrique b2_ ON b0_.id = b2_.blog_publication_id INNER JOIN blog_rubrique b1_ ON b1_.id = b2_.blog_rubrique_id WHERE b1_.id = ? ORDER BY b0_.date_publication DESC LIMIT 3
SELECT b0_.id AS id_0, b0_.sur_titre AS sur_titre_1, b0_.titre AS titre_2, b0_.sous_titre AS sous_titre_3, b0_.chapeau AS chapeau_4, b0_.texte AS texte_5, b0_.date_crea AS date_crea_6, b0_.date_modif AS date_modif_7, b0_.date_publication AS date_publication_8, b0_.en_ligne AS en_ligne_9, b0_.auteur_id AS auteur_id_10 FROM blog_publication b0_ INNER JOIN blog_publication_blog_rubrique b2_ ON b0_.id = b2_.blog_publication_id INNER JOIN blog_rubrique b1_ ON b1_.id = b2_.blog_rubrique_id WHERE b1_.id = '3' ORDER BY b0_.date_publication DESC LIMIT 3;
|
3 |
0.19 ms |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.sous_titre AS sous_titre_3, t0.logo AS logo_4 FROM blog_header t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.sous_titre AS sous_titre_3, t0.logo AS logo_4 FROM blog_header t0 WHERE t0.id = 1;
|
4 |
0.18 ms |
SELECT t0.id AS id_1, t0.case1_id AS case1_id_2, t0.case2_id AS case2_id_3 FROM blog_chapeau t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.case1_id AS case1_id_2, t0.case2_id AS case2_id_3 FROM blog_chapeau t0 WHERE t0.id = 1;
|
5 |
0.24 ms |
SELECT b0_.id AS id_0, b0_.titre AS titre_1, b0_.image AS image_2, b0_.texte AS texte_3, b0_.ordre AS ordre_4, b0_.actif AS actif_5, b0_.parent_id AS parent_id_6 FROM blog_rubrique b0_ LEFT JOIN blog_rubrique b1_ ON b0_.id = b1_.parent_id WHERE b0_.parent_id IS NULL AND b0_.actif = ? ORDER BY b0_.ordre ASC, b1_.ordre ASC
SELECT b0_.id AS id_0, b0_.titre AS titre_1, b0_.image AS image_2, b0_.texte AS texte_3, b0_.ordre AS ordre_4, b0_.actif AS actif_5, b0_.parent_id AS parent_id_6 FROM blog_rubrique b0_ LEFT JOIN blog_rubrique b1_ ON b0_.id = b1_.parent_id WHERE b0_.parent_id IS NULL AND b0_.actif = 1 ORDER BY b0_.ordre ASC, b1_.ordre ASC;
|
6 |
0.16 ms |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.texte AS texte_3 FROM blog_about t0
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.texte AS texte_3 FROM blog_about t0;
|
7 |
0.15 ms |
SELECT t0.id AS id_1, t0.url_img AS url_img_2, t0.titre AS titre_3, t0.lien AS lien_4 FROM blog_reseaux t0
SELECT t0.id AS id_1, t0.url_img AS url_img_2, t0.titre AS titre_3, t0.lien AS lien_4 FROM blog_reseaux t0;
|
8 |
0.15 ms |
SELECT DISTINCT b0_.date_publication AS date_publication_0 FROM blog_publication b0_ WHERE b0_.date_publication IS NOT NULL ORDER BY b0_.date_publication DESC
SELECT DISTINCT b0_.date_publication AS date_publication_0 FROM blog_publication b0_ WHERE b0_.date_publication IS NOT NULL ORDER BY b0_.date_publication DESC;
|
9 |
0.17 ms |
SELECT b0_.id AS id_0, b0_.url AS url_1, b0_.titre AS titre_2, b0_.legende AS legende_3, b0_.ordre AS ordre_4 FROM blog_image b0_ ORDER BY b0_.id DESC LIMIT 1
SELECT b0_.id AS id_0, b0_.url AS url_1, b0_.titre AS titre_2, b0_.legende AS legende_3, b0_.ordre AS ordre_4 FROM blog_image b0_ ORDER BY b0_.id DESC LIMIT 1;
|
10 |
0.26 ms |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.image AS image_3, t0.texte AS texte_4, t0.ordre AS ordre_5, t0.actif AS actif_6, t0.parent_id AS parent_id_7 FROM blog_rubrique t0 WHERE t0.parent_id = ?
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.image AS image_3, t0.texte AS texte_4, t0.ordre AS ordre_5, t0.actif AS actif_6, t0.parent_id AS parent_id_7 FROM blog_rubrique t0 WHERE t0.parent_id = 3;
|
11 |
0.25 ms |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.image AS image_3, t0.texte AS texte_4, t0.ordre AS ordre_5, t0.actif AS actif_6, t0.parent_id AS parent_id_7 FROM blog_rubrique t0 WHERE t0.parent_id = ?
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.image AS image_3, t0.texte AS texte_4, t0.ordre AS ordre_5, t0.actif AS actif_6, t0.parent_id AS parent_id_7 FROM blog_rubrique t0 WHERE t0.parent_id = 38;
|
12 |
0.16 ms |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.image AS image_3, t0.texte AS texte_4, t0.ordre AS ordre_5, t0.actif AS actif_6, t0.parent_id AS parent_id_7 FROM blog_rubrique t0 WHERE t0.parent_id = ?
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.image AS image_3, t0.texte AS texte_4, t0.ordre AS ordre_5, t0.actif AS actif_6, t0.parent_id AS parent_id_7 FROM blog_rubrique t0 WHERE t0.parent_id = 20;
|
13 |
0.16 ms |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.image AS image_3, t0.texte AS texte_4, t0.ordre AS ordre_5, t0.actif AS actif_6, t0.parent_id AS parent_id_7 FROM blog_rubrique t0 WHERE t0.parent_id = ?
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.image AS image_3, t0.texte AS texte_4, t0.ordre AS ordre_5, t0.actif AS actif_6, t0.parent_id AS parent_id_7 FROM blog_rubrique t0 WHERE t0.parent_id = 40;
|
14 |
0.19 ms |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.image AS image_3, t0.texte AS texte_4, t0.ordre AS ordre_5, t0.actif AS actif_6, t0.parent_id AS parent_id_7 FROM blog_rubrique t0 INNER JOIN blog_publication_blog_rubrique ON t0.id = blog_publication_blog_rubrique.blog_rubrique_id WHERE blog_publication_blog_rubrique.blog_publication_id = ?
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.image AS image_3, t0.texte AS texte_4, t0.ordre AS ordre_5, t0.actif AS actif_6, t0.parent_id AS parent_id_7 FROM blog_rubrique t0 INNER JOIN blog_publication_blog_rubrique ON t0.id = blog_publication_blog_rubrique.blog_rubrique_id WHERE blog_publication_blog_rubrique.blog_publication_id = 1;
|
15 |
0.16 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.titre AS titre_3, t0.legende AS legende_4, t0.ordre AS ordre_5 FROM blog_image t0 INNER JOIN blog_image_blog_publication ON t0.id = blog_image_blog_publication.blog_image_id WHERE blog_image_blog_publication.blog_publication_id = ?
SELECT t0.id AS id_1, t0.url AS url_2, t0.titre AS titre_3, t0.legende AS legende_4, t0.ordre AS ordre_5 FROM blog_image t0 INNER JOIN blog_image_blog_publication ON t0.id = blog_image_blog_publication.blog_image_id WHERE blog_image_blog_publication.blog_publication_id = 1;
|
16 |
0.17 ms |
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.prenom AS prenom_5, t0.nom AS nom_6, t0.societe AS societe_7, t0.email AS email_8, t0.telephone AS telephone_9, t0.cgu AS cgu_10, t0.actif AS actif_11, t0.code_verif AS code_verif_12, t0.date_crea AS date_crea_13, t0.date_modif AS date_modif_14, t0.color AS color_15 FROM secur_user t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.prenom AS prenom_5, t0.nom AS nom_6, t0.societe AS societe_7, t0.email AS email_8, t0.telephone AS telephone_9, t0.cgu AS cgu_10, t0.actif AS actif_11, t0.code_verif AS code_verif_12, t0.date_crea AS date_crea_13, t0.date_modif AS date_modif_14, t0.color AS color_15 FROM secur_user t0 WHERE t0.id = 1;
|
17 |
0.29 ms |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.image AS image_3, t0.texte AS texte_4, t0.ordre AS ordre_5, t0.actif AS actif_6, t0.parent_id AS parent_id_7 FROM blog_rubrique t0 INNER JOIN blog_publication_blog_rubrique ON t0.id = blog_publication_blog_rubrique.blog_rubrique_id WHERE blog_publication_blog_rubrique.blog_publication_id = ?
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.image AS image_3, t0.texte AS texte_4, t0.ordre AS ordre_5, t0.actif AS actif_6, t0.parent_id AS parent_id_7 FROM blog_rubrique t0 INNER JOIN blog_publication_blog_rubrique ON t0.id = blog_publication_blog_rubrique.blog_rubrique_id WHERE blog_publication_blog_rubrique.blog_publication_id = 5;
|
18 |
0.15 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.titre AS titre_3, t0.legende AS legende_4, t0.ordre AS ordre_5 FROM blog_image t0 INNER JOIN blog_image_blog_publication ON t0.id = blog_image_blog_publication.blog_image_id WHERE blog_image_blog_publication.blog_publication_id = ?
SELECT t0.id AS id_1, t0.url AS url_2, t0.titre AS titre_3, t0.legende AS legende_4, t0.ordre AS ordre_5 FROM blog_image t0 INNER JOIN blog_image_blog_publication ON t0.id = blog_image_blog_publication.blog_image_id WHERE blog_image_blog_publication.blog_publication_id = 5;
|
19 |
0.15 ms |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.image AS image_3, t0.texte AS texte_4, t0.ordre AS ordre_5, t0.actif AS actif_6, t0.parent_id AS parent_id_7 FROM blog_rubrique t0 INNER JOIN blog_publication_blog_rubrique ON t0.id = blog_publication_blog_rubrique.blog_rubrique_id WHERE blog_publication_blog_rubrique.blog_publication_id = ?
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.image AS image_3, t0.texte AS texte_4, t0.ordre AS ordre_5, t0.actif AS actif_6, t0.parent_id AS parent_id_7 FROM blog_rubrique t0 INNER JOIN blog_publication_blog_rubrique ON t0.id = blog_publication_blog_rubrique.blog_rubrique_id WHERE blog_publication_blog_rubrique.blog_publication_id = 4;
|
20 |
0.15 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.titre AS titre_3, t0.legende AS legende_4, t0.ordre AS ordre_5 FROM blog_image t0 INNER JOIN blog_image_blog_publication ON t0.id = blog_image_blog_publication.blog_image_id WHERE blog_image_blog_publication.blog_publication_id = ?
SELECT t0.id AS id_1, t0.url AS url_2, t0.titre AS titre_3, t0.legende AS legende_4, t0.ordre AS ordre_5 FROM blog_image t0 INNER JOIN blog_image_blog_publication ON t0.id = blog_image_blog_publication.blog_image_id WHERE blog_image_blog_publication.blog_publication_id = 4;
|