1
1.91 ms
SELECT DISTINCT p0_ . id AS id_0 , p0_ . type_id AS sclr_1 FROM produit p0_ LEFT JOIN produit_type p1_ ON p0_ . type_id = p1_ . id ORDER BY p0_ . type_id DESC LIMIT 20
SELECT DISTINCT p0_ . id AS id_0 , p0_ . type_id AS sclr_1 FROM produit p0_ LEFT JOIN produit_type p1_ ON p0_ . type_id = p1_ . id ORDER BY p0_ . type_id DESC LIMIT 20 ;
Copy
2
0.72 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 produit_type p1_ ON p0_ . type_id = p1_ . id WHERE p0_ . id IN (? , ? , ? , ? , ? , ? ) ORDER BY p0_ . type_id DESC
Parameters :
[
4
1
6
5
3
2
]
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 produit_type p1_ ON p0_ . type_id = p1_ . id WHERE p0_ . id IN (4 , 1 , 6 , 5 , 3 , 2 ) ORDER BY p0_ . type_id DESC ;
Copy
3
1.08 ms
SELECT count (DISTINCT p0_ . id ) AS sclr_0 FROM produit p0_ LEFT JOIN produit_type p1_ ON p0_ . type_id = p1_ . id
SELECT count (DISTINCT p0_ . id ) AS sclr_0 FROM produit p0_ LEFT JOIN produit_type p1_ ON p0_ . type_id = p1_ . id ;
Copy
4
0.56 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
5
1.73 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
1.05 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
7
0.95 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
8
0.46 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
9
0.35 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
10
0.43 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
11
0.37 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
12
0.35 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
13
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 = 6 ;
Copy
14
0.37 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
15
0.34 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
16
0.43 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
17
0.35 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
18
0.36 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
19
0.38 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
20
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
21
0.37 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
22
0.36 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
23
0.37 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