| 1 |
0.63 ms |
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5, t0.enabled AS enabled_6, t0.salt AS salt_7, t0.last_login AS last_login_8 FROM 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.email AS email_5, t0.enabled AS enabled_6, t0.salt AS salt_7, t0.last_login AS last_login_8 FROM user t0 WHERE t0.id = 42;
|
| 2 |
311.10 ms |
SELECT p0_.id AS id_0, p0_.titre AS titre_1, p0_.contenu AS contenu_2, p0_.exemple AS exemple_3, p0_.date AS date_4, p0_.date_modif AS date_modif_5, p0_.statut AS statut_6, m1_.id AS id_7, m1_.mot AS mot_8, p0_.categorie_id AS categorie_id_9, p0_.auteur_id AS auteur_id_10, p0_.user_modif_id AS user_modif_id_11 FROM page p0_ LEFT JOIN page_mot_cle p2_ ON p0_.id = p2_.page_id LEFT JOIN mot_cle m1_ ON m1_.id = p2_.mot_cle_id WHERE (p0_.statut LIKE ? AND p0_.titre LIKE ?) OR p0_.contenu LIKE ? OR m1_.mot LIKE ? ORDER BY p0_.titre ASC
Parameters: [
"Active"
"%compteur%"
"%compteur%"
"%compteur%"
]
SELECT p0_.id AS id_0, p0_.titre AS titre_1, p0_.contenu AS contenu_2, p0_.exemple AS exemple_3, p0_.date AS date_4, p0_.date_modif AS date_modif_5, p0_.statut AS statut_6, m1_.id AS id_7, m1_.mot AS mot_8, p0_.categorie_id AS categorie_id_9, p0_.auteur_id AS auteur_id_10, p0_.user_modif_id AS user_modif_id_11 FROM page p0_ LEFT JOIN page_mot_cle p2_ ON p0_.id = p2_.page_id LEFT JOIN mot_cle m1_ ON m1_.id = p2_.mot_cle_id WHERE (p0_.statut LIKE 'Active' AND p0_.titre LIKE '%compteur%') OR p0_.contenu LIKE '%compteur%' OR m1_.mot LIKE '%compteur%' ORDER BY p0_.titre ASC;
|
| 3 |
0.53 ms |
SELECT t0.id AS id_1, t0.experience AS experience_2, t0.description AS description_3, t0.niveau AS niveau_4, t0.favori AS favori_5, t0.categorie_mere_id AS categorie_mere_id_6 FROM categorie t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.experience AS experience_2, t0.description AS description_3, t0.niveau AS niveau_4, t0.favori AS favori_5, t0.categorie_mere_id AS categorie_mere_id_6 FROM categorie t0 WHERE t0.id = 16;
|
| 4 |
0.29 ms |
SELECT t0.id AS id_1, t0.extension AS extension_2, t0.nom AS nom_3, t0.uuid AS uuid_4, t0.page_id AS page_id_5 FROM fichier_page t0 WHERE t0.page_id = ?
SELECT t0.id AS id_1, t0.extension AS extension_2, t0.nom AS nom_3, t0.uuid AS uuid_4, t0.page_id AS page_id_5 FROM fichier_page t0 WHERE t0.page_id = 327;
|
| 5 |
0.20 ms |
SELECT t0.id AS id_1, t0.experience AS experience_2, t0.description AS description_3, t0.niveau AS niveau_4, t0.favori AS favori_5, t0.categorie_mere_id AS categorie_mere_id_6 FROM categorie t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.experience AS experience_2, t0.description AS description_3, t0.niveau AS niveau_4, t0.favori AS favori_5, t0.categorie_mere_id AS categorie_mere_id_6 FROM categorie t0 WHERE t0.id = 7;
|
| 6 |
0.36 ms |
SELECT t0.id AS id_1, t0.extension AS extension_2, t0.nom AS nom_3, t0.uuid AS uuid_4, t0.page_id AS page_id_5 FROM fichier_page t0 WHERE t0.page_id = ?
SELECT t0.id AS id_1, t0.extension AS extension_2, t0.nom AS nom_3, t0.uuid AS uuid_4, t0.page_id AS page_id_5 FROM fichier_page t0 WHERE t0.page_id = 7;
|
| 7 |
0.33 ms |
SELECT t0.id AS id_1, t0.experience AS experience_2, t0.description AS description_3, t0.niveau AS niveau_4, t0.favori AS favori_5, t0.categorie_mere_id AS categorie_mere_id_6 FROM categorie t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.experience AS experience_2, t0.description AS description_3, t0.niveau AS niveau_4, t0.favori AS favori_5, t0.categorie_mere_id AS categorie_mere_id_6 FROM categorie t0 WHERE t0.id = 11;
|
| 8 |
0.27 ms |
SELECT t0.id AS id_1, t0.extension AS extension_2, t0.nom AS nom_3, t0.uuid AS uuid_4, t0.page_id AS page_id_5 FROM fichier_page t0 WHERE t0.page_id = ?
SELECT t0.id AS id_1, t0.extension AS extension_2, t0.nom AS nom_3, t0.uuid AS uuid_4, t0.page_id AS page_id_5 FROM fichier_page t0 WHERE t0.page_id = 276;
|
| 9 |
0.35 ms |
SELECT t0.id AS id_1, t0.experience AS experience_2, t0.description AS description_3, t0.niveau AS niveau_4, t0.favori AS favori_5, t0.categorie_mere_id AS categorie_mere_id_6 FROM categorie t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.experience AS experience_2, t0.description AS description_3, t0.niveau AS niveau_4, t0.favori AS favori_5, t0.categorie_mere_id AS categorie_mere_id_6 FROM categorie t0 WHERE t0.id = 17;
|
| 10 |
0.28 ms |
SELECT t0.id AS id_1, t0.extension AS extension_2, t0.nom AS nom_3, t0.uuid AS uuid_4, t0.page_id AS page_id_5 FROM fichier_page t0 WHERE t0.page_id = ?
SELECT t0.id AS id_1, t0.extension AS extension_2, t0.nom AS nom_3, t0.uuid AS uuid_4, t0.page_id AS page_id_5 FROM fichier_page t0 WHERE t0.page_id = 191;
|
| 11 |
0.27 ms |
SELECT t0.id AS id_1, t0.experience AS experience_2, t0.description AS description_3, t0.niveau AS niveau_4, t0.favori AS favori_5, t0.categorie_mere_id AS categorie_mere_id_6 FROM categorie t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.experience AS experience_2, t0.description AS description_3, t0.niveau AS niveau_4, t0.favori AS favori_5, t0.categorie_mere_id AS categorie_mere_id_6 FROM categorie t0 WHERE t0.id = 12;
|
| 12 |
0.30 ms |
SELECT t0.id AS id_1, t0.extension AS extension_2, t0.nom AS nom_3, t0.uuid AS uuid_4, t0.page_id AS page_id_5 FROM fichier_page t0 WHERE t0.page_id = ?
SELECT t0.id AS id_1, t0.extension AS extension_2, t0.nom AS nom_3, t0.uuid AS uuid_4, t0.page_id AS page_id_5 FROM fichier_page t0 WHERE t0.page_id = 74;
|
| 13 |
0.25 ms |
SELECT t0.id AS id_1, t0.extension AS extension_2, t0.nom AS nom_3, t0.uuid AS uuid_4, t0.page_id AS page_id_5 FROM fichier_page t0 WHERE t0.page_id = ?
SELECT t0.id AS id_1, t0.extension AS extension_2, t0.nom AS nom_3, t0.uuid AS uuid_4, t0.page_id AS page_id_5 FROM fichier_page t0 WHERE t0.page_id = 56;
|
| 14 |
0.24 ms |
SELECT t0.id AS id_1, t0.experience AS experience_2, t0.description AS description_3, t0.niveau AS niveau_4, t0.favori AS favori_5, t0.categorie_mere_id AS categorie_mere_id_6 FROM categorie t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.experience AS experience_2, t0.description AS description_3, t0.niveau AS niveau_4, t0.favori AS favori_5, t0.categorie_mere_id AS categorie_mere_id_6 FROM categorie t0 WHERE t0.id = 2;
|
| 15 |
0.23 ms |
SELECT t0.id AS id_1, t0.extension AS extension_2, t0.nom AS nom_3, t0.uuid AS uuid_4, t0.page_id AS page_id_5 FROM fichier_page t0 WHERE t0.page_id = ?
SELECT t0.id AS id_1, t0.extension AS extension_2, t0.nom AS nom_3, t0.uuid AS uuid_4, t0.page_id AS page_id_5 FROM fichier_page t0 WHERE t0.page_id = 352;
|