687a124533a6f: GET https://www.sanzioni.cloud/index.php/codicestrada/bollettario/view?id=1&idbollettario=22396 at 2025-07-18 09:22:13 am by 93.51.208.125
Performance Profiling
Total processing time: 1,592 ms; Peak memory: 5.678 MB. Show Profiling Timeline
Total 129 items.
| Time | Duration | Category | Info |
|---|---|---|---|
| 09:22:13.686 | 110.4 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_sanzioneacc` WHERE (`id_ente_sanzioneacc`='1') AND (`id_bollettario_sanzioneacc`='22396') |
| 09:22:13.497 | 76.1 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_nota` WHERE (`id_ente_nota`='1') AND (`id_bollettario_nota`='22396') |
| 09:22:13.322 | 56.7 ms | yii\db\Command::query | SELECT * FROM `db2_notifica` WHERE `id_bollettario_notifica`='22396' ORDER BY `id_notifica` DESC |
| 09:22:14.125 | 55.9 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=22396) AND (`tipo_proprietario`=0) |
| 09:22:14.262 | 55.4 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=22396 |
| 09:22:14.443 | 51.2 ms | yii\db\Command::query | SELECT * FROM `db1_azienda` WHERE `id_azienda`=2752 |
| 09:22:13.254 | 50.9 ms | yii\db\Command::query | SELECT * FROM `db2_decurtazionepunti` WHERE `id_bollettario_decurtazionepunti`='22396' |
| 09:22:13.974 | 44.1 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune`=72033 |
| 09:22:13.587 | 42.7 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_docallegato` WHERE `id_bollettario_docallegato`='22396' |
| 09:22:14.378 | 41.3 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_verbaleazienda` WHERE `id_bollettario_verbaleazienda`=22396 |
| 09:22:14.204 | 33.1 ms | yii\db\Command::query | SELECT * FROM `db1_persona` WHERE `id_persona`=21993 |
| 09:22:14.581 | 26.5 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE (`id_bollettario_infrazione`=22396) AND (`id_ente_infrazione`=1) |
| 09:22:13.414 | 24.6 ms | yii\db\Command::query | SELECT * FROM `istat2021` WHERE `id_articolo`=366 |
| 09:22:13.638 | 24.4 ms | yii\db\Command::query | SELECT * FROM `db2_docallegato` WHERE `id_bollettario_docallegato`='22396' LIMIT 20 |
| 09:22:14.613 | 23.5 ms | yii\db\Command::query | SELECT * FROM `db2_rateizzato` WHERE `id_bollettario_rateizzato`=22396 |
| 09:22:14.042 | 23.2 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=22396 |
| 09:22:14.331 | 23.2 ms | yii\db\Command::query | SELECT * FROM `db1_veicolo` WHERE `id_veicolo`=18425 |
| 09:22:13.943 | 22.1 ms | yii\db\Command::query | SELECT * FROM `db1_stradario` WHERE `COD_VIA`=14703 |
| 09:22:14.071 | 18.1 ms | yii\db\Command::query | SELECT * FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=22396 ORDER BY `id_sottoscritti` DESC LIMIT 15 |
| 09:22:14.423 | 13.2 ms | yii\db\Command::query | SELECT * FROM `db2_verbaleazienda` WHERE `id_bollettario_verbaleazienda`=22396 LIMIT 20 |
| 09:22:14.321 | 4.8 ms | yii\db\Command::query | SELECT * FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=22396 LIMIT 20 |
| 09:22:13.402 | 2.6 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `articoli_new` |
| 09:22:13.393 | 2.5 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_infrazione` |
| 09:22:13.969 | 2.5 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db0_comuni` |
| 09:22:13.223 | 2.4 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_bollettario` |
| 09:22:13.939 | 2.4 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_stradario` |
| 09:22:13.631 | 2.4 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_docallegato` |
| 09:22:13.192 | 2.3 ms | yii\db\Connection::open | Opening DB connection: mysql:host=localhost;dbname=sanzioni1_0 |
| 09:22:13.797 | 2.3 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_sanzioneacc` |
| 09:22:13.379 | 2.2 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_notifica` |
| 09:22:13.634 | 2.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_docallegato' AND kcu.table_name = 'db2_docallegato' |
| 09:22:13.811 | 2.1 ms | yii\db\Command::query | SELECT * FROM `db2_sanzioneacc` WHERE (`id_ente_sanzioneacc`='1') AND (`id_bollettario_sanzioneacc`='22396') ORDER BY `id_sanzioneacc` DESC LIMIT 20 |
| 09:22:13.873 | 2.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_agente` |
| 09:22:13.250 | 2.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_decurtazionepunti` |
| 09:22:13.439 | 2.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `istat2021` |
| 09:22:13.574 | 2.0 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_nota` |
| 09:22:13.876 | 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 = 'db1_agente' AND kcu.table_name = 'db1_agente' |
| 09:22:14.068 | 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_sottoscritti' AND kcu.table_name = 'db2_sottoscritti' |
| 09:22:13.800 | 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_sanzioneacc' AND kcu.table_name = 'db2_sanzioneacc' |
| 09:22:14.610 | 1.8 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_rateizzato` |
| 09:22:13.576 | 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_nota' AND kcu.table_name = 'db2_nota' |
| 09:22:13.382 | 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' |
| 09:22:13.397 | 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_infrazione' AND kcu.table_name = 'db2_infrazione' |
| 09:22:14.066 | 1.7 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_sottoscritti` |
| 09:22:13.407 | 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 = 'articoli_new' AND kcu.table_name = 'articoli_new' |
| 09:22:13.941 | 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_stradario' AND kcu.table_name = 'db1_stradario' |
| 09:22:13.920 | 1.6 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_nota` WHERE (`id_ente_nota`=1) AND (`id_bollettario_nota`=22396) |
| 09:22:13.399 | 1.6 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`='22396' |
| 09:22:13.441 | 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' |
| 09:22:14.237 | 1.6 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_persona` |
| 09:22:13.972 | 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' |
| 09:22:13.252 | 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_decurtazionepunti' AND kcu.table_name = 'db2_decurtazionepunti' |
| 09:22:13.230 | 1.5 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db0_ente` |
| 09:22:13.915 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=22396 |
| 09:22:13.409 | 1.5 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='366' |
| 09:22:13.871 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=18 |
| 09:22:14.115 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=18 |
| 09:22:13.195 | 1.4 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db0_user` |
| 09:22:13.861 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=52 |
| 09:22:14.109 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=21 |
| 09:22:13.917 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`=1 |
| 09:22:14.112 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=67 |
| 09:22:13.226 | 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_bollettario' AND kcu.table_name = 'db2_bollettario' |
| 09:22:13.859 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=52 |
| 09:22:13.232 | 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' |
| 09:22:13.866 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=52 |
| 09:22:14.354 | 1.3 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_veicolo` |
| 09:22:14.494 | 1.3 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_azienda` |
| 09:22:13.198 | 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_user' AND kcu.table_name = 'db0_user' |
| 09:22:14.420 | 1.2 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_verbaleazienda` |
| 09:22:13.867 | 1.2 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=52 |
| 09:22:14.182 | 1.2 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_proprietario` |
| 09:22:14.183 | 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_proprietario' AND kcu.table_name = 'db2_proprietario' |
| 09:22:14.240 | 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' |
| 09:22:14.496 | 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_azienda' AND kcu.table_name = 'db1_azienda' |
| 09:22:14.572 | 1.1 ms | yii\db\Command::query | SELECT * FROM `db2_docallegato` WHERE `id_bollettario_docallegato`='22396' LIMIT 20 |
| 09:22:14.318 | 1.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_verbaleveicolo` |
| 09:22:14.517 | 1.1 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=22396 |
| 09:22:14.356 | 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_veicolo' AND kcu.table_name = 'db1_veicolo' |
| 09:22:14.319 | 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_verbaleveicolo' AND kcu.table_name = 'db2_verbaleveicolo' |
| 09:22:14.522 | 1.0 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=22396 ORDER BY `id_infrazione` DESC LIMIT 15 |
| 09:22:14.422 | 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_verbaleazienda' AND kcu.table_name = 'db2_verbaleazienda' |
| 09:22:13.228 | 1.0 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`='22396' |
| 09:22:14.640 | 1.0 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE (`id_bollettario_infrazione`=22396) AND (`id_ente_infrazione`=1) |
| 09:22:13.234 | 1.0 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`='1' |
| 09:22:14.612 | 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_rateizzato' AND kcu.table_name = 'db2_rateizzato' |
| 09:22:14.549 | 1.0 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='366' |
| 09:22:14.520 | 0.9 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=22396 |
| 09:22:14.185 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=22396) AND (`tipo_proprietario`=0) LIMIT 20 |
| 09:22:14.567 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_notifica` WHERE `id_bollettario_notifica`='22396' |
| 09:22:14.564 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`='22396' |
| 09:22:14.648 | 0.9 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=22396 |
| 09:22:13.203 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=8 |
| 09:22:14.682 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=22396 ORDER BY `id_infrazione` DESC LIMIT 15 |
| 09:22:14.688 | 0.9 ms | yii\db\Command::query | SELECT * FROM `istat2021` WHERE `id_articolo`=366 |
| 09:22:14.555 | 0.9 ms | yii\db\Command::query | SELECT * FROM `istat2021` WHERE `id_articolo`=366 |
| 09:22:14.359 | 0.9 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=22396) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20)) |
| 09:22:14.662 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db1_persona` WHERE `id_persona`=21993 |
| 09:22:14.685 | 0.8 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='366' |
| 09:22:14.675 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_verbaleazienda` WHERE `id_bollettario_verbaleazienda`=22396 LIMIT 20 |
| 09:22:14.578 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=22396 |
| 09:22:14.571 | 0.8 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_docallegato` WHERE `id_bollettario_docallegato`='22396' |
| 09:22:14.665 | 0.8 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=22396 |
| 09:22:14.674 | 0.8 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_verbaleazienda` WHERE `id_bollettario_verbaleazienda`=22396 |
| 09:22:14.652 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=21 |
| 09:22:14.679 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=22396 |
| 09:22:14.637 | 0.8 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='366' |
| 09:22:14.650 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=22396 ORDER BY `id_sottoscritti` DESC LIMIT 15 |
| 09:22:14.639 | 0.8 ms | yii\db\Command::query | SELECT * FROM `istat2021` WHERE `id_articolo`=366 |
| 09:22:14.681 | 0.8 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=22396 |
| 09:22:14.550 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_infrazione`=25139 |
| 09:22:14.557 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune`=72006 |
| 09:22:14.660 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=22396) AND (`tipo_proprietario`=0) LIMIT 20 |
| 09:22:14.656 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=18 |
| 09:22:14.659 | 0.8 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=22396) AND (`tipo_proprietario`=0) |
| 09:22:14.671 | 0.7 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=22396) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20)) |
| 09:22:14.666 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=22396 LIMIT 20 |
| 09:22:14.566 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db2_decurtazionepunti` WHERE `id_bollettario_decurtazionepunti`='22396' |
| 09:22:14.686 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_infrazione`=25139 |
| 09:22:14.646 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune`=72033 |
| 09:22:14.654 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=67 |
| 09:22:14.642 | 0.6 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=52 |
| 09:22:14.643 | 0.6 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=52 |
| 09:22:14.668 | 0.6 ms | yii\db\Command::query | SELECT * FROM `db1_veicolo` WHERE `id_veicolo`=18425 |
| 09:22:14.677 | 0.6 ms | yii\db\Command::query | SELECT * FROM `db1_azienda` WHERE `id_azienda`=2752 |
| 09:22:14.690 | 0.6 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune`=72006 |
| 09:22:14.568 | 0.6 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`=1 |
| 09:22:14.645 | 0.6 ms | yii\db\Command::query | SELECT * FROM `db1_stradario` WHERE `COD_VIA`=14703 |
| 09:22:14.579 | 0.6 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`=1 |