Total processing time: 816 ms; Peak memory: 5.574 MB. Show Profiling Timeline
Time | Duration | Category | Info |
---|---|---|---|
09:17:04.534 | 57.3 ms | yii\db\Command::query | SELECT * FROM `db2_notifica` WHERE `id_bollettario_notifica`='24800' ORDER BY `id_notifica` DESC |
09:17:05.087 | 42.8 ms | yii\db\Command::query | SELECT * FROM `db2_notifica` WHERE `id_bollettario_notifica`='24800' |
09:17:04.667 | 38.2 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_docallegato` |
09:17:04.640 | 25.9 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_docallegato` WHERE `id_bollettario_docallegato`='24800' |
09:17:04.725 | 24.5 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_sanzioneacc` WHERE (`id_ente_sanzioneacc`='1') AND (`id_bollettario_sanzioneacc`='24800') |
09:17:04.942 | 21.6 ms | yii\db\Command::query | SELECT * FROM `db1_persona` WHERE `id_persona`=24429 |
09:17:04.853 | 20.4 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=24800 |
09:17:05.008 | 17.9 ms | yii\db\Command::query | SELECT * FROM `db1_veicolo` WHERE `id_veicolo`=20341 |
09:17:04.811 | 16.5 ms | yii\db\Command::query | SELECT * FROM `db1_stradario` WHERE `COD_VIA`=231 |
09:17:04.919 | 16.1 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=24800) AND (`tipo_proprietario`=0) |
09:17:04.709 | 14.2 ms | yii\db\Command::query | SELECT * FROM `db2_docallegato` WHERE `id_bollettario_docallegato`='24800' LIMIT 20 |
09:17:04.971 | 11.0 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=24800 |
09:17:04.877 | 7.2 ms | yii\db\Command::query | SELECT * FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=24800 ORDER BY `id_sottoscritti` DESC LIMIT 15 |
09:17:04.985 | 4.4 ms | yii\db\Command::query | SELECT * FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=24800 LIMIT 20 |
09:17:04.606 | 2.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `articoli_new` |
09:17:04.490 | 2.1 ms | yii\db\Connection::open | Opening DB connection: mysql:host=localhost;dbname=sanzioni1_0 |
09:17:04.518 | 1.8 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_bollettario` |
09:17:04.830 | 1.8 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db0_comuni` |
09:17:05.166 | 1.8 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_rateizzato` |
09:17:04.529 | 1.7 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_decurtazionepunti` |
09:17:04.808 | 1.7 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_stradario` |
09:17:04.614 | 1.7 ms | yii\db\Command::query | SELECT * FROM `istat2021` WHERE `id_articolo`=1425 |
09:17:04.628 | 1.7 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_nota` WHERE (`id_ente_nota`='1') AND (`id_bollettario_nota`='24800') |
09:17:05.039 | 1.6 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_verbaleazienda` WHERE `id_bollettario_verbaleazienda`=24800 |
09:17:04.592 | 1.5 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_notifica` |
09:17:04.600 | 1.4 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_infrazione` |
09:17:04.492 | 1.4 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db0_user` |
09:17:04.964 | 1.4 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_persona` |
09:17:04.750 | 1.3 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_sanzioneacc` |
09:17:04.769 | 1.3 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_agente` |
09:17:04.524 | 1.3 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db0_ente` |
09:17:05.163 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE (`id_bollettario_infrazione`=24800) AND (`id_ente_infrazione`=1) |
09:17:04.754 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db2_sanzioneacc` WHERE (`id_ente_sanzioneacc`='1') AND (`id_bollettario_sanzioneacc`='24800') ORDER BY `id_sanzioneacc` DESC LIMIT 20 |
09:17:04.632 | 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_nota' AND kcu.table_name = 'db2_nota' |
09:17:04.706 | 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_docallegato' AND kcu.table_name = 'db2_docallegato' |
09:17:05.026 | 1.2 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_veicolo` |
09:17:04.753 | 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_sanzioneacc' AND kcu.table_name = 'db2_sanzioneacc' |
09:17:04.630 | 1.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_nota` |
09:17:05.040 | 1.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_verbaleazienda` |
09:17:05.217 | 1.1 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='1425' |
09:17:04.602 | 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_infrazione' AND kcu.table_name = 'db2_infrazione' |
09:17:04.521 | 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' |
09:17:04.594 | 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' |
09:17:04.936 | 1.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_proprietario` |
09:17:04.616 | 1.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `istat2021` |
09:17:04.874 | 1.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_sottoscritti` |
09:17:04.609 | 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' |
09:17:04.531 | 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_decurtazionepunti' AND kcu.table_name = 'db2_decurtazionepunti' |
09:17:04.801 | 1.0 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=24800 |
09:17:04.983 | 1.0 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_verbaleveicolo` |
09:17:04.617 | 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 = 'istat2021' AND kcu.table_name = 'istat2021' |
09:17:05.060 | 1.0 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24800 |
09:17:04.876 | 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' |
09:17:05.168 | 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:17:05.042 | 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:17:04.984 | 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' |
09:17:04.771 | 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' |
09:17:05.032 | 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 |
09:17:04.604 | 1.0 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`='24800' |
09:17:05.028 | 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 = 'db1_veicolo' AND kcu.table_name = 'db1_veicolo' |
09:17:04.966 | 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 = 'db1_persona' AND kcu.table_name = 'db1_persona' |
09:17:04.532 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_decurtazionepunti` WHERE `id_bollettario_decurtazionepunti`='24800' |
09:17:04.937 | 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_proprietario' AND kcu.table_name = 'db2_proprietario' |
09:17:04.526 | 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' |
09:17:04.495 | 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_user' AND kcu.table_name = 'db0_user' |
09:17:05.150 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_docallegato` WHERE `id_bollettario_docallegato`='24800' LIMIT 20 |
09:17:05.169 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_rateizzato` WHERE `id_bollettario_rateizzato`=24800 |
09:17:05.204 | 0.9 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 |
09:17:04.832 | 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_comuni' AND kcu.table_name = 'db0_comuni' |
09:17:05.161 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=24800 |
09:17:05.209 | 0.9 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_verbaleazienda` WHERE `id_bollettario_verbaleazienda`=24800 |
09:17:05.084 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`='24800' |
09:17:05.220 | 0.9 ms | yii\db\Command::query | SELECT * FROM `istat2021` WHERE `id_articolo`=1425 |
09:17:05.211 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=24800 |
09:17:04.766 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=11 |
09:17:04.611 | 0.9 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='1425' |
09:17:05.174 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE (`id_bollettario_infrazione`=24800) AND (`id_ente_infrazione`=1) |
09:17:04.768 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=42 |
09:17:05.214 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24800 ORDER BY `id_infrazione` DESC LIMIT 15 |
09:17:05.044 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=24800 |
09:17:05.068 | 0.8 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='1425' |
09:17:05.061 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24800 ORDER BY `id_infrazione` DESC LIMIT 15 |
09:17:05.213 | 0.8 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24800 |
09:17:05.031 | 0.8 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=24800) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20)) |
09:17:05.206 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db1_persona` WHERE `id_persona`=24429 |
09:17:05.202 | 0.8 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=24800) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20)) |
09:17:05.185 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=61 |
09:17:04.761 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=11 |
09:17:04.905 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=42 |
09:17:05.191 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=24800) AND (`tipo_proprietario`=0) LIMIT 20 |
09:17:05.171 | 0.8 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='1425' |
09:17:05.074 | 0.8 ms | yii\db\Command::query | SELECT * FROM `istat2021` WHERE `id_articolo`=1425 |
09:17:04.810 | 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 = 'db1_stradario' AND kcu.table_name = 'db1_stradario' |
09:17:05.183 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=24800 ORDER BY `id_sottoscritti` DESC LIMIT 15 |
09:17:04.522 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`='24800' |
09:17:05.148 | 0.8 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_docallegato` WHERE `id_bollettario_docallegato`='24800' |
09:17:05.172 | 0.8 ms | yii\db\Command::query | SELECT * FROM `istat2021` WHERE `id_articolo`=1425 |
09:17:05.086 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db2_decurtazionepunti` WHERE `id_bollettario_decurtazionepunti`='24800' |
09:17:05.197 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=24800 LIMIT 20 |
09:17:04.804 | 0.7 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_nota` WHERE (`id_ente_nota`=1) AND (`id_bollettario_nota`=24800) |
09:17:04.939 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=24800) AND (`tipo_proprietario`=0) LIMIT 20 |
09:17:05.034 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db1_persona` WHERE `id_persona`=24429 |
09:17:05.193 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db1_persona` WHERE `id_persona`=24429 |
09:17:05.130 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`=1 |
09:17:04.903 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=61 |
09:17:05.190 | 0.7 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=24800) AND (`tipo_proprietario`=0) |
09:17:05.182 | 0.7 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=24800 |
09:17:05.070 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_infrazione`=28071 |
09:17:05.196 | 0.7 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=24800 |
09:17:04.527 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`='1' |
09:17:05.200 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db1_veicolo` WHERE `id_veicolo`=20341 |
09:17:05.175 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=11 |
09:17:05.187 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=42 |
09:17:04.763 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=11 |
09:17:04.499 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=31 |
09:17:04.802 | 0.6 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`=1 |
09:17:05.076 | 0.6 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune`=72020 |
09:17:04.757 | 0.6 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=59 |
09:17:05.178 | 0.6 ms | yii\db\Command::query | SELECT * FROM `db1_stradario` WHERE `COD_VIA`=231 |
09:17:05.222 | 0.6 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune`=72020 |
09:17:05.179 | 0.6 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune`=72020 |
09:17:05.176 | 0.6 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=11 |
09:17:05.218 | 0.6 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_infrazione`=28071 |
09:17:05.162 | 0.6 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`=1 |
09:17:04.833 | 0.6 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune`=72020 |
09:17:04.759 | 0.6 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=59 |
09:17:04.764 | 0.6 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=11 |