| 1 |
0.44 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.status AS status_4, t0.planned_date AS planned_date_5, t0.completed_date AS completed_date_6, t0.category AS category_7, t0.participant_count AS participant_count_8, t0.cost AS cost_9, t0.responsible_person AS responsible_person_10, t0.created_at AS created_at_11, t0.project_id AS project_id_12, t0.location_id AS location_id_13 FROM activity t0
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.status AS status_4, t0.planned_date AS planned_date_5, t0.completed_date AS completed_date_6, t0.category AS category_7, t0.participant_count AS participant_count_8, t0.cost AS cost_9, t0.responsible_person AS responsible_person_10, t0.created_at AS created_at_11, t0.project_id AS project_id_12, t0.location_id AS location_id_13 FROM activity t0;
|
| 2 |
0.29 ms |
SELECT a0_.status AS status_0, COUNT(a0_.id) AS sclr_1 FROM activity a0_ GROUP BY a0_.status
SELECT a0_.status AS status_0, COUNT(a0_.id) AS sclr_1 FROM activity a0_ GROUP BY a0_.status;
|
| 3 |
0.18 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.status AS status_4, t0.start_date AS start_date_5, t0.end_date AS end_date_6, t0.budget AS budget_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM project t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.status AS status_4, t0.start_date AS start_date_5, t0.end_date AS end_date_6, t0.budget AS budget_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM project t0 WHERE t0.id = 1;
|
| 4 |
0.14 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.region AS region_3, t0.district AS district_4, t0.country AS country_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.area_hectares AS area_hectares_8, t0.location_type AS location_type_9, t0.created_at AS created_at_10 FROM location t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.region AS region_3, t0.district AS district_4, t0.country AS country_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.area_hectares AS area_hectares_8, t0.location_type AS location_type_9, t0.created_at AS created_at_10 FROM location t0 WHERE t0.id = 3;
|
| 5 |
0.09 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.region AS region_3, t0.district AS district_4, t0.country AS country_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.area_hectares AS area_hectares_8, t0.location_type AS location_type_9, t0.created_at AS created_at_10 FROM location t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.region AS region_3, t0.district AS district_4, t0.country AS country_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.area_hectares AS area_hectares_8, t0.location_type AS location_type_9, t0.created_at AS created_at_10 FROM location t0 WHERE t0.id = 5;
|
| 6 |
0.09 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.region AS region_3, t0.district AS district_4, t0.country AS country_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.area_hectares AS area_hectares_8, t0.location_type AS location_type_9, t0.created_at AS created_at_10 FROM location t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.region AS region_3, t0.district AS district_4, t0.country AS country_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.area_hectares AS area_hectares_8, t0.location_type AS location_type_9, t0.created_at AS created_at_10 FROM location t0 WHERE t0.id = 1;
|
| 7 |
0.09 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.region AS region_3, t0.district AS district_4, t0.country AS country_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.area_hectares AS area_hectares_8, t0.location_type AS location_type_9, t0.created_at AS created_at_10 FROM location t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.region AS region_3, t0.district AS district_4, t0.country AS country_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.area_hectares AS area_hectares_8, t0.location_type AS location_type_9, t0.created_at AS created_at_10 FROM location t0 WHERE t0.id = 4;
|
| 8 |
0.09 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.status AS status_4, t0.start_date AS start_date_5, t0.end_date AS end_date_6, t0.budget AS budget_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM project t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.status AS status_4, t0.start_date AS start_date_5, t0.end_date AS end_date_6, t0.budget AS budget_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM project t0 WHERE t0.id = 2;
|
| 9 |
0.12 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.region AS region_3, t0.district AS district_4, t0.country AS country_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.area_hectares AS area_hectares_8, t0.location_type AS location_type_9, t0.created_at AS created_at_10 FROM location t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.region AS region_3, t0.district AS district_4, t0.country AS country_5, t0.latitude AS latitude_6, t0.longitude AS longitude_7, t0.area_hectares AS area_hectares_8, t0.location_type AS location_type_9, t0.created_at AS created_at_10 FROM location t0 WHERE t0.id = 2;
|
| 10 |
0.09 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.status AS status_4, t0.start_date AS start_date_5, t0.end_date AS end_date_6, t0.budget AS budget_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM project t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.status AS status_4, t0.start_date AS start_date_5, t0.end_date AS end_date_6, t0.budget AS budget_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM project t0 WHERE t0.id = 3;
|
| 11 |
0.09 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.status AS status_4, t0.start_date AS start_date_5, t0.end_date AS end_date_6, t0.budget AS budget_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM project t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.status AS status_4, t0.start_date AS start_date_5, t0.end_date AS end_date_6, t0.budget AS budget_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM project t0 WHERE t0.id = 4;
|
| 12 |
0.09 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.status AS status_4, t0.start_date AS start_date_5, t0.end_date AS end_date_6, t0.budget AS budget_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM project t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.status AS status_4, t0.start_date AS start_date_5, t0.end_date AS end_date_6, t0.budget AS budget_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM project t0 WHERE t0.id = 5;
|