| 1 |
2.15 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM resource_part t0 WHERE t0.name = ? LIMIT 1
Parameters: [
"Pédagogie"
]
SELECT t0.id AS id_1, t0.name AS name_2 FROM resource_part t0 WHERE t0.name = 'Pédagogie' LIMIT 1;
|
| 2 |
1.00 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.part_id AS part_id_3 FROM resource_section t0 WHERE t0.part_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.part_id AS part_id_3 FROM resource_section t0 WHERE t0.part_id = 2;
|
| 3 |
0.63 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.section_id AS section_id_3 FROM resource_sub_section t0 WHERE t0.section_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.section_id AS section_id_3 FROM resource_sub_section t0 WHERE t0.section_id = 1;
|
| 4 |
0.55 ms |
SELECT t0.id AS id_1, t0.resource_id AS resource_id_2, t0.sub_section_id AS sub_section_id_3 FROM resource_assignment t0 WHERE t0.sub_section_id = ?
SELECT t0.id AS id_1, t0.resource_id AS resource_id_2, t0.sub_section_id AS sub_section_id_3 FROM resource_assignment t0 WHERE t0.sub_section_id = 1;
|
| 5 |
0.68 ms |
SELECT t0.id AS id_3, t0.title AS title_4, t0.resource_type, t1.author AS author_5, t1.file_path AS file_path_6, t2.url AS url_7 FROM resource t0 LEFT JOIN resource_documents t1 ON t0.id = t1.id LEFT JOIN resource_web t2 ON t0.id = t2.id WHERE t0.id = ?
SELECT t0.id AS id_3, t0.title AS title_4, t0.resource_type, t1.author AS author_5, t1.file_path AS file_path_6, t2.url AS url_7 FROM resource t0 LEFT JOIN resource_documents t1 ON t0.id = t1.id LEFT JOIN resource_web t2 ON t0.id = t2.id WHERE t0.id = 1;
|
| 6 |
0.64 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM resource_tags t0 INNER JOIN resource_resource_tags ON t0.id = resource_resource_tags.resource_tags_id WHERE resource_resource_tags.resource_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM resource_tags t0 INNER JOIN resource_resource_tags ON t0.id = resource_resource_tags.resource_tags_id WHERE resource_resource_tags.resource_id = 1;
|
| 7 |
0.43 ms |
SELECT t0.id AS id_1, t0.resource_id AS resource_id_2, t0.sub_section_id AS sub_section_id_3 FROM resource_assignment t0 WHERE t0.sub_section_id = ?
SELECT t0.id AS id_1, t0.resource_id AS resource_id_2, t0.sub_section_id AS sub_section_id_3 FROM resource_assignment t0 WHERE t0.sub_section_id = 3;
|
| 8 |
0.38 ms |
SELECT t0.id AS id_1, t0.resource_id AS resource_id_2, t0.sub_section_id AS sub_section_id_3 FROM resource_assignment t0 WHERE t0.sub_section_id = ?
SELECT t0.id AS id_1, t0.resource_id AS resource_id_2, t0.sub_section_id AS sub_section_id_3 FROM resource_assignment t0 WHERE t0.sub_section_id = 4;
|
| 9 |
0.48 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.section_id AS section_id_3 FROM resource_sub_section t0 WHERE t0.section_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.section_id AS section_id_3 FROM resource_sub_section t0 WHERE t0.section_id = 2;
|
| 10 |
0.37 ms |
SELECT t0.id AS id_1, t0.resource_id AS resource_id_2, t0.sub_section_id AS sub_section_id_3 FROM resource_assignment t0 WHERE t0.sub_section_id = ?
SELECT t0.id AS id_1, t0.resource_id AS resource_id_2, t0.sub_section_id AS sub_section_id_3 FROM resource_assignment t0 WHERE t0.sub_section_id = 2;
|
| 11 |
0.48 ms |
SELECT t0.id AS id_3, t0.title AS title_4, t0.resource_type, t1.author AS author_5, t1.file_path AS file_path_6, t2.url AS url_7 FROM resource t0 LEFT JOIN resource_documents t1 ON t0.id = t1.id LEFT JOIN resource_web t2 ON t0.id = t2.id WHERE t0.id = ?
SELECT t0.id AS id_3, t0.title AS title_4, t0.resource_type, t1.author AS author_5, t1.file_path AS file_path_6, t2.url AS url_7 FROM resource t0 LEFT JOIN resource_documents t1 ON t0.id = t1.id LEFT JOIN resource_web t2 ON t0.id = t2.id WHERE t0.id = 3;
|
| 12 |
0.56 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM resource_tags t0 INNER JOIN resource_resource_tags ON t0.id = resource_resource_tags.resource_tags_id WHERE resource_resource_tags.resource_id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM resource_tags t0 INNER JOIN resource_resource_tags ON t0.id = resource_resource_tags.resource_tags_id WHERE resource_resource_tags.resource_id = 3;
|
| 13 |
0.38 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.section_id AS section_id_3 FROM resource_sub_section t0 WHERE t0.section_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.section_id AS section_id_3 FROM resource_sub_section t0 WHERE t0.section_id = 3;
|
| 14 |
0.40 ms |
SELECT t0.id AS id_1, t0.resource_id AS resource_id_2, t0.sub_section_id AS sub_section_id_3 FROM resource_assignment t0 WHERE t0.sub_section_id = ?
SELECT t0.id AS id_1, t0.resource_id AS resource_id_2, t0.sub_section_id AS sub_section_id_3 FROM resource_assignment t0 WHERE t0.sub_section_id = 5;
|
| 15 |
0.34 ms |
SELECT t0.id AS id_1, t0.resource_id AS resource_id_2, t0.sub_section_id AS sub_section_id_3 FROM resource_assignment t0 WHERE t0.sub_section_id = ?
SELECT t0.id AS id_1, t0.resource_id AS resource_id_2, t0.sub_section_id AS sub_section_id_3 FROM resource_assignment t0 WHERE t0.sub_section_id = 6;
|