1
0.53 ms
SELECT DISTINCT p0_ . id AS id_0 , p0_ . pays_id AS sclr_1 FROM produit p0_ LEFT JOIN pays p1_ ON p0_ . pays_id = p1_ . id ORDER BY p0_ . pays_id ASC LIMIT 20
SELECT DISTINCT p0_ . id AS id_0 , p0_ . pays_id AS sclr_1 FROM produit p0_ LEFT JOIN pays p1_ ON p0_ . pays_id = p1_ . id ORDER BY p0_ . pays_id ASC LIMIT 20 ;
Copy
2
0.61 ms
SELECT p0_ . id AS id_0 , p0_ . titre AS titre_1 , p0_ . description AS description_2 , p0_ . contenu AS contenu_3 , p0_ . is_active AS is_active_4 , p0_ . pays_id AS pays_id_5 , p0_ . type_id AS type_id_6 FROM produit p0_ LEFT JOIN pays p1_ ON p0_ . pays_id = p1_ . id WHERE p0_ . id IN (? , ? , ? , ? , ? , ? ) ORDER BY p0_ . pays_id ASC
Parameters :
[
2
3
4
5
6
1
]
SELECT p0_ . id AS id_0 , p0_ . titre AS titre_1 , p0_ . description AS description_2 , p0_ . contenu AS contenu_3 , p0_ . is_active AS is_active_4 , p0_ . pays_id AS pays_id_5 , p0_ . type_id AS type_id_6 FROM produit p0_ LEFT JOIN pays p1_ ON p0_ . pays_id = p1_ . id WHERE p0_ . id IN (2 , 3 , 4 , 5 , 6 , 1 ) ORDER BY p0_ . pays_id ASC ;
Copy
3
3.09 ms
SELECT count (DISTINCT p0_ . id ) AS sclr_0 FROM produit p0_ LEFT JOIN pays p1_ ON p0_ . pays_id = p1_ . id
SELECT count (DISTINCT p0_ . id ) AS sclr_0 FROM produit p0_ LEFT JOIN pays p1_ ON p0_ . pays_id = p1_ . id ;
Copy
4
0.52 ms
SELECT t0 . id AS id_1 , t0 . titre AS titre_2 , t0 . description AS description_3 , t0 . contentu AS contentu_4 FROM produit_type t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . titre AS titre_2 , t0 . description AS description_3 , t0 . contentu AS contentu_4 FROM produit_type t0 WHERE t0 . id = 1 ;
Copy
5
3.10 ms
SELECT t0 . id AS id_1 , t0 . nom AS nom_2 , t0 . code AS code_3 FROM pays t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . nom AS nom_2 , t0 . code AS code_3 FROM pays t0 WHERE t0 . id = 2 ;
Copy
6
0.46 ms
SELECT t0 . id AS id_1 , t0 . titre AS titre_2 , t0 . description AS description_3 , t0 . contenu AS contenu_4 , t0 . produit_id AS produit_id_5 FROM produit_section t0 WHERE t0 . produit_id = ?
SELECT t0 . id AS id_1 , t0 . titre AS titre_2 , t0 . description AS description_3 , t0 . contenu AS contenu_4 , t0 . produit_id AS produit_id_5 FROM produit_section t0 WHERE t0 . produit_id = 2 ;
Copy
7
0.42 ms
SELECT t0 . id AS id_1 , t0 . file_name AS file_name_2 , t0 . produit_id AS produit_id_3 FROM produit_photo t0 WHERE t0 . produit_id = ?
SELECT t0 . id AS id_1 , t0 . file_name AS file_name_2 , t0 . produit_id AS produit_id_3 FROM produit_photo t0 WHERE t0 . produit_id = 2 ;
Copy
8
0.38 ms
SELECT t0 . id AS id_1 , t0 . titre AS titre_2 , t0 . description AS description_3 , t0 . contentu AS contentu_4 FROM produit_type t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . titre AS titre_2 , t0 . description AS description_3 , t0 . contentu AS contentu_4 FROM produit_type t0 WHERE t0 . id = 2 ;
Copy
9
0.37 ms
SELECT t0 . id AS id_1 , t0 . titre AS titre_2 , t0 . description AS description_3 , t0 . contenu AS contenu_4 , t0 . produit_id AS produit_id_5 FROM produit_section t0 WHERE t0 . produit_id = ?
SELECT t0 . id AS id_1 , t0 . titre AS titre_2 , t0 . description AS description_3 , t0 . contenu AS contenu_4 , t0 . produit_id AS produit_id_5 FROM produit_section t0 WHERE t0 . produit_id = 3 ;
Copy
10
0.36 ms
SELECT t0 . id AS id_1 , t0 . file_name AS file_name_2 , t0 . produit_id AS produit_id_3 FROM produit_photo t0 WHERE t0 . produit_id = ?
SELECT t0 . id AS id_1 , t0 . file_name AS file_name_2 , t0 . produit_id AS produit_id_3 FROM produit_photo t0 WHERE t0 . produit_id = 3 ;
Copy
11
0.31 ms
SELECT t0 . id AS id_1 , t0 . titre AS titre_2 , t0 . description AS description_3 , t0 . contentu AS contentu_4 FROM produit_type t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . titre AS titre_2 , t0 . description AS description_3 , t0 . contentu AS contentu_4 FROM produit_type t0 WHERE t0 . id = 8 ;
Copy
12
0.33 ms
SELECT t0 . id AS id_1 , t0 . titre AS titre_2 , t0 . description AS description_3 , t0 . contenu AS contenu_4 , t0 . produit_id AS produit_id_5 FROM produit_section t0 WHERE t0 . produit_id = ?
SELECT t0 . id AS id_1 , t0 . titre AS titre_2 , t0 . description AS description_3 , t0 . contenu AS contenu_4 , t0 . produit_id AS produit_id_5 FROM produit_section t0 WHERE t0 . produit_id = 4 ;
Copy
13
0.31 ms
SELECT t0 . id AS id_1 , t0 . file_name AS file_name_2 , t0 . produit_id AS produit_id_3 FROM produit_photo t0 WHERE t0 . produit_id = ?
SELECT t0 . id AS id_1 , t0 . file_name AS file_name_2 , t0 . produit_id AS produit_id_3 FROM produit_photo t0 WHERE t0 . produit_id = 4 ;
Copy
14
0.30 ms
SELECT t0 . id AS id_1 , t0 . titre AS titre_2 , t0 . description AS description_3 , t0 . contentu AS contentu_4 FROM produit_type t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . titre AS titre_2 , t0 . description AS description_3 , t0 . contentu AS contentu_4 FROM produit_type t0 WHERE t0 . id = 3 ;
Copy
15
0.34 ms
SELECT t0 . id AS id_1 , t0 . titre AS titre_2 , t0 . description AS description_3 , t0 . contenu AS contenu_4 , t0 . produit_id AS produit_id_5 FROM produit_section t0 WHERE t0 . produit_id = ?
SELECT t0 . id AS id_1 , t0 . titre AS titre_2 , t0 . description AS description_3 , t0 . contenu AS contenu_4 , t0 . produit_id AS produit_id_5 FROM produit_section t0 WHERE t0 . produit_id = 5 ;
Copy
16
0.34 ms
SELECT t0 . id AS id_1 , t0 . file_name AS file_name_2 , t0 . produit_id AS produit_id_3 FROM produit_photo t0 WHERE t0 . produit_id = ?
SELECT t0 . id AS id_1 , t0 . file_name AS file_name_2 , t0 . produit_id AS produit_id_3 FROM produit_photo t0 WHERE t0 . produit_id = 5 ;
Copy
17
0.32 ms
SELECT t0 . id AS id_1 , t0 . titre AS titre_2 , t0 . description AS description_3 , t0 . contentu AS contentu_4 FROM produit_type t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . titre AS titre_2 , t0 . description AS description_3 , t0 . contentu AS contentu_4 FROM produit_type t0 WHERE t0 . id = 4 ;
Copy
18
0.32 ms
SELECT t0 . id AS id_1 , t0 . titre AS titre_2 , t0 . description AS description_3 , t0 . contenu AS contenu_4 , t0 . produit_id AS produit_id_5 FROM produit_section t0 WHERE t0 . produit_id = ?
SELECT t0 . id AS id_1 , t0 . titre AS titre_2 , t0 . description AS description_3 , t0 . contenu AS contenu_4 , t0 . produit_id AS produit_id_5 FROM produit_section t0 WHERE t0 . produit_id = 6 ;
Copy
19
0.31 ms
SELECT t0 . id AS id_1 , t0 . file_name AS file_name_2 , t0 . produit_id AS produit_id_3 FROM produit_photo t0 WHERE t0 . produit_id = ?
SELECT t0 . id AS id_1 , t0 . file_name AS file_name_2 , t0 . produit_id AS produit_id_3 FROM produit_photo t0 WHERE t0 . produit_id = 6 ;
Copy
20
0.29 ms
SELECT t0 . id AS id_1 , t0 . titre AS titre_2 , t0 . description AS description_3 , t0 . contentu AS contentu_4 FROM produit_type t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . titre AS titre_2 , t0 . description AS description_3 , t0 . contentu AS contentu_4 FROM produit_type t0 WHERE t0 . id = 7 ;
Copy
21
0.29 ms
SELECT t0 . id AS id_1 , t0 . nom AS nom_2 , t0 . code AS code_3 FROM pays t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . nom AS nom_2 , t0 . code AS code_3 FROM pays t0 WHERE t0 . id = 22 ;
Copy
22
0.32 ms
SELECT t0 . id AS id_1 , t0 . titre AS titre_2 , t0 . description AS description_3 , t0 . contenu AS contenu_4 , t0 . produit_id AS produit_id_5 FROM produit_section t0 WHERE t0 . produit_id = ?
SELECT t0 . id AS id_1 , t0 . titre AS titre_2 , t0 . description AS description_3 , t0 . contenu AS contenu_4 , t0 . produit_id AS produit_id_5 FROM produit_section t0 WHERE t0 . produit_id = 1 ;
Copy
23
0.31 ms
SELECT t0 . id AS id_1 , t0 . file_name AS file_name_2 , t0 . produit_id AS produit_id_3 FROM produit_photo t0 WHERE t0 . produit_id = ?
SELECT t0 . id AS id_1 , t0 . file_name AS file_name_2 , t0 . produit_id AS produit_id_3 FROM produit_photo t0 WHERE t0 . produit_id = 1 ;
Copy