684663abbfdda: GET https://www.sanzioni.cloud/index.php/codicestrada/bollettario/viewall?id=1&idbollettario=9198&tipo=2&anno=2025&stato=11 at 2025-06-09 04:31:39 am by 93.51.208.125
Performance Profiling
Total processing time: 274 ms; Peak memory: 4.605 MB. Show Profiling Timeline
Total 74 items.
| Time | Duration | Category | Info |
|---|---|---|---|
| 04:31:39.813 | 2.2 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_bollettario` |
| 04:31:39.869 | 1.8 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `articoli_new` |
| 04:31:39.769 | 1.6 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db0_user` |
| 04:31:39.826 | 1.6 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_notifica` |
| 04:31:39.924 | 1.5 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_persona` |
| 04:31:39.892 | 1.5 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db0_comuni` |
| 04:31:39.832 | 1.5 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db0_ente` |
| 04:31:39.816 | 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_bollettario' AND kcu.table_name = 'db2_bollettario' |
| 04:31:39.768 | 1.4 ms | yii\db\Connection::open | Opening DB connection: mysql:host=localhost;dbname=sanzioni1_0 |
| 04:31:39.820 | 1.4 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_decurtazionepunti` |
| 04:31:39.848 | 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_docallegato' AND kcu.table_name = 'db2_docallegato' |
| 04:31:39.908 | 1.4 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_agente` |
| 04:31:39.822 | 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_decurtazionepunti' AND kcu.table_name = 'db2_decurtazionepunti' |
| 04:31:39.857 | 1.4 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_infrazione` |
| 04:31:39.828 | 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_notifica' AND kcu.table_name = 'db2_notifica' |
| 04:31:39.846 | 1.3 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_docallegato` |
| 04:31:39.876 | 1.3 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `istat2019` |
| 04:31:39.834 | 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 = 'db0_ente' AND kcu.table_name = 'db0_ente' |
| 04:31:39.853 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=9198 |
| 04:31:39.886 | 1.3 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_stradario` |
| 04:31:39.772 | 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 = 'db0_user' AND kcu.table_name = 'db0_user' |
| 04:31:39.946 | 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_verbaleazienda' AND kcu.table_name = 'db2_verbaleazienda' |
| 04:31:39.945 | 1.2 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_verbaleazienda` |
| 04:31:39.862 | 1.2 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_rateizzato` |
| 04:31:39.830 | 1.2 ms | yii\db\Command::query | SELECT * FROM `db2_notifica` WHERE `id_bollettario_notifica`='9198' |
| 04:31:39.844 | 1.2 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_docallegato` WHERE `id_bollettario_docallegato`='9198' |
| 04:31:39.918 | 1.2 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_proprietario` |
| 04:31:39.872 | 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 = 'articoli_new' AND kcu.table_name = 'articoli_new' |
| 04:31:39.900 | 1.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_sottoscritti` |
| 04:31:39.927 | 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_persona' AND kcu.table_name = 'db1_persona' |
| 04:31:39.864 | 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_rateizzato' AND kcu.table_name = 'db2_rateizzato' |
| 04:31:39.888 | 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_stradario' AND kcu.table_name = 'db1_stradario' |
| 04:31:39.932 | 1.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_verbaleveicolo` |
| 04:31:39.818 | 1.1 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`='9198' |
| 04:31:39.859 | 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' |
| 04:31:39.902 | 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_sottoscritti' AND kcu.table_name = 'db2_sottoscritti' |
| 04:31:39.910 | 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' |
| 04:31:39.877 | 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 = 'istat2019' AND kcu.table_name = 'istat2019' |
| 04:31:39.934 | 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_verbaleveicolo' AND kcu.table_name = 'db2_verbaleveicolo' |
| 04:31:39.919 | 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_proprietario' AND kcu.table_name = 'db2_proprietario' |
| 04:31:39.868 | 1.0 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='1496' |
| 04:31:39.956 | 1.0 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='1496' |
| 04:31:39.894 | 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_comuni' AND kcu.table_name = 'db0_comuni' |
| 04:31:39.921 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=9198) AND (`tipo_proprietario`=0) LIMIT 20 |
| 04:31:39.860 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE (`id_bollettario_infrazione`=9198) AND (`id_ente_infrazione`=1) |
| 04:31:39.879 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_notifica` WHERE `id_bollettario_notifica`=9198 ORDER BY `id_notifica` |
| 04:31:39.777 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=11 |
| 04:31:39.949 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=9198 |
| 04:31:39.953 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=9198 ORDER BY `id_infrazione` DESC LIMIT 15 |
| 04:31:39.931 | 0.9 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=9198 |
| 04:31:39.880 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE (`id_bollettario_infrazione`=9198) AND (`id_ente_infrazione`=1) |
| 04:31:39.938 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=9198) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20)) LIMIT 20 |
| 04:31:39.952 | 0.8 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=9198 |
| 04:31:39.940 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db1_persona` WHERE `id_persona`=8170 |
| 04:31:39.916 | 0.8 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=9198) AND (`tipo_proprietario`=0) |
| 04:31:39.875 | 0.8 ms | yii\db\Command::query | SELECT * FROM `istat2019` WHERE `id_articolo`=1496 |
| 04:31:39.836 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`=1 |
| 04:31:39.937 | 0.8 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=9198) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20)) |
| 04:31:39.903 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=9198 ORDER BY `id_sottoscritti` DESC LIMIT 15 |
| 04:31:39.889 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db1_stradario` WHERE `COD_VIA`=16 |
| 04:31:39.912 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=48 |
| 04:31:39.960 | 0.8 ms | yii\db\Command::query | SELECT * FROM `istat2019` WHERE `id_articolo`=1496 |
| 04:31:39.944 | 0.8 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_verbaleazienda` WHERE `id_bollettario_verbaleazienda`=9198 |
| 04:31:39.899 | 0.8 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=9198 |
| 04:31:39.907 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=35 |
| 04:31:39.865 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db2_rateizzato` WHERE `id_bollettario_rateizzato`=9198 |
| 04:31:39.895 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune`=72002 |
| 04:31:39.824 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db2_decurtazionepunti` WHERE `id_bollettario_decurtazionepunti`='9198' |
| 04:31:39.855 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`=1 |
| 04:31:39.923 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db1_persona` WHERE `id_persona`=8169 |
| 04:31:39.882 | 0.6 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=31 |
| 04:31:39.958 | 0.6 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_infrazione`=10096 |
| 04:31:39.961 | 0.6 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune` IS NULL |
| 04:31:39.883 | 0.6 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=31 |