Total processing time: 1,070 ms; Peak memory: 5.455 MB. Show Profiling Timeline
Time | Duration | Category | Info |
---|---|---|---|
09:37:53.867 | 99.1 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_sanzioneacc` WHERE (`id_ente_sanzioneacc`='1') AND (`id_bollettario_sanzioneacc`='10265') |
09:37:53.730 | 71.8 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_nota` WHERE (`id_ente_nota`='1') AND (`id_bollettario_nota`='10265') |
09:37:53.603 | 51.0 ms | yii\db\Command::query | SELECT * FROM `db2_notifica` WHERE `id_bollettario_notifica`='10265' ORDER BY `id_notifica` DESC |
09:37:54.282 | 49.7 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_verbaleazienda` WHERE `id_bollettario_verbaleazienda`=10265 |
09:37:53.816 | 43.6 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_docallegato` WHERE `id_bollettario_docallegato`='10265' |
09:37:53.560 | 40.7 ms | yii\db\Command::query | SELECT * FROM `db2_decurtazionepunti` WHERE `id_bollettario_decurtazionepunti`='10265' |
09:37:54.001 | 33.5 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=30 |
09:37:54.097 | 31.0 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=10265 |
09:37:54.183 | 30.0 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=10265 |
09:37:54.415 | 24.3 ms | yii\db\Command::query | SELECT * FROM `db2_rateizzato` WHERE `id_bollettario_rateizzato`=10265 |
09:37:54.229 | 21.1 ms | yii\db\Command::query | SELECT * FROM `db1_veicolo` WHERE `id_veicolo`=8510 |
09:37:53.675 | 20.7 ms | yii\db\Command::query | SELECT * FROM `istat2019` WHERE `id_articolo`=155 |
09:37:54.051 | 18.3 ms | yii\db\Command::query | SELECT * FROM `db1_stradario` WHERE `COD_VIA`=240 |
09:37:54.393 | 17.0 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE (`id_bollettario_infrazione`=10265) AND (`id_ente_infrazione`=1) |
09:37:54.131 | 9.9 ms | yii\db\Command::query | SELECT * FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=10265 ORDER BY `id_sottoscritti` DESC LIMIT 15 |
09:37:54.216 | 8.3 ms | yii\db\Command::query | SELECT * FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=10265 LIMIT 20 |
09:37:53.666 | 2.5 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `articoli_new` |
09:37:54.151 | 2.1 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=10265) AND (`tipo_proprietario`=0) |
09:37:54.048 | 1.9 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_stradario` |
09:37:53.545 | 1.9 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_bollettario` |
09:37:54.412 | 1.9 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_rateizzato` |
09:37:53.659 | 1.8 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_infrazione` |
09:37:53.966 | 1.8 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_sanzioneacc` |
09:37:54.161 | 1.7 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_persona` |
09:37:53.557 | 1.7 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_decurtazionepunti` |
09:37:53.859 | 1.6 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_docallegato` |
09:37:54.071 | 1.5 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db0_comuni` |
09:37:54.379 | 1.5 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_notifica` |
09:37:54.034 | 1.4 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_agente` |
09:37:53.519 | 1.4 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db0_user` |
09:37:53.552 | 1.4 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db0_ente` |
09:37:54.153 | 1.3 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_proprietario` |
09:37:53.517 | 1.3 ms | yii\db\Connection::open | Opening DB connection: mysql:host=localhost;dbname=sanzioni1_0 |
09:37:53.802 | 1.3 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_nota` |
09:37:53.969 | 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_sanzioneacc' AND kcu.table_name = 'db2_sanzioneacc' |
09:37:53.662 | 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_infrazione' AND kcu.table_name = 'db2_infrazione' |
09:37:54.250 | 1.2 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_veicolo` |
09:37:53.862 | 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:37:54.381 | 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_notifica' AND kcu.table_name = 'db2_notifica' |
09:37:54.333 | 1.2 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_verbaleazienda` |
09:37:54.391 | 1.2 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`=1 |
09:37:54.037 | 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_agente' AND kcu.table_name = 'db1_agente' |
09:37:54.164 | 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:37:53.804 | 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_nota' AND kcu.table_name = 'db2_nota' |
09:37:54.128 | 1.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_sottoscritti` |
09:37:53.696 | 1.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `istat2019` |
09:37:54.130 | 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_sottoscritti' AND kcu.table_name = 'db2_sottoscritti' |
09:37:54.354 | 1.1 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=10265 |
09:37:54.155 | 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_proprietario' AND kcu.table_name = 'db2_proprietario' |
09:37:53.549 | 1.1 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`='10265' |
09:37:54.252 | 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:37:54.334 | 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:37:54.160 | 1.0 ms | yii\db\Command::query | SELECT * FROM `db1_persona` WHERE `id_persona`=9470 |
09:37:53.548 | 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_bollettario' AND kcu.table_name = 'db2_bollettario' |
09:37:53.559 | 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:37:54.213 | 1.0 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_verbaleveicolo` |
09:37:54.452 | 1.0 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=10265 |
09:37:54.414 | 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:37:53.670 | 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 = 'articoli_new' AND kcu.table_name = 'articoli_new' |
09:37:53.971 | 1.0 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=11 |
09:37:54.215 | 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:37:54.442 | 1.0 ms | yii\db\Command::query | SELECT * FROM `istat2019` WHERE `id_articolo`=155 |
09:37:53.521 | 1.0 ms | yii\db\Command::query | SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'db0_user' AND kcu.table_name = 'db0_user' |
09:37:54.363 | 1.0 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='155' |
09:37:53.698 | 1.0 ms | yii\db\Command::query | SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'istat2019' AND kcu.table_name = 'istat2019' |
09:37:54.390 | 1.0 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=10265 |
09:37:53.671 | 0.9 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='155' |
09:37:54.456 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=39 |
09:37:54.476 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=10265) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20)) LIMIT 20 |
09:37:53.664 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`='10265' |
09:37:54.458 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=30 |
09:37:54.449 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune`=72037 |
09:37:54.156 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=10265) AND (`tipo_proprietario`=0) LIMIT 20 |
09:37:54.041 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=10265 |
09:37:54.465 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db1_persona` WHERE `id_persona`=9470 |
09:37:54.376 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`='10265' |
09:37:54.044 | 0.9 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_nota` WHERE (`id_ente_nota`=1) AND (`id_bollettario_nota`=10265) |
09:37:54.468 | 0.9 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=10265 |
09:37:54.440 | 0.9 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='155' |
09:37:54.073 | 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:37:54.481 | 0.9 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_verbaleazienda` WHERE `id_bollettario_verbaleazienda`=10265 |
09:37:54.143 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=39 |
09:37:54.050 | 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_stradario' AND kcu.table_name = 'db1_stradario' |
09:37:54.489 | 0.9 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='155' |
09:37:54.255 | 0.9 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=10265) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20)) |
09:37:54.485 | 0.9 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=10265 |
09:37:54.493 | 0.8 ms | yii\db\Command::query | SELECT * FROM `istat2019` WHERE `id_articolo`=155 |
09:37:54.453 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=10265 ORDER BY `id_sottoscritti` DESC LIMIT 15 |
09:37:54.486 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=10265 ORDER BY `id_infrazione` DESC LIMIT 15 |
09:37:54.367 | 0.8 ms | yii\db\Command::query | SELECT * FROM `istat2019` WHERE `id_articolo`=155 |
09:37:54.358 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=10265 ORDER BY `id_infrazione` DESC LIMIT 15 |
09:37:54.469 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=10265 LIMIT 20 |
09:37:54.474 | 0.8 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=10265) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20)) |
09:37:54.471 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db1_veicolo` WHERE `id_veicolo`=8510 |
09:37:53.553 | 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_ente' AND kcu.table_name = 'db0_ente' |
09:37:53.973 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=11 |
09:37:54.483 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=10265 |
09:37:54.461 | 0.8 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=10265) AND (`tipo_proprietario`=0) |
09:37:54.259 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db1_persona` WHERE `id_persona`=9471 |
09:37:54.257 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=10265) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20)) LIMIT 20 |
09:37:54.443 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE (`id_bollettario_infrazione`=10265) AND (`id_ente_infrazione`=1) |
09:37:54.364 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_infrazione`=11252 |
09:37:54.490 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_infrazione`=11252 |
09:37:54.145 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=30 |
09:37:54.386 | 0.7 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_docallegato` WHERE `id_bollettario_docallegato`='10265' |
09:37:54.448 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db1_stradario` WHERE `COD_VIA`=240 |
09:37:54.478 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db1_persona` WHERE `id_persona`=9471 |
09:37:54.382 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db2_notifica` WHERE `id_bollettario_notifica`='10265' |
09:37:54.357 | 0.7 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=10265 |
09:37:54.463 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=10265) AND (`tipo_proprietario`=0) LIMIT 20 |
09:37:54.075 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune`=72037 |
09:37:53.526 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=31 |
09:37:54.378 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db2_decurtazionepunti` WHERE `id_bollettario_decurtazionepunti`='10265' |
09:37:54.369 | 0.6 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune`=72006 |
09:37:54.495 | 0.6 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune`=72006 |
09:37:53.554 | 0.6 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`='1' |
09:37:54.445 | 0.6 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=11 |
09:37:54.446 | 0.6 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=11 |
09:37:54.042 | 0.5 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`=1 |
09:37:54.383 | 0.5 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`=1 |