Total processing time: 669 ms; Peak memory: 5.449 MB. Show Profiling Timeline
Time | Duration | Category | Info |
---|---|---|---|
12:54:35.593 | 67.3 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=24193 |
12:54:35.664 | 48.5 ms | yii\db\Command::query | SELECT * FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=24193 ORDER BY `id_sottoscritti` DESC LIMIT 15 |
12:54:35.804 | 33.3 ms | yii\db\Command::query | SELECT * FROM `db1_veicolo` WHERE `id_veicolo`=19857 |
12:54:35.723 | 32.4 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=24193) AND (`tipo_proprietario`=0) |
12:54:35.519 | 18.7 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_sanzioneacc` WHERE (`id_ente_sanzioneacc`='1') AND (`id_bollettario_sanzioneacc`='24193') |
12:54:35.495 | 16.8 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_docallegato` WHERE `id_bollettario_docallegato`='24193' |
12:54:35.452 | 16.2 ms | yii\db\Command::query | SELECT * FROM `istat2021` WHERE `id_articolo`=894 |
12:54:35.575 | 15.1 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune`=72040 |
12:54:35.763 | 14.7 ms | yii\db\Command::query | SELECT * FROM `db1_persona` WHERE `id_persona`=23836 |
12:54:35.787 | 7.6 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=24193 |
12:54:35.400 | 4.6 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_bollettario` |
12:54:35.798 | 3.6 ms | yii\db\Command::query | SELECT * FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=24193 LIMIT 20 |
12:54:35.367 | 3.4 ms | yii\db\Connection::open | Opening DB connection: mysql:host=localhost;dbname=sanzioni1_0 |
12:54:35.406 | 3.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' |
12:54:35.413 | 2.7 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db0_ente` |
12:54:35.442 | 2.7 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `articoli_new` |
12:54:35.371 | 2.6 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db0_user` |
12:54:35.409 | 2.4 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`='24193' |
12:54:35.421 | 2.3 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_decurtazionepunti` |
12:54:35.434 | 2.3 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_infrazione` |
12:54:35.538 | 2.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_sanzioneacc` |
12:54:35.423 | 2.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_decurtazionepunti' AND kcu.table_name = 'db2_decurtazionepunti' |
12:54:35.550 | 2.0 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_agente` |
12:54:35.437 | 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_infrazione' AND kcu.table_name = 'db2_infrazione' |
12:54:35.375 | 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 = 'db0_user' AND kcu.table_name = 'db0_user' |
12:54:35.483 | 1.9 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_nota` |
12:54:35.564 | 1.9 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_stradario` |
12:54:35.512 | 1.8 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_docallegato` |
12:54:35.778 | 1.8 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_persona` |
12:54:35.481 | 1.8 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_nota` WHERE (`id_ente_nota`='1') AND (`id_bollettario_nota`='24193') |
12:54:35.416 | 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_ente' AND kcu.table_name = 'db0_ente' |
12:54:35.428 | 1.7 ms | yii\db\Command::query | SELECT * FROM `db2_notifica` WHERE `id_bollettario_notifica`='24193' ORDER BY `id_notifica` DESC |
12:54:35.445 | 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' |
12:54:35.567 | 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' |
12:54:35.541 | 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_sanzioneacc' AND kcu.table_name = 'db2_sanzioneacc' |
12:54:35.468 | 1.7 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `istat2021` |
12:54:35.572 | 1.6 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db0_comuni` |
12:54:35.553 | 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_agente' AND kcu.table_name = 'db1_agente' |
12:54:35.486 | 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_nota' AND kcu.table_name = 'db2_nota' |
12:54:35.838 | 1.6 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_veicolo` |
12:54:35.418 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`='1' |
12:54:35.514 | 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_docallegato' AND kcu.table_name = 'db2_docallegato' |
12:54:35.426 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_decurtazionepunti` WHERE `id_bollettario_decurtazionepunti`='24193' |
12:54:35.380 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=11 |
12:54:35.561 | 1.4 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_nota` WHERE (`id_ente_nota`=1) AND (`id_bollettario_nota`=24193) |
12:54:35.877 | 1.4 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_notifica` |
12:54:35.543 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=31 |
12:54:35.556 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=24193 |
12:54:35.448 | 1.4 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='894' |
12:54:35.470 | 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 = 'istat2021' AND kcu.table_name = 'istat2021' |
12:54:35.439 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`='24193' |
12:54:35.545 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=31 |
12:54:35.548 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=51 |
12:54:35.758 | 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' |
12:54:35.569 | 1.2 ms | yii\db\Command::query | SELECT * FROM `db1_stradario` WHERE `COD_VIA`=652326 |
12:54:35.756 | 1.2 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_proprietario` |
12:54:35.891 | 1.2 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_rateizzato` |
12:54:35.781 | 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_persona' AND kcu.table_name = 'db1_persona' |
12:54:35.943 | 1.2 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24193 ORDER BY `id_infrazione` DESC LIMIT 15 |
12:54:35.796 | 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' |
12:54:35.661 | 1.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_sottoscritti` |
12:54:35.946 | 1.1 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='894' |
12:54:35.852 | 1.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_verbaleazienda` |
12:54:35.851 | 1.1 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_verbaleazienda` WHERE `id_bollettario_verbaleazienda`=24193 |
12:54:35.759 | 1.1 ms | yii\db\Command::query | SELECT * FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=24193) AND (`tipo_proprietario`=0) LIMIT 20 |
12:54:35.795 | 1.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_verbaleveicolo` |
12:54:35.854 | 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_verbaleazienda' AND kcu.table_name = 'db2_verbaleazienda' |
12:54:35.879 | 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_notifica' AND kcu.table_name = 'db2_notifica' |
12:54:35.662 | 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' |
12:54:35.953 | 1.0 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune`=72006 |
12:54:35.898 | 1.0 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE (`id_bollettario_infrazione`=24193) AND (`id_ente_infrazione`=1) |
12:54:35.559 | 1.0 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`=1 |
12:54:35.948 | 1.0 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_infrazione`=27295 |
12:54:35.918 | 1.0 ms | yii\db\Command::query | SELECT * FROM `db1_persona` WHERE `id_persona`=23836 |
12:54:35.840 | 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_veicolo' AND kcu.table_name = 'db1_veicolo' |
12:54:35.950 | 1.0 ms | yii\db\Command::query | SELECT * FROM `istat2021` WHERE `id_articolo`=894 |
12:54:35.893 | 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 = 'db2_rateizzato' AND kcu.table_name = 'db2_rateizzato' |
12:54:35.910 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=23 |
12:54:35.843 | 0.9 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=24193) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20)) |
12:54:35.906 | 0.9 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=24193 |
12:54:35.938 | 0.9 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24193 |
12:54:35.935 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=24193 |
12:54:35.860 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24193 ORDER BY `id_infrazione` DESC LIMIT 15 |
12:54:35.928 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=24193) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20)) LIMIT 20 |
12:54:35.907 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=24193 ORDER BY `id_sottoscritti` DESC LIMIT 15 |
12:54:35.856 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=24193 |
12:54:35.574 | 0.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_comuni' AND kcu.table_name = 'db0_comuni' |
12:54:35.875 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`='24193' |
12:54:35.930 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db1_persona` WHERE `id_persona`=23836 |
12:54:35.915 | 0.8 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=24193) AND (`tipo_proprietario`=0) |
12:54:35.912 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=51 |
12:54:35.846 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db1_persona` WHERE `id_persona`=23836 |
12:54:35.866 | 0.8 ms | yii\db\Command::query | SELECT * FROM `istat2021` WHERE `id_articolo`=894 |
12:54:35.886 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=24193 |
12:54:35.889 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE (`id_bollettario_infrazione`=24193) AND (`id_ente_infrazione`=1) |
12:54:35.863 | 0.8 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='894' |
12:54:35.714 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=23 |
12:54:35.904 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune`=72040 |
12:54:35.844 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=24193) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20)) LIMIT 20 |
12:54:35.916 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=24193) AND (`tipo_proprietario`=0) LIMIT 20 |
12:54:35.902 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db1_stradario` WHERE `COD_VIA`=652326 |
12:54:35.927 | 0.8 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=24193) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20)) |
12:54:35.921 | 0.8 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=24193 |
12:54:35.884 | 0.8 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_docallegato` WHERE `id_bollettario_docallegato`='24193' |
12:54:35.717 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=51 |
12:54:35.895 | 0.7 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='894' |
12:54:35.896 | 0.7 ms | yii\db\Command::query | SELECT * FROM `istat2021` WHERE `id_articolo`=894 |
12:54:35.868 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune`=72006 |
12:54:35.922 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=24193 LIMIT 20 |
12:54:35.888 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`=1 |
12:54:35.882 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`=1 |
12:54:35.894 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db2_rateizzato` WHERE `id_bollettario_rateizzato`=24193 |
12:54:35.933 | 0.7 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_verbaleazienda` WHERE `id_bollettario_verbaleazienda`=24193 |
12:54:35.859 | 0.7 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24193 |
12:54:35.876 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db2_decurtazionepunti` WHERE `id_bollettario_decurtazionepunti`='24193' |
12:54:35.864 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_infrazione`=27295 |
12:54:35.924 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db1_veicolo` WHERE `id_veicolo`=19857 |
12:54:35.881 | 0.6 ms | yii\db\Command::query | SELECT * FROM `db2_notifica` WHERE `id_bollettario_notifica`='24193' |
12:54:35.899 | 0.6 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=31 |
12:54:35.901 | 0.6 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=31 |