686286be0fa6c: GET https://www.sanzioni.cloud/index.php/codicestrada/docallegato/view?id=1&idbollettario=9374&iddoc=8779 at 2025-06-30 12:44:46 pm by 93.51.208.125
Performance Profiling
Total processing time: 472 ms; Peak memory: 4.339 MB. Show Profiling Timeline
Total 84 items.
| Time | Duration | Category | Info |
|---|---|---|---|
| 12:44:46.183 | 62.5 ms | yii\db\Command::query | SELECT * FROM `db2_alertdoc` WHERE (`id_ente_alertdoc`=1) AND (`id_bollettario_alertdoc`=9374) |
| 12:44:46.175 | 4.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_alertdoc` |
| 12:44:46.096 | 3.2 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_bollettario` |
| 12:44:46.043 | 3.1 ms | yii\db\Connection::open | Opening DB connection: mysql:host=localhost;dbname=sanzioni1_0 |
| 12:44:46.179 | 3.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_alertdoc' AND kcu.table_name = 'db2_alertdoc' |
| 12:44:46.270 | 2.5 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_notifica` |
| 12:44:46.317 | 2.4 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `articoli_new` |
| 12:44:46.386 | 2.3 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_persona` |
| 12:44:46.113 | 2.2 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_docallegato` |
| 12:44:46.262 | 2.2 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_decurtazionepunti` |
| 12:44:46.299 | 2.2 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_infrazione` |
| 12:44:46.343 | 2.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db0_comuni` |
| 12:44:46.424 | 2.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_verbaleazienda` |
| 12:44:46.116 | 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 = 'db2_docallegato' AND kcu.table_name = 'db2_docallegato' |
| 12:44:46.046 | 2.0 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db0_user` |
| 12:44:46.376 | 2.0 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_proprietario` |
| 12:44:46.306 | 2.0 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_rateizzato` |
| 12:44:46.101 | 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 = 'db2_bollettario' AND kcu.table_name = 'db2_bollettario' |
| 12:44:46.106 | 1.9 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db0_ente` |
| 12:44:46.365 | 1.9 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_agente` |
| 12:44:46.309 | 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_rateizzato' AND kcu.table_name = 'db2_rateizzato' |
| 12:44:46.398 | 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_verbaleveicolo' AND kcu.table_name = 'db2_verbaleveicolo' |
| 12:44:46.406 | 1.8 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_veicolo` |
| 12:44:46.108 | 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 = 'db0_ente' AND kcu.table_name = 'db0_ente' |
| 12:44:46.439 | 1.8 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='1425' |
| 12:44:46.325 | 1.8 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `istat2019` |
| 12:44:46.336 | 1.7 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_stradario` |
| 12:44:46.444 | 1.7 ms | yii\db\Command::query | SELECT * FROM `istat2019` WHERE `id_articolo`=1425 |
| 12:44:46.409 | 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' |
| 12:44:46.265 | 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_decurtazionepunti' AND kcu.table_name = 'db2_decurtazionepunti' |
| 12:44:46.304 | 1.7 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE (`id_bollettario_infrazione`=9374) AND (`id_ente_infrazione`=1) |
| 12:44:46.050 | 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_user' AND kcu.table_name = 'db0_user' |
| 12:44:46.389 | 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_persona' AND kcu.table_name = 'db1_persona' |
| 12:44:46.396 | 1.7 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_verbaleveicolo` |
| 12:44:46.118 | 1.7 ms | yii\db\Command::query | SELECT * FROM `db2_docallegato` WHERE `id_docallegato`='8779' |
| 12:44:46.315 | 1.7 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='1425' |
| 12:44:46.273 | 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_notifica' AND kcu.table_name = 'db2_notifica' |
| 12:44:46.379 | 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' |
| 12:44:46.338 | 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_stradario' AND kcu.table_name = 'db1_stradario' |
| 12:44:46.302 | 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_infrazione' AND kcu.table_name = 'db2_infrazione' |
| 12:44:46.413 | 1.6 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=9374) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20)) |
| 12:44:46.356 | 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_sottoscritti' AND kcu.table_name = 'db2_sottoscritti' |
| 12:44:46.259 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`='9374' |
| 12:44:46.103 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`='9374' |
| 12:44:46.329 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE (`id_bollettario_infrazione`=9374) AND (`id_ente_infrazione`=1) |
| 12:44:46.441 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_infrazione`=10276 |
| 12:44:46.267 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_decurtazionepunti` WHERE `id_bollettario_decurtazionepunti`='9374' |
| 12:44:46.447 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune`=72006 |
| 12:44:46.358 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=9374 ORDER BY `id_sottoscritti` DESC LIMIT 15 |
| 12:44:46.353 | 1.5 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=9374 |
| 12:44:46.430 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=9374 |
| 12:44:46.435 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=9374 ORDER BY `id_infrazione` DESC LIMIT 15 |
| 12:44:46.288 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_docallegato` WHERE `id_bollettario_docallegato`='9374' LIMIT 20 |
| 12:44:46.394 | 1.5 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=9374 |
| 12:44:46.346 | 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_comuni' AND kcu.table_name = 'db0_comuni' |
| 12:44:46.384 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db1_persona` WHERE `id_persona`=8366 |
| 12:44:46.275 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db2_notifica` WHERE `id_bollettario_notifica`='9374' |
| 12:44:46.374 | 1.4 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=9374) AND (`tipo_proprietario`=0) |
| 12:44:46.294 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=9374 |
| 12:44:46.405 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db1_veicolo` WHERE `id_veicolo`=7794 |
| 12:44:46.363 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=32 |
| 12:44:46.285 | 1.4 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_docallegato` WHERE `id_bollettario_docallegato`='9374' |
| 12:44:46.327 | 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 = 'istat2019' AND kcu.table_name = 'istat2019' |
| 12:44:46.323 | 1.4 ms | yii\db\Command::query | SELECT * FROM `istat2019` WHERE `id_articolo`=1425 |
| 12:44:46.415 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=9374) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20)) LIMIT 20 |
| 12:44:46.355 | 1.4 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_sottoscritti` |
| 12:44:46.370 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=42 |
| 12:44:46.427 | 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 = 'db2_verbaleazienda' AND kcu.table_name = 'db2_verbaleazienda' |
| 12:44:46.381 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=9374) AND (`tipo_proprietario`=0) LIMIT 20 |
| 12:44:46.333 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=11 |
| 12:44:46.311 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db2_rateizzato` WHERE `id_bollettario_rateizzato`=9374 |
| 12:44:46.418 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db1_persona` WHERE `id_persona`=8367 |
| 12:44:46.401 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=9374 LIMIT 20 |
| 12:44:46.296 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`=1 |
| 12:44:46.110 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`='1' |
| 12:44:46.320 | 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 = 'articoli_new' AND kcu.table_name = 'articoli_new' |
| 12:44:46.367 | 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 = 'db1_agente' AND kcu.table_name = 'db1_agente' |
| 12:44:46.341 | 1.2 ms | yii\db\Command::query | SELECT * FROM `db1_stradario` WHERE `COD_VIA`=144 |
| 12:44:46.348 | 1.1 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune`=89005 |
| 12:44:46.277 | 1.1 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`=1 |
| 12:44:46.055 | 1.0 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=5 |
| 12:44:46.433 | 1.0 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=9374 |
| 12:44:46.423 | 1.0 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_verbaleazienda` WHERE `id_bollettario_verbaleazienda`=9374 |
| 12:44:46.332 | 0.4 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=11 |