2.88 ms (47.98%)
1
SELECT p0_ . status AS status_0 , COUNT (p0_ . id ) AS sclr_1 FROM project p0_ GROUP BY p0_ . status
SELECT p0_ . status AS status_0 , COUNT (p0_ . id ) AS sclr_1 FROM project p0_ GROUP BY p0_ . status ;
Copy
0.95 ms (15.77%)
1
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 ;
Copy
0.49 ms (8.23%)
5
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 ;
Copy
0.47 ms (7.89%)
2
SELECT a0_ . id AS id_0 , a0_ . name AS name_1 , a0_ . description AS description_2 , a0_ . status AS status_3 , a0_ . planned_date AS planned_date_4 , a0_ . completed_date AS completed_date_5 , a0_ . category AS category_6 , a0_ . participant_count AS participant_count_7 , a0_ . cost AS cost_8 , a0_ . responsible_person AS responsible_person_9 , a0_ . created_at AS created_at_10 , a0_ . project_id AS project_id_11 , a0_ . location_id AS location_id_12 FROM activity a0_ WHERE a0_ . planned_date < ? AND a0_ . status NOT IN (? , ? ) ORDER BY a0_ . planned_date ASC
Parameters :
[
"2026-03-13 04:50:28 "
"completed "
"cancelled "
]
SELECT a0_ . id AS id_0 , a0_ . name AS name_1 , a0_ . description AS description_2 , a0_ . status AS status_3 , a0_ . planned_date AS planned_date_4 , a0_ . completed_date AS completed_date_5 , a0_ . category AS category_6 , a0_ . participant_count AS participant_count_7 , a0_ . cost AS cost_8 , a0_ . responsible_person AS responsible_person_9 , a0_ . created_at AS created_at_10 , a0_ . project_id AS project_id_11 , a0_ . location_id AS location_id_12 FROM activity a0_ WHERE a0_ . planned_date < '2026-03-13 04:50:28' AND a0_ . status NOT IN ('completed' , 'cancelled' ) ORDER BY a0_ . planned_date ASC ;
Copy
0.26 ms (4.41%)
1
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
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 ;
Copy
0.25 ms (4.11%)
1
SELECT a0_ . id AS id_0 , a0_ . name AS name_1 , a0_ . description AS description_2 , a0_ . status AS status_3 , a0_ . planned_date AS planned_date_4 , a0_ . completed_date AS completed_date_5 , a0_ . category AS category_6 , a0_ . participant_count AS participant_count_7 , a0_ . cost AS cost_8 , a0_ . responsible_person AS responsible_person_9 , a0_ . created_at AS created_at_10 , a0_ . project_id AS project_id_11 , a0_ . location_id AS location_id_12 FROM activity a0_ WHERE a0_ . status = ? ORDER BY a0_ . completed_date DESC LIMIT 5
Parameters :
[
"completed "
]
SELECT a0_ . id AS id_0 , a0_ . name AS name_1 , a0_ . description AS description_2 , a0_ . status AS status_3 , a0_ . planned_date AS planned_date_4 , a0_ . completed_date AS completed_date_5 , a0_ . category AS category_6 , a0_ . participant_count AS participant_count_7 , a0_ . cost AS cost_8 , a0_ . responsible_person AS responsible_person_9 , a0_ . created_at AS created_at_10 , a0_ . project_id AS project_id_11 , a0_ . location_id AS location_id_12 FROM activity a0_ WHERE a0_ . status = 'completed' ORDER BY a0_ . completed_date DESC LIMIT 5 ;
Copy
0.22 ms (3.74%)
1
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . description AS description_3 , t0 . unit AS unit_4 , t0 . baseline_value AS baseline_value_5 , t0 . target_value AS target_value_6 , t0 . current_value AS current_value_7 , t0 . category AS category_8 , t0 . frequency AS frequency_9 , t0 . created_at AS created_at_10 , t0 . project_id AS project_id_11 FROM indicator t0
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . description AS description_3 , t0 . unit AS unit_4 , t0 . baseline_value AS baseline_value_5 , t0 . target_value AS target_value_6 , t0 . current_value AS current_value_7 , t0 . category AS category_8 , t0 . frequency AS frequency_9 , t0 . created_at AS created_at_10 , t0 . project_id AS project_id_11 FROM indicator t0 ;
Copy
0.16 ms (2.68%)
1
SELECT a0_ . id AS id_0 , a0_ . name AS name_1 , a0_ . description AS description_2 , a0_ . status AS status_3 , a0_ . planned_date AS planned_date_4 , a0_ . completed_date AS completed_date_5 , a0_ . category AS category_6 , a0_ . participant_count AS participant_count_7 , a0_ . cost AS cost_8 , a0_ . responsible_person AS responsible_person_9 , a0_ . created_at AS created_at_10 , a0_ . project_id AS project_id_11 , a0_ . location_id AS location_id_12 FROM activity a0_ WHERE (a0_ . planned_date BETWEEN ? AND ? ) AND a0_ . status < > ? ORDER BY a0_ . planned_date ASC
Parameters :
[
"2026-03-13 04:50:28 "
"2026-04-12 04:50:28 "
"completed "
]
SELECT a0_ . id AS id_0 , a0_ . name AS name_1 , a0_ . description AS description_2 , a0_ . status AS status_3 , a0_ . planned_date AS planned_date_4 , a0_ . completed_date AS completed_date_5 , a0_ . category AS category_6 , a0_ . participant_count AS participant_count_7 , a0_ . cost AS cost_8 , a0_ . responsible_person AS responsible_person_9 , a0_ . created_at AS created_at_10 , a0_ . project_id AS project_id_11 , a0_ . location_id AS location_id_12 FROM activity a0_ WHERE (a0_ . planned_date BETWEEN '2026-03-13 04:50:28' AND '2026-04-12 04:50:28' ) AND a0_ . status < > 'completed' ORDER BY a0_ . planned_date ASC ;
Copy
0.14 ms (2.35%)
1
SELECT SUM (l0_ . area_hectares ) AS sclr_0 FROM location l0_
SELECT SUM (l0_ . area_hectares ) AS sclr_0 FROM location l0_ ;
Copy
0.09 ms (1.47%)
1
SELECT SUM (a0_ . participant_count ) AS sclr_0 FROM activity a0_
SELECT SUM (a0_ . participant_count ) AS sclr_0 FROM activity a0_ ;
Copy
0.08 ms (1.37%)
1
SELECT SUM (p0_ . budget ) AS sclr_0 FROM project p0_
SELECT SUM (p0_ . budget ) AS sclr_0 FROM project p0_ ;
Copy