1
0.98 ms
SELECT count (DISTINCT r0_ . id ) AS sclr_0 FROM realisateur r0_ WHERE r0_ . nom LIKE ?
SELECT count (DISTINCT r0_ . id ) AS sclr_0 FROM realisateur r0_ WHERE r0_ . nom LIKE 'E%' ;
Copy
2
0.52 ms
SELECT DISTINCT r0_ . id AS id_0 , r0_ . nom AS nom_1 , r0_ . prenom AS prenom_2 FROM realisateur r0_ WHERE r0_ . nom LIKE ? ORDER BY r0_ . nom ASC , r0_ . prenom ASC LIMIT 48
SELECT DISTINCT r0_ . id AS id_0 , r0_ . nom AS nom_1 , r0_ . prenom AS prenom_2 FROM realisateur r0_ WHERE r0_ . nom LIKE 'E%' ORDER BY r0_ . nom ASC , r0_ . prenom ASC LIMIT 48 ;
Copy
3
0.43 ms
SELECT r0_ . id AS id_0 , r0_ . nom AS nom_1 , r0_ . prenom AS prenom_2 FROM realisateur r0_ WHERE r0_ . nom LIKE ? AND r0_ . id IN (? , ? , ? , ? , ? , ? ) ORDER BY r0_ . nom ASC , r0_ . prenom ASC
Parameters :
[
"E% "
131
144
413
100
367
86
]
SELECT r0_ . id AS id_0 , r0_ . nom AS nom_1 , r0_ . prenom AS prenom_2 FROM realisateur r0_ WHERE r0_ . nom LIKE 'E%' AND r0_ . id IN (131 , 144 , 413 , 100 , 367 , 86 ) ORDER BY r0_ . nom ASC , r0_ . prenom ASC ;
Copy
4
0.90 ms
SELECT t0 . id AS id_1 , t0 . titre AS titre_2 , t0 . syno AS syno_3 , t0 . octets AS octets_4 , t0 . size_value AS size_value_5 , t0 . size_unit AS size_unit_6 , t0 . pochette AS pochette_7 , t0 . ftp AS ftp_8 , t0 . link AS link_9 , t0 . film_disque AS film_disque_10 , t0 . film_annee AS film_annee_11 , t0 . film_langue AS film_langue_12 FROM film t0 INNER JOIN film_realisateur ON t0 . id = film_realisateur . film_id WHERE film_realisateur . realisateur_id = ?
SELECT t0 . id AS id_1 , t0 . titre AS titre_2 , t0 . syno AS syno_3 , t0 . octets AS octets_4 , t0 . size_value AS size_value_5 , t0 . size_unit AS size_unit_6 , t0 . pochette AS pochette_7 , t0 . ftp AS ftp_8 , t0 . link AS link_9 , t0 . film_disque AS film_disque_10 , t0 . film_annee AS film_annee_11 , t0 . film_langue AS film_langue_12 FROM film t0 INNER JOIN film_realisateur ON t0 . id = film_realisateur . film_id WHERE film_realisateur . realisateur_id = 131 ;
Copy
5
0.97 ms
SELECT t0 . id AS id_1 , t0 . titre AS titre_2 , t0 . syno AS syno_3 , t0 . octets AS octets_4 , t0 . size_value AS size_value_5 , t0 . size_unit AS size_unit_6 , t0 . pochette AS pochette_7 , t0 . ftp AS ftp_8 , t0 . link AS link_9 , t0 . film_disque AS film_disque_10 , t0 . film_annee AS film_annee_11 , t0 . film_langue AS film_langue_12 FROM film t0 INNER JOIN film_realisateur ON t0 . id = film_realisateur . film_id WHERE film_realisateur . realisateur_id = ?
SELECT t0 . id AS id_1 , t0 . titre AS titre_2 , t0 . syno AS syno_3 , t0 . octets AS octets_4 , t0 . size_value AS size_value_5 , t0 . size_unit AS size_unit_6 , t0 . pochette AS pochette_7 , t0 . ftp AS ftp_8 , t0 . link AS link_9 , t0 . film_disque AS film_disque_10 , t0 . film_annee AS film_annee_11 , t0 . film_langue AS film_langue_12 FROM film t0 INNER JOIN film_realisateur ON t0 . id = film_realisateur . film_id WHERE film_realisateur . realisateur_id = 144 ;
Copy
6
0.60 ms
SELECT t0 . id AS id_1 , t0 . titre AS titre_2 , t0 . syno AS syno_3 , t0 . octets AS octets_4 , t0 . size_value AS size_value_5 , t0 . size_unit AS size_unit_6 , t0 . pochette AS pochette_7 , t0 . ftp AS ftp_8 , t0 . link AS link_9 , t0 . film_disque AS film_disque_10 , t0 . film_annee AS film_annee_11 , t0 . film_langue AS film_langue_12 FROM film t0 INNER JOIN film_realisateur ON t0 . id = film_realisateur . film_id WHERE film_realisateur . realisateur_id = ?
SELECT t0 . id AS id_1 , t0 . titre AS titre_2 , t0 . syno AS syno_3 , t0 . octets AS octets_4 , t0 . size_value AS size_value_5 , t0 . size_unit AS size_unit_6 , t0 . pochette AS pochette_7 , t0 . ftp AS ftp_8 , t0 . link AS link_9 , t0 . film_disque AS film_disque_10 , t0 . film_annee AS film_annee_11 , t0 . film_langue AS film_langue_12 FROM film t0 INNER JOIN film_realisateur ON t0 . id = film_realisateur . film_id WHERE film_realisateur . realisateur_id = 413 ;
Copy
7
0.61 ms
SELECT t0 . id AS id_1 , t0 . titre AS titre_2 , t0 . syno AS syno_3 , t0 . octets AS octets_4 , t0 . size_value AS size_value_5 , t0 . size_unit AS size_unit_6 , t0 . pochette AS pochette_7 , t0 . ftp AS ftp_8 , t0 . link AS link_9 , t0 . film_disque AS film_disque_10 , t0 . film_annee AS film_annee_11 , t0 . film_langue AS film_langue_12 FROM film t0 INNER JOIN film_realisateur ON t0 . id = film_realisateur . film_id WHERE film_realisateur . realisateur_id = ?
SELECT t0 . id AS id_1 , t0 . titre AS titre_2 , t0 . syno AS syno_3 , t0 . octets AS octets_4 , t0 . size_value AS size_value_5 , t0 . size_unit AS size_unit_6 , t0 . pochette AS pochette_7 , t0 . ftp AS ftp_8 , t0 . link AS link_9 , t0 . film_disque AS film_disque_10 , t0 . film_annee AS film_annee_11 , t0 . film_langue AS film_langue_12 FROM film t0 INNER JOIN film_realisateur ON t0 . id = film_realisateur . film_id WHERE film_realisateur . realisateur_id = 100 ;
Copy
8
0.59 ms
SELECT t0 . id AS id_1 , t0 . titre AS titre_2 , t0 . syno AS syno_3 , t0 . octets AS octets_4 , t0 . size_value AS size_value_5 , t0 . size_unit AS size_unit_6 , t0 . pochette AS pochette_7 , t0 . ftp AS ftp_8 , t0 . link AS link_9 , t0 . film_disque AS film_disque_10 , t0 . film_annee AS film_annee_11 , t0 . film_langue AS film_langue_12 FROM film t0 INNER JOIN film_realisateur ON t0 . id = film_realisateur . film_id WHERE film_realisateur . realisateur_id = ?
SELECT t0 . id AS id_1 , t0 . titre AS titre_2 , t0 . syno AS syno_3 , t0 . octets AS octets_4 , t0 . size_value AS size_value_5 , t0 . size_unit AS size_unit_6 , t0 . pochette AS pochette_7 , t0 . ftp AS ftp_8 , t0 . link AS link_9 , t0 . film_disque AS film_disque_10 , t0 . film_annee AS film_annee_11 , t0 . film_langue AS film_langue_12 FROM film t0 INNER JOIN film_realisateur ON t0 . id = film_realisateur . film_id WHERE film_realisateur . realisateur_id = 367 ;
Copy
9
0.60 ms
SELECT t0 . id AS id_1 , t0 . titre AS titre_2 , t0 . syno AS syno_3 , t0 . octets AS octets_4 , t0 . size_value AS size_value_5 , t0 . size_unit AS size_unit_6 , t0 . pochette AS pochette_7 , t0 . ftp AS ftp_8 , t0 . link AS link_9 , t0 . film_disque AS film_disque_10 , t0 . film_annee AS film_annee_11 , t0 . film_langue AS film_langue_12 FROM film t0 INNER JOIN film_realisateur ON t0 . id = film_realisateur . film_id WHERE film_realisateur . realisateur_id = ?
SELECT t0 . id AS id_1 , t0 . titre AS titre_2 , t0 . syno AS syno_3 , t0 . octets AS octets_4 , t0 . size_value AS size_value_5 , t0 . size_unit AS size_unit_6 , t0 . pochette AS pochette_7 , t0 . ftp AS ftp_8 , t0 . link AS link_9 , t0 . film_disque AS film_disque_10 , t0 . film_annee AS film_annee_11 , t0 . film_langue AS film_langue_12 FROM film t0 INNER JOIN film_realisateur ON t0 . id = film_realisateur . film_id WHERE film_realisateur . realisateur_id = 86 ;
Copy