1
1.22 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . code AS code_3 , t0 . status AS status_4 FROM language t0 WHERE t0 . code = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . code AS code_3 , t0 . status AS status_4 FROM language t0 WHERE t0 . code = 'fr' LIMIT 1 ;
Copy
2
0.64 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . status AS status_3 , t0 . type AS type_4 FROM category t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . status AS status_3 , t0 . type AS type_4 FROM category t0 WHERE t0 . id = '14' ;
Copy
3
1.34 ms
SELECT r0_ . id AS id_0 , r0_ . name AS name_1 , r0_ . description AS description_2 , r0_ . content AS content_3 , r0_ . report_id AS report_id_4 , r0_ . language_id AS language_id_5 FROM report_translation r0_ INNER JOIN report r1_ ON (r1_ . id = r0_ . report_id ) WHERE r1_ . status = ? AND r1_ . type = ? AND EXISTS (SELECT 1 FROM report_category r2_ WHERE r2_ . report_id = r1_ . id AND r2_ . category_id IN (? )) AND r0_ . language_id = ? ORDER BY r1_ . published DESC
Parameters :
[
1
"1 "
14
169
]
SELECT r0_ . id AS id_0 , r0_ . name AS name_1 , r0_ . description AS description_2 , r0_ . content AS content_3 , r0_ . report_id AS report_id_4 , r0_ . language_id AS language_id_5 FROM report_translation r0_ INNER JOIN report r1_ ON (r1_ . id = r0_ . report_id ) WHERE r1_ . status = 1 AND r1_ . type = '1' AND EXISTS (SELECT 1 FROM report_category r2_ WHERE r2_ . report_id = r1_ . id AND r2_ . category_id IN (14 )) AND r0_ . language_id = 169 ORDER BY r1_ . published DESC ;
Copy
4
0.57 ms
SELECT r0_ . id AS id_0 , r0_ . name AS name_1 , r0_ . description AS description_2 , r0_ . content AS content_3 , r0_ . report_id AS report_id_4 , r0_ . language_id AS language_id_5 FROM report_translation r0_ INNER JOIN report r1_ ON (r1_ . id = r0_ . report_id ) WHERE r1_ . status = ? AND r0_ . language_id = ? ORDER BY r1_ . published DESC
SELECT r0_ . id AS id_0 , r0_ . name AS name_1 , r0_ . description AS description_2 , r0_ . content AS content_3 , r0_ . report_id AS report_id_4 , r0_ . language_id AS language_id_5 FROM report_translation r0_ INNER JOIN report r1_ ON (r1_ . id = r0_ . report_id ) WHERE r1_ . status = 1 AND r0_ . language_id = 169 ORDER BY r1_ . published DESC ;
Copy
5
0.41 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . code AS code_3 , t0 . status AS status_4 FROM language t0 WHERE t0 . code = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . code AS code_3 , t0 . status AS status_4 FROM language t0 WHERE t0 . code = 'fr' LIMIT 1 ;
Copy
6
0.26 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . code AS code_3 , t0 . status AS status_4 FROM language t0 WHERE t0 . code = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . code AS code_3 , t0 . status AS status_4 FROM language t0 WHERE t0 . code = 'fr' LIMIT 1 ;
Copy
7
0.29 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . logo AS logo_3 FROM departement t0
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . logo AS logo_3 FROM departement t0 ;
Copy
8
0.56 ms
SELECT t0 . id AS id_1 , t0 . file AS file_2 , t0 . type AS type_3 , t0 . name AS name_4 , t0 . image AS image_5 , t0 . description AS description_6 , t0 . content AS content_7 , t0 . created AS created_8 , t0 . updated AS updated_9 , t0 . published AS published_10 , t0 . status AS status_11 , t0 . uid AS uid_12 FROM report t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . file AS file_2 , t0 . type AS type_3 , t0 . name AS name_4 , t0 . image AS image_5 , t0 . description AS description_6 , t0 . content AS content_7 , t0 . created AS created_8 , t0 . updated AS updated_9 , t0 . published AS published_10 , t0 . status AS status_11 , t0 . uid AS uid_12 FROM report t0 WHERE t0 . id = 161 ;
Copy
9
0.26 ms
SELECT t0 . id AS id_1 , t0 . file AS file_2 , t0 . type AS type_3 , t0 . name AS name_4 , t0 . image AS image_5 , t0 . description AS description_6 , t0 . content AS content_7 , t0 . created AS created_8 , t0 . updated AS updated_9 , t0 . published AS published_10 , t0 . status AS status_11 , t0 . uid AS uid_12 FROM report t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . file AS file_2 , t0 . type AS type_3 , t0 . name AS name_4 , t0 . image AS image_5 , t0 . description AS description_6 , t0 . content AS content_7 , t0 . created AS created_8 , t0 . updated AS updated_9 , t0 . published AS published_10 , t0 . status AS status_11 , t0 . uid AS uid_12 FROM report t0 WHERE t0 . id = 160 ;
Copy
10
0.16 ms
SELECT t0 . id AS id_1 , t0 . file AS file_2 , t0 . type AS type_3 , t0 . name AS name_4 , t0 . image AS image_5 , t0 . description AS description_6 , t0 . content AS content_7 , t0 . created AS created_8 , t0 . updated AS updated_9 , t0 . published AS published_10 , t0 . status AS status_11 , t0 . uid AS uid_12 FROM report t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . file AS file_2 , t0 . type AS type_3 , t0 . name AS name_4 , t0 . image AS image_5 , t0 . description AS description_6 , t0 . content AS content_7 , t0 . created AS created_8 , t0 . updated AS updated_9 , t0 . published AS published_10 , t0 . status AS status_11 , t0 . uid AS uid_12 FROM report t0 WHERE t0 . id = 159 ;
Copy
11
0.11 ms
SELECT t0 . id AS id_1 , t0 . file AS file_2 , t0 . type AS type_3 , t0 . name AS name_4 , t0 . image AS image_5 , t0 . description AS description_6 , t0 . content AS content_7 , t0 . created AS created_8 , t0 . updated AS updated_9 , t0 . published AS published_10 , t0 . status AS status_11 , t0 . uid AS uid_12 FROM report t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . file AS file_2 , t0 . type AS type_3 , t0 . name AS name_4 , t0 . image AS image_5 , t0 . description AS description_6 , t0 . content AS content_7 , t0 . created AS created_8 , t0 . updated AS updated_9 , t0 . published AS published_10 , t0 . status AS status_11 , t0 . uid AS uid_12 FROM report t0 WHERE t0 . id = 158 ;
Copy
12
0.06 ms
SELECT t0 . id AS id_1 , t0 . file AS file_2 , t0 . type AS type_3 , t0 . name AS name_4 , t0 . image AS image_5 , t0 . description AS description_6 , t0 . content AS content_7 , t0 . created AS created_8 , t0 . updated AS updated_9 , t0 . published AS published_10 , t0 . status AS status_11 , t0 . uid AS uid_12 FROM report t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . file AS file_2 , t0 . type AS type_3 , t0 . name AS name_4 , t0 . image AS image_5 , t0 . description AS description_6 , t0 . content AS content_7 , t0 . created AS created_8 , t0 . updated AS updated_9 , t0 . published AS published_10 , t0 . status AS status_11 , t0 . uid AS uid_12 FROM report t0 WHERE t0 . id = 156 ;
Copy
13
0.09 ms
SELECT t0 . id AS id_1 , t0 . file AS file_2 , t0 . type AS type_3 , t0 . name AS name_4 , t0 . image AS image_5 , t0 . description AS description_6 , t0 . content AS content_7 , t0 . created AS created_8 , t0 . updated AS updated_9 , t0 . published AS published_10 , t0 . status AS status_11 , t0 . uid AS uid_12 FROM report t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . file AS file_2 , t0 . type AS type_3 , t0 . name AS name_4 , t0 . image AS image_5 , t0 . description AS description_6 , t0 . content AS content_7 , t0 . created AS created_8 , t0 . updated AS updated_9 , t0 . published AS published_10 , t0 . status AS status_11 , t0 . uid AS uid_12 FROM report t0 WHERE t0 . id = 155 ;
Copy
14
0.06 ms
SELECT t0 . id AS id_1 , t0 . file AS file_2 , t0 . type AS type_3 , t0 . name AS name_4 , t0 . image AS image_5 , t0 . description AS description_6 , t0 . content AS content_7 , t0 . created AS created_8 , t0 . updated AS updated_9 , t0 . published AS published_10 , t0 . status AS status_11 , t0 . uid AS uid_12 FROM report t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . file AS file_2 , t0 . type AS type_3 , t0 . name AS name_4 , t0 . image AS image_5 , t0 . description AS description_6 , t0 . content AS content_7 , t0 . created AS created_8 , t0 . updated AS updated_9 , t0 . published AS published_10 , t0 . status AS status_11 , t0 . uid AS uid_12 FROM report t0 WHERE t0 . id = 154 ;
Copy
15
0.05 ms
SELECT t0 . id AS id_1 , t0 . file AS file_2 , t0 . type AS type_3 , t0 . name AS name_4 , t0 . image AS image_5 , t0 . description AS description_6 , t0 . content AS content_7 , t0 . created AS created_8 , t0 . updated AS updated_9 , t0 . published AS published_10 , t0 . status AS status_11 , t0 . uid AS uid_12 FROM report t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . file AS file_2 , t0 . type AS type_3 , t0 . name AS name_4 , t0 . image AS image_5 , t0 . description AS description_6 , t0 . content AS content_7 , t0 . created AS created_8 , t0 . updated AS updated_9 , t0 . published AS published_10 , t0 . status AS status_11 , t0 . uid AS uid_12 FROM report t0 WHERE t0 . id = 117 ;
Copy
16
0.05 ms
SELECT t0 . id AS id_1 , t0 . file AS file_2 , t0 . type AS type_3 , t0 . name AS name_4 , t0 . image AS image_5 , t0 . description AS description_6 , t0 . content AS content_7 , t0 . created AS created_8 , t0 . updated AS updated_9 , t0 . published AS published_10 , t0 . status AS status_11 , t0 . uid AS uid_12 FROM report t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . file AS file_2 , t0 . type AS type_3 , t0 . name AS name_4 , t0 . image AS image_5 , t0 . description AS description_6 , t0 . content AS content_7 , t0 . created AS created_8 , t0 . updated AS updated_9 , t0 . published AS published_10 , t0 . status AS status_11 , t0 . uid AS uid_12 FROM report t0 WHERE t0 . id = 116 ;
Copy
17
0.04 ms
SELECT t0 . id AS id_1 , t0 . file AS file_2 , t0 . type AS type_3 , t0 . name AS name_4 , t0 . image AS image_5 , t0 . description AS description_6 , t0 . content AS content_7 , t0 . created AS created_8 , t0 . updated AS updated_9 , t0 . published AS published_10 , t0 . status AS status_11 , t0 . uid AS uid_12 FROM report t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . file AS file_2 , t0 . type AS type_3 , t0 . name AS name_4 , t0 . image AS image_5 , t0 . description AS description_6 , t0 . content AS content_7 , t0 . created AS created_8 , t0 . updated AS updated_9 , t0 . published AS published_10 , t0 . status AS status_11 , t0 . uid AS uid_12 FROM report t0 WHERE t0 . id = 115 ;
Copy