Total processing time: 458 ms; Peak memory: 5.597 MB. Show Profiling Timeline
Time | Duration | Category | Info |
---|---|---|---|
09:20:57.984 | 4.2 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_bollettario` |
09:20:57.990 | 2.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_bollettario' AND kcu.table_name = 'db2_bollettario' |
09:20:58.004 | 2.8 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_decurtazionepunti` |
09:20:57.997 | 2.7 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db0_ente` |
09:20:58.031 | 2.7 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `articoli_new` |
09:20:57.953 | 2.3 ms | yii\db\Connection::open | Opening DB connection: mysql:host=localhost;dbname=sanzioni1_0 |
09:20:58.015 | 2.3 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_notifica` |
09:20:57.955 | 2.2 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db0_user` |
09:20:58.023 | 2.2 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_infrazione` |
09:20:58.097 | 2.2 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_sanzioneacc` |
09:20:58.008 | 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_decurtazionepunti' AND kcu.table_name = 'db2_decurtazionepunti' |
09:20:57.993 | 2.2 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`='24370' |
09:20:58.195 | 2.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_persona` |
09:20:58.136 | 2.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db0_comuni` |
09:20:58.255 | 2.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_rateizzato` |
09:20:58.095 | 2.0 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_sanzioneacc` WHERE (`id_ente_sanzioneacc`='1') AND (`id_bollettario_sanzioneacc`='24370') |
09:20:58.205 | 2.0 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_verbaleazienda` |
09:20:57.959 | 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 = 'db0_user' AND kcu.table_name = 'db0_user' |
09:20:58.088 | 1.9 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_docallegato` |
09:20:58.042 | 1.9 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `istat2021` |
09:20:58.207 | 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_verbaleazienda' AND kcu.table_name = 'db2_verbaleazienda' |
09:20:58.149 | 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:20:58.173 | 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_verbaleveicolo' AND kcu.table_name = 'db2_verbaleveicolo' |
09:20:58.056 | 1.9 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_nota` WHERE (`id_ente_nota`='1') AND (`id_bollettario_nota`='24370') |
09:20:58.181 | 1.8 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_veicolo` |
09:20:58.091 | 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_docallegato' AND kcu.table_name = 'db2_docallegato' |
09:20:58.059 | 1.8 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_nota` |
09:20:58.100 | 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_sanzioneacc' AND kcu.table_name = 'db2_sanzioneacc' |
09:20:58.000 | 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' |
09:20:58.111 | 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_agente' AND kcu.table_name = 'db1_agente' |
09:20:58.026 | 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:20:58.061 | 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_nota' AND kcu.table_name = 'db2_nota' |
09:20:58.316 | 1.7 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24370 ORDER BY `id_infrazione` DESC LIMIT 15 |
09:20:58.171 | 1.7 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_verbaleveicolo` |
09:20:58.139 | 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 = 'db0_comuni' AND kcu.table_name = 'db0_comuni' |
09:20:58.120 | 1.6 ms | yii\db\Command::query | SELECT * FROM `db2_nota` WHERE (`id_ente_nota`=1) AND (`id_bollettario_nota`=24370) ORDER BY `id_nota` DESC LIMIT 20 |
09:20:58.107 | 1.6 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=41 |
09:20:58.198 | 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_persona' AND kcu.table_name = 'db1_persona' |
09:20:58.203 | 1.6 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_verbaleazienda` WHERE `id_bollettario_verbaleazienda`=24370 |
09:20:58.252 | 1.6 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE (`id_bollettario_infrazione`=24370) AND (`id_ente_infrazione`=1) |
09:20:58.165 | 1.6 ms | yii\db\Command::query | SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'db2_proprietario' AND kcu.table_name = 'db2_proprietario' |
09:20:58.013 | 1.6 ms | yii\db\Command::query | SELECT * FROM `db2_notifica` WHERE `id_bollettario_notifica`='24370' ORDER BY `id_notifica` DESC |
09:20:58.109 | 1.6 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_agente` |
09:20:58.193 | 1.6 ms | yii\db\Command::query | SELECT * FROM `db1_persona` WHERE `id_persona`=24025 |
09:20:58.183 | 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_veicolo' AND kcu.table_name = 'db1_veicolo' |
09:20:58.018 | 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_notifica' AND kcu.table_name = 'db2_notifica' |
09:20:58.069 | 1.6 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=24370 |
09:20:58.235 | 1.6 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`='24370' |
09:20:58.187 | 1.5 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=24370) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20)) |
09:20:58.063 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_nota` WHERE (`id_ente_nota`='1') AND (`id_bollettario_nota`='24370') ORDER BY `id_nota` DESC LIMIT 20 |
09:20:58.010 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_decurtazionepunti` WHERE `id_bollettario_decurtazionepunti`='24370' |
09:20:58.129 | 1.5 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_stradario` |
09:20:58.045 | 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 = 'istat2021' AND kcu.table_name = 'istat2021' |
09:20:58.086 | 1.5 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_docallegato` WHERE `id_bollettario_docallegato`='24370' |
09:20:58.216 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24370 ORDER BY `id_infrazione` DESC LIMIT 15 |
09:20:58.248 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=24370 |
09:20:58.028 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`='24370' |
09:20:58.211 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=24370 |
09:20:58.263 | 1.5 ms | yii\db\Command::query | SELECT * FROM `istat2021` WHERE `id_articolo`=483 |
09:20:58.319 | 1.5 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='483' |
09:20:58.147 | 1.5 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_sottoscritti` |
09:20:58.311 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=24370 |
09:20:58.035 | 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 = 'articoli_new' AND kcu.table_name = 'articoli_new' |
09:20:58.041 | 1.5 ms | yii\db\Command::query | SELECT * FROM `istat2021` WHERE `id_articolo`=483 |
09:20:58.267 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE (`id_bollettario_infrazione`=24370) AND (`id_ente_infrazione`=1) |
09:20:58.214 | 1.5 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24370 |
09:20:58.275 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune`=72006 |
09:20:58.280 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=24370 ORDER BY `id_sottoscritti` DESC LIMIT 15 |
09:20:58.258 | 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_rateizzato' AND kcu.table_name = 'db2_rateizzato' |
09:20:58.286 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=41 |
09:20:58.238 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db2_decurtazionepunti` WHERE `id_bollettario_decurtazionepunti`='24370' |
09:20:58.145 | 1.4 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=24370 |
09:20:58.321 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_infrazione`=27525 |
09:20:58.324 | 1.4 ms | yii\db\Command::query | SELECT * FROM `istat2021` WHERE `id_articolo`=483 |
09:20:58.305 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db1_persona` WHERE `id_persona`=24025 |
09:20:58.242 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`=1 |
09:20:58.075 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=11 |
09:20:58.240 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db2_notifica` WHERE `id_bollettario_notifica`='24370' |
09:20:58.119 | 1.4 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_nota` WHERE (`id_ente_nota`=1) AND (`id_bollettario_nota`=24370) |
09:20:58.225 | 1.4 ms | yii\db\Command::query | SELECT * FROM `istat2021` WHERE `id_articolo`=483 |
09:20:58.222 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_infrazione`=27525 |
09:20:58.250 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`=1 |
09:20:58.283 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=59 |
09:20:58.141 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune`=72006 |
09:20:58.189 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=24370) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20)) LIMIT 20 |
09:20:58.294 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=24370 LIMIT 20 |
09:20:58.220 | 1.4 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='483' |
09:20:58.104 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=31 |
09:20:58.131 | 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 = 'db1_stradario' AND kcu.table_name = 'db1_stradario' |
09:20:58.002 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`='1' |
09:20:58.114 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=24370 |
09:20:58.300 | 1.3 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=24370) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20)) |
09:20:58.292 | 1.3 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=24370 |
09:20:58.179 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db1_veicolo` WHERE `id_veicolo`=20013 |
09:20:58.151 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=24370 ORDER BY `id_sottoscritti` DESC LIMIT 15 |
09:20:58.077 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=11 |
09:20:58.163 | 1.3 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_proprietario` |
09:20:58.125 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=11 |
09:20:58.302 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=24370) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20)) LIMIT 20 |
09:20:58.272 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db1_stradario` WHERE `COD_VIA`=914 |
09:20:58.123 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=11 |
09:20:58.260 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db2_rateizzato` WHERE `id_bollettario_rateizzato`=24370 |
09:20:58.245 | 1.3 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_docallegato` WHERE `id_bollettario_docallegato`='24370' |
09:20:58.071 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`=1 |
09:20:58.169 | 1.3 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=24370 |
09:20:58.133 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db1_stradario` WHERE `COD_VIA`=914 |
09:20:58.228 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune`=72006 |
09:20:58.261 | 1.3 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='483' |
09:20:58.175 | 1.2 ms | yii\db\Command::query | SELECT * FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=24370 LIMIT 20 |
09:20:58.297 | 1.2 ms | yii\db\Command::query | SELECT * FROM `db1_veicolo` WHERE `id_veicolo`=20013 |
09:20:58.314 | 1.2 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24370 |
09:20:58.157 | 1.2 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=41 |
09:20:58.308 | 1.2 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_verbaleazienda` WHERE `id_bollettario_verbaleazienda`=24370 |
09:20:57.965 | 1.2 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=59 |
09:20:58.278 | 1.2 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=24370 |
09:20:58.161 | 1.2 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=24370) AND (`tipo_proprietario`=0) |
09:20:58.116 | 1.2 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`=1 |
09:20:58.327 | 1.1 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune`=72006 |
09:20:58.037 | 1.1 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='483' |
09:20:58.068 | 1.1 ms | yii\db\Command::query | SELECT * FROM `db2_nota` WHERE `id_nota`=1899 |
09:20:58.265 | 1.1 ms | yii\db\Command::query | SELECT * FROM `db2_notifica` WHERE `id_bollettario_notifica`=24370 ORDER BY `id_notifica` |
09:20:58.154 | 1.1 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=59 |
09:20:58.102 | 1.1 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=31 |
09:20:58.269 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=31 |
09:20:58.289 | 0.9 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=24370) AND (`tipo_proprietario`=0) |
09:20:58.271 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=31 |