Performance Profiling

Total processing time: 549 ms; Peak memory: 4.773 MB. Show Profiling Timeline

Total 87 items.

Time	Duration	Category	Info

10:17:29.763	72.1 ms	yii\db\Command::query	SELECT COUNT(*) FROM `db2_verbaleazienda` WHERE (`id_ente_verbaleazienda`=1) AND (`id_bollettario_verbaleazienda`=24800)
10:17:29.691	21.3 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `db2_proprietario`
10:17:29.836	11.1 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `db2_verbaleazienda`
10:17:29.945	2.7 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `articoli_new`
10:17:29.613	2.3 ms	yii\db\Connection::open	Opening DB connection: mysql:host=localhost;dbname=sanzioni1_0
10:17:29.721	2.2 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `db1_persona`
10:17:29.973	2.2 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `db0_comuni`
10:17:29.887	2.1 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `db2_notifica`
10:17:29.915	2.0 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `db2_docallegato`
10:17:29.965	2.0 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `db1_stradario`
10:17:29.929	2.0 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `db2_infrazione`
10:17:29.999	1.9 ms	yii\db\Command::query	SELECT * FROM `db1_agente` WHERE `id_agente`=42
10:17:29.847	1.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 = 'db2_verbaleazienda' AND kcu.table_name = 'db2_verbaleazienda'
10:17:29.885	1.9 ms	yii\db\Command::query	SELECT COUNT(*) FROM `db2_notifica` WHERE (`id_ente_notifica`='1') AND (`id_bollettario_notifica`='24800')
10:17:30.021	1.8 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `db1_veicolo`
10:17:29.953	1.8 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `istat2021`
10:17:29.652	1.8 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `db2_bollettario`
10:17:29.890	1.8 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_notifica' AND kcu.table_name = 'db2_notifica'
10:17:29.917	1.8 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_docallegato' AND kcu.table_name = 'db2_docallegato'
10:17:29.901	1.8 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_decurtazionepunti' AND kcu.table_name = 'db2_decurtazionepunti'
10:17:29.994	1.8 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `db1_agente`
10:17:29.986	1.7 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_sottoscritti' AND kcu.table_name = 'db2_sottoscritti'
10:17:29.899	1.7 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `db2_decurtazionepunti`
10:17:29.976	1.7 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_comuni' AND kcu.table_name = 'db0_comuni'
10:17:29.688	1.7 ms	yii\db\Command::query	SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_ente_proprietario`=1) AND (`id_bollettario_proprietario`=24800)
10:17:30.024	1.7 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_veicolo' AND kcu.table_name = 'db1_veicolo'
10:17:29.984	1.6 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `db2_sottoscritti`
10:17:29.713	1.6 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_proprietario' AND kcu.table_name = 'db2_proprietario'
10:17:29.724	1.6 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_persona' AND kcu.table_name = 'db1_persona'
10:17:29.958	1.6 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE (`id_bollettario_infrazione`=24800) AND (`id_ente_infrazione`=1)
10:17:29.715	1.6 ms	yii\db\Command::query	SELECT * FROM `db2_proprietario` WHERE (`id_ente_proprietario`=1) AND (`id_bollettario_proprietario`=24800) LIMIT 20
10:17:29.934	1.6 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE (`id_bollettario_infrazione`=24800) AND (`id_ente_infrazione`=1)
10:17:29.936	1.6 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `db2_rateizzato`
10:17:29.938	1.6 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_rateizzato' AND kcu.table_name = 'db2_rateizzato'
10:17:29.956	1.6 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 = 'istat2021' AND kcu.table_name = 'istat2021'
10:17:30.015	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 = 'db2_verbaleveicolo' AND kcu.table_name = 'db2_verbaleveicolo'
10:17:29.719	1.5 ms	yii\db\Command::query	SELECT * FROM `db1_persona` WHERE `id_persona`=24429
10:17:29.925	1.5 ms	yii\db\Command::query	SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=24800
10:17:29.968	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 = 'db1_stradario' AND kcu.table_name = 'db1_stradario'
10:17:30.028	1.5 ms	yii\db\Command::query	SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=24800) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20))
10:17:29.943	1.5 ms	yii\db\Command::query	SELECT * FROM `articoli_new` WHERE `id_articolo`='1425'
10:17:29.920	1.4 ms	yii\db\Command::query	SELECT * FROM `db2_docallegato` WHERE `id_bollettario_docallegato`='24800' LIMIT 20
10:17:29.940	1.4 ms	yii\db\Command::query	SELECT * FROM `db2_rateizzato` WHERE `id_bollettario_rateizzato`=24800
10:17:29.906	1.4 ms	yii\db\Command::query	SELECT * FROM `db2_notifica` WHERE `id_bollettario_notifica`='24800'
10:17:29.992	1.4 ms	yii\db\Command::query	SELECT * FROM `db1_agente` WHERE `id_agente`=61
10:17:29.949	1.4 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'
10:17:29.978	1.4 ms	yii\db\Command::query	SELECT * FROM `db0_comuni` WHERE `id_comune`=72020
10:17:29.952	1.4 ms	yii\db\Command::query	SELECT * FROM `istat2021` WHERE `id_articolo`=1425
10:17:29.913	1.4 ms	yii\db\Command::query	SELECT COUNT(*) FROM `db2_docallegato` WHERE `id_bollettario_docallegato`='24800'
10:17:29.982	1.4 ms	yii\db\Command::query	SELECT COUNT(*) FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=24800
10:17:29.970	1.4 ms	yii\db\Command::query	SELECT * FROM `db1_stradario` WHERE `COD_VIA`=231
10:17:29.962	1.3 ms	yii\db\Command::query	SELECT * FROM `db0_user` WHERE `id`=11
10:17:29.988	1.3 ms	yii\db\Command::query	SELECT * FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=24800 ORDER BY `id_sottoscritti` DESC LIMIT 15
10:17:29.927	1.3 ms	yii\db\Command::query	SELECT * FROM `db0_ente` WHERE `id_ente`=1
10:17:29.997	1.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 = 'db1_agente' AND kcu.table_name = 'db1_agente'
10:17:29.904	1.3 ms	yii\db\Command::query	SELECT * FROM `db2_decurtazionepunti` WHERE `id_bollettario_decurtazionepunti`='24800'
10:17:29.932	1.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 = 'db2_infrazione' AND kcu.table_name = 'db2_infrazione'
10:17:29.615	1.2 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `db0_user`
10:17:30.012	1.2 ms	yii\db\Command::query	SELECT COUNT(*) FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=24800
10:17:29.669	1.2 ms	yii\db\Command::query	SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=24800
10:17:29.907	1.2 ms	yii\db\Command::query	SELECT * FROM `db0_ente` WHERE `id_ente`=1
10:17:30.004	1.2 ms	yii\db\Command::query	SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=24800) AND (`tipo_proprietario`=0)
10:17:29.655	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'
10:17:29.659	1.1 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `db0_ente`
10:17:29.618	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_user' AND kcu.table_name = 'db0_user'
10:17:30.017	1.0 ms	yii\db\Command::query	SELECT * FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=24800 LIMIT 20
10:17:30.006	1.0 ms	yii\db\Command::query	SELECT * FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=24800) AND (`tipo_proprietario`=0) LIMIT 20
10:17:30.042	1.0 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24800 ORDER BY `id_infrazione` DESC LIMIT 15
10:17:30.030	1.0 ms	yii\db\Command::query	SELECT * FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=24800) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20)) LIMIT 20
10:17:30.020	1.0 ms	yii\db\Command::query	SELECT * FROM `db1_veicolo` WHERE `id_veicolo`=20341
10:17:30.014	1.0 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `db2_verbaleveicolo`
10:17:29.960	1.0 ms	yii\db\Command::query	SELECT * FROM `db0_user` WHERE `id`=11
10:17:29.897	0.9 ms	yii\db\Command::query	SELECT * FROM `db2_bollettario` WHERE `id_bollettario`='24800'
10:17:30.038	0.9 ms	yii\db\Command::query	SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=24800
10:17:29.660	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'
10:17:30.008	0.8 ms	yii\db\Command::query	SELECT * FROM `db1_persona` WHERE `id_persona`=24429
10:17:30.045	0.8 ms	yii\db\Command::query	SELECT * FROM `articoli_new` WHERE `id_articolo`='1425'
10:17:30.046	0.8 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE `id_infrazione`=28071
10:17:30.041	0.8 ms	yii\db\Command::query	SELECT COUNT(*) FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24800
10:17:29.657	0.8 ms	yii\db\Command::query	SELECT * FROM `db2_bollettario` WHERE `id_bollettario`='24800'
10:17:29.622	0.8 ms	yii\db\Command::query	SELECT * FROM `db0_user` WHERE `id`=31
10:17:30.033	0.7 ms	yii\db\Command::query	SELECT * FROM `db1_persona` WHERE `id_persona`=24429
10:17:30.049	0.7 ms	yii\db\Command::query	SELECT * FROM `istat2021` WHERE `id_articolo`=1425
10:17:30.036	0.7 ms	yii\db\Command::query	SELECT COUNT(*) FROM `db2_verbaleazienda` WHERE `id_bollettario_verbaleazienda`=24800
10:17:29.670	0.7 ms	yii\db\Command::query	SELECT * FROM `db0_ente` WHERE `id_ente`=1
10:17:30.051	0.7 ms	yii\db\Command::query	SELECT * FROM `db0_comuni` WHERE `id_comune`=72020
10:17:29.661	0.6 ms	yii\db\Command::query	SELECT * FROM `db0_ente` WHERE `id_ente`='1'