| 1 |
5.94 ms |
SELECT m0_.id AS id_0, m0_.titre AS titre_1, m0_.video AS video_2, m0_.poster AS poster_3, m0_.categorie AS categorie_4, m0_.legende AS legende_5, m0_.title AS title_6, m0_.actif AS actif_7, m0_.date_crea AS date_crea_8, m0_.date_modif AS date_modif_9, m0_.poster_bd AS poster_bd_10, m0_.ordre_g AS ordre_g_11, m0_.ordre AS ordre_12 FROM medias m0_ LEFT JOIN medias_auteurs m2_ ON m0_.id = m2_.medias_id LEFT JOIN auteurs a1_ ON a1_.id = m2_.auteurs_id LEFT JOIN paroles p3_ ON m0_.id = p3_.media_id WHERE m0_.actif = 1 AND ((m0_.titre LIKE ? OR m0_.categorie LIKE ? OR m0_.legende LIKE ? OR m0_.title LIKE ? OR a1_.nom LIKE ? OR a1_.prenom LIKE ? OR p3_.texte LIKE ?)) ORDER BY m0_.date_crea DESC
Parameters: [
"%chanter%"
"%chanter%"
"%chanter%"
"%chanter%"
"%chanter%"
"%chanter%"
"%chanter%"
]
SELECT m0_.id AS id_0, m0_.titre AS titre_1, m0_.video AS video_2, m0_.poster AS poster_3, m0_.categorie AS categorie_4, m0_.legende AS legende_5, m0_.title AS title_6, m0_.actif AS actif_7, m0_.date_crea AS date_crea_8, m0_.date_modif AS date_modif_9, m0_.poster_bd AS poster_bd_10, m0_.ordre_g AS ordre_g_11, m0_.ordre AS ordre_12 FROM medias m0_ LEFT JOIN medias_auteurs m2_ ON m0_.id = m2_.medias_id LEFT JOIN auteurs a1_ ON a1_.id = m2_.auteurs_id LEFT JOIN paroles p3_ ON m0_.id = p3_.media_id WHERE m0_.actif = 1 AND ((m0_.titre LIKE '%chanter%' OR m0_.categorie LIKE '%chanter%' OR m0_.legende LIKE '%chanter%' OR m0_.title LIKE '%chanter%' OR a1_.nom LIKE '%chanter%' OR a1_.prenom LIKE '%chanter%' OR p3_.texte LIKE '%chanter%')) ORDER BY m0_.date_crea DESC;
|
| 2 |
0.52 ms |
SELECT t0.id AS id_1, t0.texte AS texte_2, t0.date_crea AS date_crea_3, t0.date_modif AS date_modif_4, t0.actif AS actif_5, t0.media_id AS media_id_6 FROM paroles t0 WHERE t0.media_id = ?
SELECT t0.id AS id_1, t0.texte AS texte_2, t0.date_crea AS date_crea_3, t0.date_modif AS date_modif_4, t0.actif AS actif_5, t0.media_id AS media_id_6 FROM paroles t0 WHERE t0.media_id = 84;
|
| 3 |
0.45 ms |
SELECT t0.id AS id_1, t0.texte AS texte_2, t0.date_crea AS date_crea_3, t0.date_modif AS date_modif_4, t0.actif AS actif_5, t0.media_id AS media_id_6 FROM paroles t0 WHERE t0.media_id = ?
SELECT t0.id AS id_1, t0.texte AS texte_2, t0.date_crea AS date_crea_3, t0.date_modif AS date_modif_4, t0.actif AS actif_5, t0.media_id AS media_id_6 FROM paroles t0 WHERE t0.media_id = 80;
|
| 4 |
0.44 ms |
SELECT t0.id AS id_1, t0.texte AS texte_2, t0.date_crea AS date_crea_3, t0.date_modif AS date_modif_4, t0.actif AS actif_5, t0.media_id AS media_id_6 FROM paroles t0 WHERE t0.media_id = ?
SELECT t0.id AS id_1, t0.texte AS texte_2, t0.date_crea AS date_crea_3, t0.date_modif AS date_modif_4, t0.actif AS actif_5, t0.media_id AS media_id_6 FROM paroles t0 WHERE t0.media_id = 79;
|
| 5 |
2.41 ms |
SELECT n0_.id AS id_0, n0_.texte AS texte_1, n0_.date_publi AS date_publi_2, n0_.titre_lien AS titre_lien_3, n0_.lien AS lien_4, n0_.date_crea AS date_crea_5, n0_.date_modif AS date_modif_6, n0_.actif AS actif_7, n0_.titre AS titre_8 FROM news n0_ WHERE n0_.texte LIKE ? ORDER BY n0_.date_crea DESC
Parameters: [
"%chanter%"
]
SELECT n0_.id AS id_0, n0_.texte AS texte_1, n0_.date_publi AS date_publi_2, n0_.titre_lien AS titre_lien_3, n0_.lien AS lien_4, n0_.date_crea AS date_crea_5, n0_.date_modif AS date_modif_6, n0_.actif AS actif_7, n0_.titre AS titre_8 FROM news n0_ WHERE n0_.texte LIKE '%chanter%' ORDER BY n0_.date_crea DESC;
|
| 6 |
1.46 ms |
SELECT p0_.id AS id_0, p0_.texte AS texte_1, p0_.date_crea AS date_crea_2, p0_.date_modif AS date_modif_3, p0_.actif AS actif_4, p0_.media_id AS media_id_5 FROM paroles p0_ WHERE p0_.texte LIKE ? ORDER BY p0_.date_crea DESC
Parameters: [
"%chanter%"
]
SELECT p0_.id AS id_0, p0_.texte AS texte_1, p0_.date_crea AS date_crea_2, p0_.date_modif AS date_modif_3, p0_.actif AS actif_4, p0_.media_id AS media_id_5 FROM paroles p0_ WHERE p0_.texte LIKE '%chanter%' ORDER BY p0_.date_crea DESC;
|
| 7 |
0.48 ms |
SELECT t0.id AS id_1, t0.prenom AS prenom_2, t0.nom AS nom_3, t0.date_crea AS date_crea_4, t0.date_modif AS date_modif_5, t0.texte AS texte_6 FROM auteurs t0 INNER JOIN medias_auteurs ON t0.id = medias_auteurs.auteurs_id WHERE medias_auteurs.medias_id = ?
SELECT t0.id AS id_1, t0.prenom AS prenom_2, t0.nom AS nom_3, t0.date_crea AS date_crea_4, t0.date_modif AS date_modif_5, t0.texte AS texte_6 FROM auteurs t0 INNER JOIN medias_auteurs ON t0.id = medias_auteurs.auteurs_id WHERE medias_auteurs.medias_id = 84;
|
| 8 |
0.47 ms |
SELECT t0.id AS id_1, t0.prenom AS prenom_2, t0.nom AS nom_3, t0.date_crea AS date_crea_4, t0.date_modif AS date_modif_5, t0.texte AS texte_6 FROM auteurs t0 INNER JOIN medias_auteurs ON t0.id = medias_auteurs.auteurs_id WHERE medias_auteurs.medias_id = ?
SELECT t0.id AS id_1, t0.prenom AS prenom_2, t0.nom AS nom_3, t0.date_crea AS date_crea_4, t0.date_modif AS date_modif_5, t0.texte AS texte_6 FROM auteurs t0 INNER JOIN medias_auteurs ON t0.id = medias_auteurs.auteurs_id WHERE medias_auteurs.medias_id = 80;
|
| 9 |
0.45 ms |
SELECT t0.id AS id_1, t0.prenom AS prenom_2, t0.nom AS nom_3, t0.date_crea AS date_crea_4, t0.date_modif AS date_modif_5, t0.texte AS texte_6 FROM auteurs t0 INNER JOIN medias_auteurs ON t0.id = medias_auteurs.auteurs_id WHERE medias_auteurs.medias_id = ?
SELECT t0.id AS id_1, t0.prenom AS prenom_2, t0.nom AS nom_3, t0.date_crea AS date_crea_4, t0.date_modif AS date_modif_5, t0.texte AS texte_6 FROM auteurs t0 INNER JOIN medias_auteurs ON t0.id = medias_auteurs.auteurs_id WHERE medias_auteurs.medias_id = 79;
|