| 1 |
6.17 ms |
SELECT count(DISTINCT e0_.id) AS sclr_0 FROM edition e0_ INNER JOIN magazine m1_ ON e0_.magazine_id = m1_.id INNER JOIN school s2_ ON m1_.school_id = s2_.id
SELECT count(DISTINCT e0_.id) AS sclr_0 FROM edition e0_ INNER JOIN magazine m1_ ON e0_.magazine_id = m1_.id INNER JOIN school s2_ ON m1_.school_id = s2_.id;
|
| 2 |
6.57 ms |
SELECT DISTINCT e0_.id AS id_0, e0_.created_at AS created_at_1 FROM edition e0_ INNER JOIN magazine m1_ ON e0_.magazine_id = m1_.id INNER JOIN school s2_ ON m1_.school_id = s2_.id ORDER BY e0_.created_at DESC LIMIT 12 OFFSET 96
SELECT DISTINCT e0_.id AS id_0, e0_.created_at AS created_at_1 FROM edition e0_ INNER JOIN magazine m1_ ON e0_.magazine_id = m1_.id INNER JOIN school s2_ ON m1_.school_id = s2_.id ORDER BY e0_.created_at DESC LIMIT 12 OFFSET 96;
|
| 3 |
2.64 ms |
SELECT e0_.id AS id_0, e0_.title AS title_1, e0_.description AS description_2, e0_.edition AS edition_3, e0_.period AS period_4, e0_.uuid AS uuid_5, e0_.convert_status AS convert_status_6, e0_.page_count AS page_count_7, e0_.width AS width_8, e0_.height AS height_9, e0_.image AS image_10, e0_.pdf AS pdf_11, e0_.created_at AS created_at_12, e0_.updated_at AS updated_at_13, e0_.magazine_id AS magazine_id_14 FROM edition e0_ INNER JOIN magazine m1_ ON e0_.magazine_id = m1_.id INNER JOIN school s2_ ON m1_.school_id = s2_.id WHERE e0_.id IN (?, ?, ?) ORDER BY e0_.created_at DESC
SELECT e0_.id AS id_0, e0_.title AS title_1, e0_.description AS description_2, e0_.edition AS edition_3, e0_.period AS period_4, e0_.uuid AS uuid_5, e0_.convert_status AS convert_status_6, e0_.page_count AS page_count_7, e0_.width AS width_8, e0_.height AS height_9, e0_.image AS image_10, e0_.pdf AS pdf_11, e0_.created_at AS created_at_12, e0_.updated_at AS updated_at_13, e0_.magazine_id AS magazine_id_14 FROM edition e0_ INNER JOIN magazine m1_ ON e0_.magazine_id = m1_.id INNER JOIN school s2_ ON m1_.school_id = s2_.id WHERE e0_.id IN (3, 2, 1) ORDER BY e0_.created_at DESC;
|
| 4 |
1.66 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.is_private AS is_private_4, t0.domain AS domain_5, t0.description AS description_6, t0.image AS image_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.school_id AS school_id_10 FROM magazine t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.is_private AS is_private_4, t0.domain AS domain_5, t0.description AS description_6, t0.image AS image_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.school_id AS school_id_10 FROM magazine t0 WHERE t0.id = 2;
|
| 5 |
1.76 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image AS image_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.city_id AS city_id_7 FROM school t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image AS image_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.city_id AS city_id_7 FROM school t0 WHERE t0.id = 2;
|
| 6 |
6.89 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.is_private AS is_private_4, t0.domain AS domain_5, t0.description AS description_6, t0.image AS image_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.school_id AS school_id_10 FROM magazine t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.is_private AS is_private_4, t0.domain AS domain_5, t0.description AS description_6, t0.image AS image_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.school_id AS school_id_10 FROM magazine t0 WHERE t0.id = 1;
|
| 7 |
1.31 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image AS image_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.city_id AS city_id_7 FROM school t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image AS image_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.city_id AS city_id_7 FROM school t0 WHERE t0.id = 1;
|