Performance Profiling

Total processing time: 277 ms; Peak memory: 3.472 MB. Show Profiling Timeline

Total 57 items.

Time	Duration	Category	Info

11:27:09.417	19.3 ms	yii\db\Command::query	SELECT COUNT(*) FROM `db2_bollettario` WHERE `db2_bollettario`.`id_ente_bollettario`='1'
11:27:09.313	3.8 ms	yii\db\Connection::open	Opening DB connection: mysql:host=localhost;dbname=sanzioni1_0
11:27:09.317	2.8 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `db0_user`
11:27:09.358	2.7 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `db2_bollettario`
11:27:09.322	2.3 ms	yii\db\Command::query	SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'db0_user' AND kcu.table_name = 'db0_user'
11:27:09.444	2.0 ms	yii\db\Command::query	SELECT * FROM `db1_agente` WHERE `id_agente` IN (42, 51, 67, 43, 54, 55, 53, 18, 71, 65, 56, 24)
11:27:09.438	2.0 ms	yii\db\Command::query	SELECT * FROM `db2_bollettario` WHERE `db2_bollettario`.`id_ente_bollettario`='1' ORDER BY `db2_bollettario`.`id_bollettario` DESC LIMIT 20
11:27:09.459	1.8 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `db2_infrazione`
11:27:09.328	1.8 ms	yii\db\Command::query	SELECT * FROM `db0_user` WHERE `id`=59
11:27:09.469	1.7 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `articoli_new`
11:27:09.467	1.7 ms	yii\db\Command::query	SELECT * FROM `articoli_new` WHERE `id_articolo`='1213'
11:27:09.348	1.5 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `db0_ente`
11:27:09.446	1.3 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `db1_agente`
11:27:09.362	1.1 ms	yii\db\Command::query	SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'db2_bollettario' AND kcu.table_name = 'db2_bollettario'
11:27:09.448	1.0 ms	yii\db\Command::query	SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'db1_agente' AND kcu.table_name = 'db1_agente'
11:27:09.463	1.0 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24909
11:27:09.461	1.0 ms	yii\db\Command::query	SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'db2_infrazione' AND kcu.table_name = 'db2_infrazione'
11:27:09.471	1.0 ms	yii\db\Command::query	SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'articoli_new' AND kcu.table_name = 'articoli_new'
11:27:09.504	1.0 ms	yii\db\Command::query	SELECT * FROM `articoli_new` WHERE `id_articolo`='398'
11:27:09.492	1.0 ms	yii\db\Command::query	SELECT * FROM `articoli_new` WHERE `id_articolo`='1053'
11:27:09.481	1.0 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24904
11:27:09.489	1.0 ms	yii\db\Command::query	SELECT * FROM `articoli_new` WHERE `id_articolo`='155'
11:27:09.464	0.9 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24908
11:27:09.475	0.9 ms	yii\db\Command::query	SELECT * FROM `articoli_new` WHERE `id_articolo`='1213'
11:27:09.479	0.9 ms	yii\db\Command::query	SELECT * FROM `articoli_new` WHERE `id_articolo`='155'
11:27:09.485	0.9 ms	yii\db\Command::query	SELECT * FROM `articoli_new` WHERE `id_articolo`='1425'
11:27:09.482	0.9 ms	yii\db\Command::query	SELECT * FROM `articoli_new` WHERE `id_articolo`='580'
11:27:09.501	0.9 ms	yii\db\Command::query	SELECT * FROM `articoli_new` WHERE `id_articolo`='155'
11:27:09.451	0.9 ms	yii\db\Command::query	SELECT * FROM `db0_user` WHERE `id` IN (65, 11, 31)
11:27:09.350	0.9 ms	yii\db\Command::query	SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'db0_ente' AND kcu.table_name = 'db0_ente'
11:27:09.498	0.9 ms	yii\db\Command::query	SELECT * FROM `articoli_new` WHERE `id_articolo`='155'
11:27:09.351	0.9 ms	yii\db\Command::query	SELECT * FROM `db0_ente` WHERE `id_ente`='1'
11:27:09.473	0.9 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24907
11:27:09.487	0.9 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24902
11:27:09.484	0.9 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24903
11:27:09.520	0.9 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24891
11:27:09.495	0.8 ms	yii\db\Command::query	SELECT * FROM `articoli_new` WHERE `id_articolo`='1053'
11:27:09.500	0.8 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24898
11:27:09.496	0.8 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24899
11:27:09.513	0.8 ms	yii\db\Command::query	SELECT * FROM `articoli_new` WHERE `id_articolo`='398'
11:27:09.453	0.8 ms	yii\db\Command::query	SELECT * FROM `db0_user` WHERE `id` IN (65, 11, 31)
11:27:09.493	0.8 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24900
11:27:09.516	0.8 ms	yii\db\Command::query	SELECT * FROM `articoli_new` WHERE `id_articolo`='155'
11:27:09.522	0.8 ms	yii\db\Command::query	SELECT * FROM `articoli_new` WHERE `id_articolo`='155'
11:27:09.490	0.8 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24901
11:27:09.509	0.8 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24895
11:27:09.519	0.8 ms	yii\db\Command::query	SELECT * FROM `articoli_new` WHERE `id_articolo`='155'
11:27:09.510	0.8 ms	yii\db\Command::query	SELECT * FROM `articoli_new` WHERE `id_articolo`='155'
11:27:09.506	0.8 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24896
11:27:09.514	0.8 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24893
11:27:09.503	0.8 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24897
11:27:09.511	0.8 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24894
11:27:09.517	0.8 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24892
11:27:09.507	0.8 ms	yii\db\Command::query	SELECT * FROM `articoli_new` WHERE `id_articolo`='155'
11:27:09.476	0.7 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24906
11:27:09.478	0.7 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24905
11:27:09.523	0.7 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24890