1
1.31 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.78 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
0.65 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
212
57
279
355
224
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 , 212 , 57 , 279 , 355 , 224 , 504 , 46 , 301 , 446 ) ORDER BY r0_ . nom ASC , r0_ . prenom ASC ;
Copy
4
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 = 330 ;
Copy
5
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 = 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.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 = 212 ;
Copy
8
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
9
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 = 279 ;
Copy
10
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 = 355 ;
Copy
11
0.47 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
12
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 = 504 ;
Copy
13
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 = 46 ;
Copy
14
0.49 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
15
0.50 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