Performance Profiling

Total processing time: 256 ms; Peak memory: 3.470 MB. Show Profiling Timeline

Total 57 items.

Time	Duration	Category	Info

12:33:59.042	15.4 ms	yii\db\Command::query	SELECT COUNT(*) FROM `db2_bollettario` WHERE `db2_bollettario`.`id_ente_bollettario`='1'
12:33:58.949	3.1 ms	yii\db\Connection::open	Opening DB connection: mysql:host=localhost;dbname=sanzioni1_0
12:33:59.002	2.1 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `db2_bollettario`
12:33:59.088	1.9 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `articoli_new`
12:33:59.058	1.8 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
12:33:58.952	1.8 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `db0_user`
12:33:58.959	1.5 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'
12:33:59.066	1.5 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `db1_agente`
12:33:59.079	1.5 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `db2_infrazione`
12:33:59.065	1.3 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)
12:33:59.005	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'
12:33:58.992	1.2 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `db0_ente`
12:33:59.081	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_infrazione' AND kcu.table_name = 'db2_infrazione'
12:33:59.086	1.1 ms	yii\db\Command::query	SELECT * FROM `articoli_new` WHERE `id_articolo`='1213'
12:33:59.068	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'
12:33:59.106	1.0 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24902
12:33:59.091	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'
12:33:59.108	1.0 ms	yii\db\Command::query	SELECT * FROM `articoli_new` WHERE `id_articolo`='155'
12:33:58.994	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 = 'db0_ente' AND kcu.table_name = 'db0_ente'
12:33:59.098	1.0 ms	yii\db\Command::query	SELECT * FROM `articoli_new` WHERE `id_articolo`='155'
12:33:59.117	0.9 ms	yii\db\Command::query	SELECT * FROM `articoli_new` WHERE `id_articolo`='155'
12:33:58.967	0.9 ms	yii\db\Command::query	SELECT * FROM `db0_user` WHERE `id`=59
12:33:59.094	0.9 ms	yii\db\Command::query	SELECT * FROM `articoli_new` WHERE `id_articolo`='1213'
12:33:59.131	0.9 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24894
12:33:59.097	0.9 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24905
12:33:59.110	0.9 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24901
12:33:59.134	0.9 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24893
12:33:59.113	0.9 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24900
12:33:59.071	0.9 ms	yii\db\Command::query	SELECT * FROM `db0_user` WHERE `id` IN (65, 11, 31)
12:33:59.102	0.9 ms	yii\db\Command::query	SELECT * FROM `articoli_new` WHERE `id_articolo`='580'
12:33:59.114	0.9 ms	yii\db\Command::query	SELECT * FROM `articoli_new` WHERE `id_articolo`='1053'
12:33:59.116	0.9 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24899
12:33:59.111	0.9 ms	yii\db\Command::query	SELECT * FROM `articoli_new` WHERE `id_articolo`='1053'
12:33:59.083	0.8 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24909
12:33:59.100	0.8 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24904
12:33:59.103	0.8 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24903
12:33:59.129	0.8 ms	yii\db\Command::query	SELECT * FROM `articoli_new` WHERE `id_articolo`='155'
12:33:59.084	0.8 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24908
12:33:59.132	0.8 ms	yii\db\Command::query	SELECT * FROM `articoli_new` WHERE `id_articolo`='398'
12:33:59.073	0.8 ms	yii\db\Command::query	SELECT * FROM `db0_user` WHERE `id` IN (65, 11, 31)
12:33:59.105	0.8 ms	yii\db\Command::query	SELECT * FROM `articoli_new` WHERE `id_articolo`='1425'
12:33:59.128	0.8 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24895
12:33:59.140	0.8 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24891
12:33:59.123	0.8 ms	yii\db\Command::query	SELECT * FROM `articoli_new` WHERE `id_articolo`='398'
12:33:59.135	0.8 ms	yii\db\Command::query	SELECT * FROM `articoli_new` WHERE `id_articolo`='155'
12:33:59.093	0.8 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24907
12:33:59.138	0.8 ms	yii\db\Command::query	SELECT * FROM `articoli_new` WHERE `id_articolo`='155'
12:33:59.137	0.8 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24892
12:33:59.119	0.8 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24898
12:33:59.122	0.8 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24897
12:33:59.125	0.8 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24896
12:33:59.141	0.8 ms	yii\db\Command::query	SELECT * FROM `articoli_new` WHERE `id_articolo`='155'
12:33:59.120	0.8 ms	yii\db\Command::query	SELECT * FROM `articoli_new` WHERE `id_articolo`='155'
12:33:59.126	0.8 ms	yii\db\Command::query	SELECT * FROM `articoli_new` WHERE `id_articolo`='155'
12:33:59.142	0.7 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24890
12:33:58.995	0.7 ms	yii\db\Command::query	SELECT * FROM `db0_ente` WHERE `id_ente`='1'
12:33:59.096	0.7 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24906