| 1 |
2.24 ms |
SELECT g0_.id AS id_0, g0_.name AS name_1, p1_.id AS id_2, p1_.name AS name_3, r2_.id AS id_4, r2_.name AS name_5, g0_.referential_id AS referential_id_6, g0_.promotion_id AS promotion_id_7, r2_.mark_system_id AS mark_system_id_8 FROM grid g0_ LEFT JOIN promotion p1_ ON g0_.promotion_id = p1_.id LEFT JOIN referential r2_ ON g0_.referential_id = r2_.id ORDER BY g0_.id DESC
SELECT g0_.id AS id_0, g0_.name AS name_1, p1_.id AS id_2, p1_.name AS name_3, r2_.id AS id_4, r2_.name AS name_5, g0_.referential_id AS referential_id_6, g0_.promotion_id AS promotion_id_7, r2_.mark_system_id AS mark_system_id_8 FROM grid g0_ LEFT JOIN promotion p1_ ON g0_.promotion_id = p1_.id LEFT JOIN referential r2_ ON g0_.referential_id = r2_.id ORDER BY g0_.id DESC;
|
| 2 |
0.95 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM promotion t0 ORDER BY t0.name ASC
SELECT t0.id AS id_1, t0.name AS name_2 FROM promotion t0 ORDER BY t0.name ASC;
|
| 3 |
0.50 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.mark_system_id AS mark_system_id_3 FROM referential t0 ORDER BY t0.name ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.mark_system_id AS mark_system_id_3 FROM referential t0 ORDER BY t0.name ASC;
|
| 4 |
0.88 ms |
SELECT t0.id AS id_1, t0.route_name AS route_name_2, t0.title AS title_3, t0.content AS content_4, t0.enabled AS enabled_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM page_help t0 WHERE t0.route_name = ? AND t0.enabled = ? LIMIT 1
Parameters: [
"admin_grid_index"
1
]
SELECT t0.id AS id_1, t0.route_name AS route_name_2, t0.title AS title_3, t0.content AS content_4, t0.enabled AS enabled_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM page_help t0 WHERE t0.route_name = 'admin_grid_index' AND t0.enabled = 1 LIMIT 1;
|
| 5 |
1.00 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.position AS position_4, t0.start_date AS start_date_5, t0.end_date AS end_date_6, t0.duration AS duration_7, t0.program AS program_8, t0.goal AS goal_9, t0.grid_id AS grid_id_10 FROM situation t0 WHERE t0.grid_id = ? ORDER BY t0.position ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.position AS position_4, t0.start_date AS start_date_5, t0.end_date AS end_date_6, t0.duration AS duration_7, t0.program AS program_8, t0.goal AS goal_9, t0.grid_id AS grid_id_10 FROM situation t0 WHERE t0.grid_id = 8 ORDER BY t0.position ASC;
|
| 6 |
0.62 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.position AS position_4, t0.start_date AS start_date_5, t0.end_date AS end_date_6, t0.duration AS duration_7, t0.program AS program_8, t0.goal AS goal_9, t0.grid_id AS grid_id_10 FROM situation t0 WHERE t0.grid_id = ? ORDER BY t0.position ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.position AS position_4, t0.start_date AS start_date_5, t0.end_date AS end_date_6, t0.duration AS duration_7, t0.program AS program_8, t0.goal AS goal_9, t0.grid_id AS grid_id_10 FROM situation t0 WHERE t0.grid_id = 7 ORDER BY t0.position ASC;
|
| 7 |
0.60 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.position AS position_4, t0.start_date AS start_date_5, t0.end_date AS end_date_6, t0.duration AS duration_7, t0.program AS program_8, t0.goal AS goal_9, t0.grid_id AS grid_id_10 FROM situation t0 WHERE t0.grid_id = ? ORDER BY t0.position ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.position AS position_4, t0.start_date AS start_date_5, t0.end_date AS end_date_6, t0.duration AS duration_7, t0.program AS program_8, t0.goal AS goal_9, t0.grid_id AS grid_id_10 FROM situation t0 WHERE t0.grid_id = 6 ORDER BY t0.position ASC;
|
| 8 |
0.57 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.position AS position_4, t0.start_date AS start_date_5, t0.end_date AS end_date_6, t0.duration AS duration_7, t0.program AS program_8, t0.goal AS goal_9, t0.grid_id AS grid_id_10 FROM situation t0 WHERE t0.grid_id = ? ORDER BY t0.position ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.position AS position_4, t0.start_date AS start_date_5, t0.end_date AS end_date_6, t0.duration AS duration_7, t0.program AS program_8, t0.goal AS goal_9, t0.grid_id AS grid_id_10 FROM situation t0 WHERE t0.grid_id = 5 ORDER BY t0.position ASC;
|