Symfony Profiler

Last 10 Latest Search

Method

Status

URL

Token

From

Until

Results

Profiler settings

Query Metrics

31 Database Queries

4 Different statements

11.21 ms Query time

1 Invalid entities

Queries

Group similar statements


SELECT t0.id AS id_1, t0.priority AS priority_2, t0.project AS project_3, t0.live_website AS live_website_4, t0.summary AS summary_5, t0.monthly_revenue AS monthly_revenue_6, t0.c_dev_directory AS c_dev_directory_7, t0.sql_database_file_name AS sql_database_file_name_8, t0.ats_template_last_updated AS ats_template_last_updated_9, t0.active_coding_project AS active_coding_project_10, t0.live_website_working AS live_website_working_11, t0.expand_collapse AS expand_collapse_12 FROM to_do_list t0
"START TRANSACTION"
UPDATE to_do_list SET expand_collapse = ? WHERE id = ?
UPDATE to_do_list SET expand_collapse = ? WHERE id = ?
UPDATE to_do_list SET expand_collapse = ? WHERE id = ?
UPDATE to_do_list SET expand_collapse = ? WHERE id = ?
UPDATE to_do_list SET expand_collapse = ? WHERE id = ?
UPDATE to_do_list SET expand_collapse = ? WHERE id = ?
UPDATE to_do_list SET expand_collapse = ? WHERE id = ?
UPDATE to_do_list SET expand_collapse = ? WHERE id = ?
UPDATE to_do_list SET expand_collapse = ? WHERE id = ?
UPDATE to_do_list SET expand_collapse = ? WHERE id = ?
UPDATE to_do_list SET expand_collapse = ? WHERE id = ?
UPDATE to_do_list SET expand_collapse = ? WHERE id = ?
UPDATE to_do_list SET expand_collapse = ? WHERE id = ?
UPDATE to_do_list SET expand_collapse = ? WHERE id = ?
UPDATE to_do_list SET expand_collapse = ? WHERE id = ?
UPDATE to_do_list SET expand_collapse = ? WHERE id = ?
UPDATE to_do_list SET expand_collapse = ? WHERE id = ?
UPDATE to_do_list SET expand_collapse = ? WHERE id = ?
UPDATE to_do_list SET expand_collapse = ? WHERE id = ?
UPDATE to_do_list SET expand_collapse = ? WHERE id = ?
UPDATE to_do_list SET expand_collapse = ? WHERE id = ?
UPDATE to_do_list SET expand_collapse = ? WHERE id = ?
UPDATE to_do_list SET expand_collapse = ? WHERE id = ?
UPDATE to_do_list SET expand_collapse = ? WHERE id = ?
UPDATE to_do_list SET expand_collapse = ? WHERE id = ?
UPDATE to_do_list SET expand_collapse = ? WHERE id = ?
UPDATE to_do_list SET expand_collapse = ? WHERE id = ?
UPDATE to_do_list SET expand_collapse = ? WHERE id = ?
"COMMIT"

#▲	Time	Info
1	1.23 ms	SELECT t0.id AS id_1, t0.priority AS priority_2, t0.project AS project_3, t0.live_website AS live_website_4, t0.summary AS summary_5, t0.monthly_revenue AS monthly_revenue_6, t0.c_dev_directory AS c_dev_directory_7, t0.sql_database_file_name AS sql_database_file_name_8, t0.ats_template_last_updated AS ats_template_last_updated_9, t0.active_coding_project AS active_coding_project_10, t0.live_website_working AS live_website_working_11, t0.expand_collapse AS expand_collapse_12 FROM to_do_list t0 Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.priority AS priority_2, t0.project AS project_3, t0.live_website AS live_website_4, t0.summary AS summary_5, t0.monthly_revenue AS monthly_revenue_6, t0.c_dev_directory AS c_dev_directory_7, t0.sql_database_file_name AS sql_database_file_name_8, t0.ats_template_last_updated AS ats_template_last_updated_9, t0.active_coding_project AS active_coding_project_10, t0.live_website_working AS live_website_working_11, t0.expand_collapse AS expand_collapse_12 FROM to_do_list t0 SELECT t0.id AS id_1, t0.priority AS priority_2, t0.project AS project_3, t0.live_website AS live_website_4, t0.summary AS summary_5, t0.monthly_revenue AS monthly_revenue_6, t0.c_dev_directory AS c_dev_directory_7, t0.sql_database_file_name AS sql_database_file_name_8, t0.ats_template_last_updated AS ats_template_last_updated_9, t0.active_coding_project AS active_coding_project_10, t0.live_website_working AS live_website_working_11, t0.expand_collapse AS expand_collapse_12 FROM to_do_list t0;
2	0.19 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
3	0.51 ms	UPDATE to_do_list SET expand_collapse = ? WHERE id = ? Parameters: [`"Expand" 36`] View formatted query View runnable query Explain query UPDATE to_do_list SET expand_collapse = ? WHERE id = ? UPDATE to_do_list SET expand_collapse = 'Expand' WHERE id = 36;
4	0.23 ms	UPDATE to_do_list SET expand_collapse = ? WHERE id = ? Parameters: [`"Expand" 37`] View formatted query View runnable query Explain query UPDATE to_do_list SET expand_collapse = ? WHERE id = ? UPDATE to_do_list SET expand_collapse = 'Expand' WHERE id = 37;
5	0.28 ms	UPDATE to_do_list SET expand_collapse = ? WHERE id = ? Parameters: [`"Expand" 38`] View formatted query View runnable query Explain query UPDATE to_do_list SET expand_collapse = ? WHERE id = ? UPDATE to_do_list SET expand_collapse = 'Expand' WHERE id = 38;
6	0.25 ms	UPDATE to_do_list SET expand_collapse = ? WHERE id = ? Parameters: [`"Expand" 39`] View formatted query View runnable query Explain query UPDATE to_do_list SET expand_collapse = ? WHERE id = ? UPDATE to_do_list SET expand_collapse = 'Expand' WHERE id = 39;
7	0.21 ms	UPDATE to_do_list SET expand_collapse = ? WHERE id = ? Parameters: [`"Expand" 40`] View formatted query View runnable query Explain query UPDATE to_do_list SET expand_collapse = ? WHERE id = ? UPDATE to_do_list SET expand_collapse = 'Expand' WHERE id = 40;
8	0.29 ms	UPDATE to_do_list SET expand_collapse = ? WHERE id = ? Parameters: [`"Expand" 41`] View formatted query View runnable query Explain query UPDATE to_do_list SET expand_collapse = ? WHERE id = ? UPDATE to_do_list SET expand_collapse = 'Expand' WHERE id = 41;
9	0.21 ms	UPDATE to_do_list SET expand_collapse = ? WHERE id = ? Parameters: [`"Expand" 43`] View formatted query View runnable query Explain query UPDATE to_do_list SET expand_collapse = ? WHERE id = ? UPDATE to_do_list SET expand_collapse = 'Expand' WHERE id = 43;
10	0.22 ms	UPDATE to_do_list SET expand_collapse = ? WHERE id = ? Parameters: [`"Expand" 44`] View formatted query View runnable query Explain query UPDATE to_do_list SET expand_collapse = ? WHERE id = ? UPDATE to_do_list SET expand_collapse = 'Expand' WHERE id = 44;
11	0.25 ms	UPDATE to_do_list SET expand_collapse = ? WHERE id = ? Parameters: [`"Expand" 46`] View formatted query View runnable query Explain query UPDATE to_do_list SET expand_collapse = ? WHERE id = ? UPDATE to_do_list SET expand_collapse = 'Expand' WHERE id = 46;
12	0.24 ms	UPDATE to_do_list SET expand_collapse = ? WHERE id = ? Parameters: [`"Expand" 47`] View formatted query View runnable query Explain query UPDATE to_do_list SET expand_collapse = ? WHERE id = ? UPDATE to_do_list SET expand_collapse = 'Expand' WHERE id = 47;
13	0.26 ms	UPDATE to_do_list SET expand_collapse = ? WHERE id = ? Parameters: [`"Expand" 48`] View formatted query View runnable query Explain query UPDATE to_do_list SET expand_collapse = ? WHERE id = ? UPDATE to_do_list SET expand_collapse = 'Expand' WHERE id = 48;
14	0.23 ms	UPDATE to_do_list SET expand_collapse = ? WHERE id = ? Parameters: [`"Expand" 49`] View formatted query View runnable query Explain query UPDATE to_do_list SET expand_collapse = ? WHERE id = ? UPDATE to_do_list SET expand_collapse = 'Expand' WHERE id = 49;
15	0.21 ms	UPDATE to_do_list SET expand_collapse = ? WHERE id = ? Parameters: [`"Expand" 52`] View formatted query View runnable query Explain query UPDATE to_do_list SET expand_collapse = ? WHERE id = ? UPDATE to_do_list SET expand_collapse = 'Expand' WHERE id = 52;
16	0.19 ms	UPDATE to_do_list SET expand_collapse = ? WHERE id = ? Parameters: [`"Expand" 54`] View formatted query View runnable query Explain query UPDATE to_do_list SET expand_collapse = ? WHERE id = ? UPDATE to_do_list SET expand_collapse = 'Expand' WHERE id = 54;
17	0.19 ms	UPDATE to_do_list SET expand_collapse = ? WHERE id = ? Parameters: [`"Expand" 56`] View formatted query View runnable query Explain query UPDATE to_do_list SET expand_collapse = ? WHERE id = ? UPDATE to_do_list SET expand_collapse = 'Expand' WHERE id = 56;
18	0.25 ms	UPDATE to_do_list SET expand_collapse = ? WHERE id = ? Parameters: [`"Expand" 57`] View formatted query View runnable query Explain query UPDATE to_do_list SET expand_collapse = ? WHERE id = ? UPDATE to_do_list SET expand_collapse = 'Expand' WHERE id = 57;
19	0.23 ms	UPDATE to_do_list SET expand_collapse = ? WHERE id = ? Parameters: [`"Expand" 58`] View formatted query View runnable query Explain query UPDATE to_do_list SET expand_collapse = ? WHERE id = ? UPDATE to_do_list SET expand_collapse = 'Expand' WHERE id = 58;
20	0.22 ms	UPDATE to_do_list SET expand_collapse = ? WHERE id = ? Parameters: [`"Expand" 60`] View formatted query View runnable query Explain query UPDATE to_do_list SET expand_collapse = ? WHERE id = ? UPDATE to_do_list SET expand_collapse = 'Expand' WHERE id = 60;
21	0.24 ms	UPDATE to_do_list SET expand_collapse = ? WHERE id = ? Parameters: [`"Expand" 62`] View formatted query View runnable query Explain query UPDATE to_do_list SET expand_collapse = ? WHERE id = ? UPDATE to_do_list SET expand_collapse = 'Expand' WHERE id = 62;
22	0.23 ms	UPDATE to_do_list SET expand_collapse = ? WHERE id = ? Parameters: [`"Expand" 63`] View formatted query View runnable query Explain query UPDATE to_do_list SET expand_collapse = ? WHERE id = ? UPDATE to_do_list SET expand_collapse = 'Expand' WHERE id = 63;
23	0.22 ms	UPDATE to_do_list SET expand_collapse = ? WHERE id = ? Parameters: [`"Expand" 64`] View formatted query View runnable query Explain query UPDATE to_do_list SET expand_collapse = ? WHERE id = ? UPDATE to_do_list SET expand_collapse = 'Expand' WHERE id = 64;
24	0.30 ms	UPDATE to_do_list SET expand_collapse = ? WHERE id = ? Parameters: [`"Expand" 65`] View formatted query View runnable query Explain query UPDATE to_do_list SET expand_collapse = ? WHERE id = ? UPDATE to_do_list SET expand_collapse = 'Expand' WHERE id = 65;
25	0.24 ms	UPDATE to_do_list SET expand_collapse = ? WHERE id = ? Parameters: [`"Expand" 66`] View formatted query View runnable query Explain query UPDATE to_do_list SET expand_collapse = ? WHERE id = ? UPDATE to_do_list SET expand_collapse = 'Expand' WHERE id = 66;
26	0.22 ms	UPDATE to_do_list SET expand_collapse = ? WHERE id = ? Parameters: [`"Expand" 68`] View formatted query View runnable query Explain query UPDATE to_do_list SET expand_collapse = ? WHERE id = ? UPDATE to_do_list SET expand_collapse = 'Expand' WHERE id = 68;
27	0.39 ms	UPDATE to_do_list SET expand_collapse = ? WHERE id = ? Parameters: [`"Expand" 69`] View formatted query View runnable query Explain query UPDATE to_do_list SET expand_collapse = ? WHERE id = ? UPDATE to_do_list SET expand_collapse = 'Expand' WHERE id = 69;
28	0.26 ms	UPDATE to_do_list SET expand_collapse = ? WHERE id = ? Parameters: [`"Expand" 71`] View formatted query View runnable query Explain query UPDATE to_do_list SET expand_collapse = ? WHERE id = ? UPDATE to_do_list SET expand_collapse = 'Expand' WHERE id = 71;
29	0.23 ms	UPDATE to_do_list SET expand_collapse = ? WHERE id = ? Parameters: [`"Expand" 72`] View formatted query View runnable query Explain query UPDATE to_do_list SET expand_collapse = ? WHERE id = ? UPDATE to_do_list SET expand_collapse = 'Expand' WHERE id = 72;
30	0.34 ms	UPDATE to_do_list SET expand_collapse = ? WHERE id = ? Parameters: [`"Expand" 73`] View formatted query View runnable query Explain query UPDATE to_do_list SET expand_collapse = ? WHERE id = ? UPDATE to_do_list SET expand_collapse = 'Expand' WHERE id = 73;
31	2.65 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
App\Entity\ToDoList	No errors.
App\Entity\User	The association App\Entity\User#enabledUsers refers to the inverse side field App\Entity\User#photoLocations which does not exist.

Symfony Profiler

GET https://stephen-nurse.com/todolist/update_status_all_to_do_list_projects/Expand

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping