1
0.92 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 'N%' ;
Copy
2
0.50 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 'N%' ORDER BY r0_ . nom ASC , r0_ . prenom ASC LIMIT 48 ;
Copy
3
0.44 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 :
[
"N% "
313
468
278
296
26
453
77
145
71
470
193
]
SELECT r0_ . id AS id_0 , r0_ . nom AS nom_1 , r0_ . prenom AS prenom_2 FROM realisateur r0_ WHERE r0_ . nom LIKE 'N%' AND r0_ . id IN (313 , 468 , 278 , 296 , 26 , 453 , 77 , 145 , 71 , 470 , 193 ) ORDER BY r0_ . nom ASC , r0_ . prenom ASC ;
Copy
4
0.48 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 = 313 ;
Copy
5
0.55 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 = 468 ;
Copy
6
0.41 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 = 278 ;
Copy
7
0.45 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 = 296 ;
Copy
8
0.39 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 = 26 ;
Copy
9
0.37 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 = 453 ;
Copy
10
0.38 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 = 77 ;
Copy
11
0.36 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 = 145 ;
Copy
12
0.35 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 = 71 ;
Copy
13
0.32 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 = 470 ;
Copy
14
0.31 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 = 193 ;
Copy