1
22.70 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 'J%' ;
Copy
2
0.81 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 'J%' ORDER BY r0_ . nom ASC , r0_ . prenom ASC LIMIT 48 ;
Copy
3
1.11 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 :
[
"J% "
330
265
474
548
212
607
57
279
355
224
575
504
46
301
446
]
SELECT r0_ . id AS id_0 , r0_ . nom AS nom_1 , r0_ . prenom AS prenom_2 FROM realisateur r0_ WHERE r0_ . nom LIKE 'J%' AND r0_ . id IN (330 , 265 , 474 , 548 , 212 , 607 , 57 , 279 , 355 , 224 , 575 , 504 , 46 , 301 , 446 ) ORDER BY r0_ . nom ASC , r0_ . prenom ASC ;
Copy
4
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 = 330 ;
Copy
5
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 = 265 ;
Copy
6
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 = 474 ;
Copy
7
0.53 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 = 548 ;
Copy
8
0.62 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 = 212 ;
Copy
9
0.58 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 = 607 ;
Copy
10
0.53 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 = 57 ;
Copy
11
0.57 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 = 279 ;
Copy
12
0.56 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 = 355 ;
Copy
13
0.51 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 = 224 ;
Copy
14
0.58 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 = 575 ;
Copy
15
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 = 504 ;
Copy
16
0.66 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 = 46 ;
Copy
17
0.54 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 = 301 ;
Copy
18
0.52 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 = 446 ;
Copy