Performance Profiling

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

Total 57 items.

Time	Duration	Category	Info

11:43:41.043	17.5 ms	yii\db\Command::query	SELECT COUNT(*) FROM `db2_bollettario` WHERE `db2_bollettario`.`id_ente_bollettario`='1'
11:43:40.958	4.4 ms	yii\db\Connection::open	Opening DB connection: mysql:host=localhost;dbname=sanzioni1_0
11:43:40.963	2.7 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `db0_user`
11:43:41.062	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:43:40.967	2.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 = 'db0_user' AND kcu.table_name = 'db0_user'
11:43:41.003	1.8 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `db2_bollettario`
11:43:41.090	1.8 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `articoli_new`
11:43:41.069	1.5 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `db1_agente`
11:43:41.082	1.4 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `db2_infrazione`
11:43:40.994	1.3 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `db0_ente`
11:43:41.006	1.2 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:43:40.973	1.2 ms	yii\db\Command::query	SELECT * FROM `db0_user` WHERE `id`=59
11:43:40.995	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 = 'db0_ente' AND kcu.table_name = 'db0_ente'
11:43:41.072	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 = 'db1_agente' AND kcu.table_name = 'db1_agente'
11:43:41.084	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_infrazione' AND kcu.table_name = 'db2_infrazione'
11:43:41.068	1.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:43:41.093	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:43:41.089	1.0 ms	yii\db\Command::query	SELECT * FROM `articoli_new` WHERE `id_articolo`='1213'
11:43:41.096	1.0 ms	yii\db\Command::query	SELECT * FROM `articoli_new` WHERE `id_articolo`='1213'
11:43:41.110	0.9 ms	yii\db\Command::query	SELECT * FROM `articoli_new` WHERE `id_articolo`='155'
11:43:41.101	0.9 ms	yii\db\Command::query	SELECT * FROM `articoli_new` WHERE `id_articolo`='155'
11:43:41.074	0.9 ms	yii\db\Command::query	SELECT * FROM `db0_user` WHERE `id` IN (65, 11, 31)
11:43:41.136	0.9 ms	yii\db\Command::query	SELECT * FROM `articoli_new` WHERE `id_articolo`='155'
11:43:41.133	0.9 ms	yii\db\Command::query	SELECT * FROM `articoli_new` WHERE `id_articolo`='398'
11:43:41.114	0.9 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24900
11:43:41.135	0.8 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24893
11:43:41.113	0.8 ms	yii\db\Command::query	SELECT * FROM `articoli_new` WHERE `id_articolo`='1053'
11:43:41.098	0.8 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24906
11:43:41.139	0.8 ms	yii\db\Command::query	SELECT * FROM `articoli_new` WHERE `id_articolo`='155'
11:43:41.124	0.8 ms	yii\db\Command::query	SELECT * FROM `articoli_new` WHERE `id_articolo`='398'
11:43:41.130	0.8 ms	yii\db\Command::query	SELECT * FROM `articoli_new` WHERE `id_articolo`='155'
11:43:41.095	0.8 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24907
11:43:41.087	0.8 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24908
11:43:41.105	0.8 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24903
11:43:41.076	0.8 ms	yii\db\Command::query	SELECT * FROM `db0_user` WHERE `id` IN (65, 11, 31)
11:43:41.117	0.8 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24899
11:43:41.121	0.8 ms	yii\db\Command::query	SELECT * FROM `articoli_new` WHERE `id_articolo`='155'
11:43:41.119	0.8 ms	yii\db\Command::query	SELECT * FROM `articoli_new` WHERE `id_articolo`='155'
11:43:41.138	0.8 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24892
11:43:41.103	0.8 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24904
11:43:41.129	0.8 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24895
11:43:41.086	0.8 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24909
11:43:41.116	0.8 ms	yii\db\Command::query	SELECT * FROM `articoli_new` WHERE `id_articolo`='1053'
11:43:41.104	0.8 ms	yii\db\Command::query	SELECT * FROM `articoli_new` WHERE `id_articolo`='580'
11:43:41.141	0.8 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24891
11:43:41.127	0.8 ms	yii\db\Command::query	SELECT * FROM `articoli_new` WHERE `id_articolo`='155'
11:43:41.142	0.8 ms	yii\db\Command::query	SELECT * FROM `articoli_new` WHERE `id_articolo`='155'
11:43:41.123	0.8 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24897
11:43:41.120	0.8 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24898
11:43:41.126	0.8 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24896
11:43:41.132	0.8 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24894
11:43:41.111	0.8 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24901
11:43:41.108	0.7 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24902
11:43:41.107	0.7 ms	yii\db\Command::query	SELECT * FROM `articoli_new` WHERE `id_articolo`='1425'
11:43:41.100	0.7 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24905
11:43:41.144	0.7 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24890
11:43:40.996	0.6 ms	yii\db\Command::query	SELECT * FROM `db0_ente` WHERE `id_ente`='1'