2.47 ms (48.88%)
|
1 |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.image AS image_2, s0_.year AS year_3, s0_.sector AS sector_4, s0_.featured AS featured_5, s0_.active AS active_6, s0_.rank AS rank_7, s0_.updated_at AS updated_at_8, s0_.university_id AS university_id_9, s0_.course_id AS course_id_10 FROM student s0_ WHERE s0_.active = ? AND s0_.featured = ? AND s0_.sector = ? GROUP BY s0_.year ORDER BY s0_.year DESC LIMIT 4
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.image AS image_2, s0_.year AS year_3, s0_.sector AS sector_4, s0_.featured AS featured_5, s0_.active AS active_6, s0_.rank AS rank_7, s0_.updated_at AS updated_at_8, s0_.university_id AS university_id_9, s0_.course_id AS course_id_10 FROM student s0_ WHERE s0_.active = 1 AND s0_.featured = 1 AND s0_.sector = 1 GROUP BY s0_.year ORDER BY s0_.year DESC LIMIT 4;
|
0.72 ms (14.32%)
|
1 |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.image AS image_2, s0_.description AS description_3, s0_.sectors AS sectors_4, s0_.type AS type_5, s0_.active AS active_6, s0_.position AS position_7, s0_.updated_at AS updated_at_8, s0_.job_id AS job_id_9 FROM staff s0_ WHERE s0_.sectors = ? AND s0_.type = ? AND s0_.active = ? ORDER BY s0_.position ASC, s0_.name ASC
Parameters: [
1
"teacher"
1
]
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.image AS image_2, s0_.description AS description_3, s0_.sectors AS sectors_4, s0_.type AS type_5, s0_.active AS active_6, s0_.position AS position_7, s0_.updated_at AS updated_at_8, s0_.job_id AS job_id_9 FROM staff s0_ WHERE s0_.sectors = 1 AND s0_.type = 'teacher' AND s0_.active = 1 ORDER BY s0_.position ASC, s0_.name ASC;
|
0.33 ms (6.51%)
|
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.link AS link_4, t0.sector AS sector_5, t0.active AS active_6, t0.position AS position_7, t0.updated_at AS updated_at_8 FROM banner t0 WHERE t0.sector = ? AND t0.active = ? ORDER BY t0.position ASC
SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.link AS link_4, t0.sector AS sector_5, t0.active AS active_6, t0.position AS position_7, t0.updated_at AS updated_at_8 FROM banner t0 WHERE t0.sector = 1 AND t0.active = 1 ORDER BY t0.position ASC;
|
0.29 ms (5.79%)
|
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.active AS active_4, t0.section AS section_5 FROM video t0 WHERE t0.active = ? ORDER BY t0.id DESC LIMIT 6
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.active AS active_4, t0.section AS section_5 FROM video t0 WHERE t0.active = 1 ORDER BY t0.id DESC LIMIT 6;
|
0.29 ms (5.75%)
|
1 |
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.description AS description_2, t0_.picture AS picture_3, t0_.sector AS sector_4, t0_.active AS active_5, t0_.date AS date_6, t0_.type AS type_7, t0_.updated_at AS updated_at_8 FROM testimony t0_ WHERE t0_.active = ? AND t0_.sector = ? ORDER BY t0_.date DESC LIMIT 3
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.description AS description_2, t0_.picture AS picture_3, t0_.sector AS sector_4, t0_.active AS active_5, t0_.date AS date_6, t0_.type AS type_7, t0_.updated_at AS updated_at_8 FROM testimony t0_ WHERE t0_.active = 1 AND t0_.sector = 1 ORDER BY t0_.date DESC LIMIT 3;
|
0.28 ms (5.63%)
|
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.text AS text_3, t0.image AS image_4, t0.sector AS sector_5, t0.position AS position_6, t0.active AS active_7, t0.updated_at AS updated_at_8 FROM differential t0 WHERE t0.sector = ? AND t0.active = ? ORDER BY t0.position ASC
SELECT t0.id AS id_1, t0.title AS title_2, t0.text AS text_3, t0.image AS image_4, t0.sector AS sector_5, t0.position AS position_6, t0.active AS active_7, t0.updated_at AS updated_at_8 FROM differential t0 WHERE t0.sector = 1 AND t0.active = 1 ORDER BY t0.position ASC;
|
0.26 ms (5.07%)
|
1 |
SELECT t0.id AS id_1, t0.sector AS sector_2, t0.top_title AS top_title_3, t0.top_text AS top_text_4, t0.banner_btn_text AS banner_btn_text_5, t0.banner_btn_link AS banner_btn_link_6, t0.study_title AS study_title_7, t0.study_text AS study_text_8 FROM segment_content t0 WHERE t0.sector = ? LIMIT 1
SELECT t0.id AS id_1, t0.sector AS sector_2, t0.top_title AS top_title_3, t0.top_text AS top_text_4, t0.banner_btn_text AS banner_btn_text_5, t0.banner_btn_link AS banner_btn_link_6, t0.study_title AS study_title_7, t0.study_text AS study_text_8 FROM segment_content t0 WHERE t0.sector = 1 LIMIT 1;
|
0.21 ms (4.17%)
|
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.text AS text_3, t0.image AS image_4, t0.sector AS sector_5, t0.position AS position_6, t0.active AS active_7, t0.updated_at AS updated_at_8 FROM pedagogical_project t0 WHERE t0.sector = ? AND t0.active = ? ORDER BY t0.position ASC
SELECT t0.id AS id_1, t0.title AS title_2, t0.text AS text_3, t0.image AS image_4, t0.sector AS sector_5, t0.position AS position_6, t0.active AS active_7, t0.updated_at AS updated_at_8 FROM pedagogical_project t0 WHERE t0.sector = 1 AND t0.active = 1 ORDER BY t0.position ASC;
|
0.20 ms (3.89%)
|
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.active AS active_3, t0.publish_date AS publish_date_4, t0.section AS section_5, t0.description AS description_6, t0.cover AS cover_7, t0.date AS date_8, t0.updated_at AS updated_at_9 FROM album t0 WHERE t0.title = ? LIMIT 1
Parameters: [
"Nossa Estrutura"
]
SELECT t0.id AS id_1, t0.title AS title_2, t0.active AS active_3, t0.publish_date AS publish_date_4, t0.section AS section_5, t0.description AS description_6, t0.cover AS cover_7, t0.date AS date_8, t0.updated_at AS updated_at_9 FROM album t0 WHERE t0.title = 'Nossa Estrutura' LIMIT 1;
|