1
1.63 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 'K%' ;
Copy
2
1.06 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 'K%' ORDER BY r0_ . nom ASC , r0_ . prenom ASC LIMIT 48 ;
Copy
3
0.88 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 :
[
"K% "
373
187
284
1
357
172
164
242
245
459
253
404
389
14
239
]
SELECT r0_ . id AS id_0 , r0_ . nom AS nom_1 , r0_ . prenom AS prenom_2 FROM realisateur r0_ WHERE r0_ . nom LIKE 'K%' AND r0_ . id IN (373 , 187 , 284 , 1 , 357 , 172 , 164 , 242 , 245 , 459 , 253 , 404 , 389 , 14 , 239 ) 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 = 373 ;
Copy
5
1.00 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 = 187 ;
Copy
6
0.70 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 = 284 ;
Copy
7
0.76 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 = 1 ;
Copy
8
0.68 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 = 357 ;
Copy
9
0.73 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 = 172 ;
Copy
10
0.69 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 = 164 ;
Copy
11
0.72 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 = 242 ;
Copy
12
0.77 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 = 245 ;
Copy
13
0.72 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 = 459 ;
Copy
14
0.68 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 = 253 ;
Copy
15
0.78 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 = 404 ;
Copy
16
0.75 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 = 389 ;
Copy
17
0.64 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 = 14 ;
Copy
18
0.70 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 = 239 ;
Copy