Total processing time: 1,066 ms; Peak memory: 5.639 MB. Show Profiling Timeline
Time | Duration | Category | Info |
---|---|---|---|
07:48:36.688 | 129.3 ms | yii\db\Command::query | SELECT * FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=11078 LIMIT 20 |
07:48:36.427 | 33.8 ms | yii\db\Command::query | SELECT * FROM `db2_docallegato` WHERE `id_bollettario_docallegato`='11078' LIMIT 20 |
07:48:36.540 | 30.6 ms | yii\db\Command::query | SELECT * FROM `db1_stradario` WHERE `COD_VIA`=21456456 |
07:48:36.253 | 29.9 ms | yii\db\Command::query | SELECT * FROM `istat2021` WHERE `id_articolo`=1423 |
07:48:36.314 | 28.5 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_nota` WHERE (`id_ente_nota`='1') AND (`id_bollettario_nota`='11078') |
07:48:36.619 | 28.4 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=11078) AND (`tipo_proprietario`=0) |
07:48:36.171 | 22.0 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_decurtazionepunti` |
07:48:36.950 | 20.6 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_verbaleazienda` WHERE `id_bollettario_verbaleazienda`=11078 |
07:48:36.858 | 20.5 ms | yii\db\Command::query | SELECT * FROM `db1_veicolo` WHERE `id_veicolo`=9148 |
07:48:36.208 | 19.6 ms | yii\db\Command::query | SELECT * FROM `db2_notifica` WHERE `id_bollettario_notifica`='11078' ORDER BY `id_notifica` DESC |
07:48:36.666 | 18.3 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=11078 |
07:48:36.908 | 17.3 ms | yii\db\Command::query | SELECT * FROM `db1_persona` WHERE `id_persona`=10214 |
07:48:36.407 | 15.2 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_docallegato` WHERE `id_bollettario_docallegato`='11078' |
07:48:36.464 | 14.1 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_sanzioneacc` WHERE (`id_ente_sanzioneacc`='1') AND (`id_bollettario_sanzioneacc`='11078') |
07:48:36.527 | 11.7 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_stradario` |
07:48:36.584 | 11.6 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=11078 |
07:48:36.195 | 11.1 ms | yii\db\Command::query | SELECT * FROM `db2_decurtazionepunti` WHERE `id_bollettario_decurtazionepunti`='11078' |
07:48:36.599 | 10.3 ms | yii\db\Command::query | SELECT * FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=11078 ORDER BY `id_sottoscritti` DESC LIMIT 15 |
07:48:36.124 | 2.7 ms | yii\db\Connection::open | Opening DB connection: mysql:host=localhost;dbname=sanzioni1_0 |
07:48:36.155 | 2.5 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_bollettario` |
07:48:36.243 | 2.2 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `articoli_new` |
07:48:37.046 | 2.0 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_rateizzato` |
07:48:36.164 | 2.0 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db0_ente` |
07:48:36.127 | 1.7 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db0_user` |
07:48:36.926 | 1.7 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_persona` |
07:48:36.575 | 1.7 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db0_comuni` |
07:48:36.237 | 1.6 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_infrazione` |
07:48:36.159 | 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_bollettario' AND kcu.table_name = 'db2_bollettario' |
07:48:36.130 | 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_user' AND kcu.table_name = 'db0_user' |
07:48:36.227 | 1.6 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_notifica` |
07:48:36.283 | 1.5 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `istat2021` |
07:48:36.166 | 1.5 ms | yii\db\Command::query | SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'db0_ente' AND kcu.table_name = 'db0_ente' |
07:48:36.879 | 1.4 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_veicolo` |
07:48:36.478 | 1.4 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_sanzioneacc` |
07:48:36.343 | 1.4 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_nota` |
07:48:36.135 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=59 |
07:48:36.161 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`='11078' |
07:48:36.246 | 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 = 'articoli_new' AND kcu.table_name = 'articoli_new' |
07:48:36.347 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db2_nota` WHERE (`id_ente_nota`='1') AND (`id_bollettario_nota`='11078') ORDER BY `id_nota` DESC LIMIT 20 |
07:48:36.423 | 1.3 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_docallegato` |
07:48:36.239 | 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' |
07:48:37.043 | 1.2 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE (`id_bollettario_infrazione`=11078) AND (`id_ente_infrazione`=1) |
07:48:36.971 | 1.2 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_verbaleazienda` |
07:48:36.230 | 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' |
07:48:36.285 | 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 = 'istat2021' AND kcu.table_name = 'istat2021' |
07:48:36.596 | 1.2 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_sottoscritti` |
07:48:36.487 | 1.2 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_agente` |
07:48:36.685 | 1.2 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_verbaleveicolo` |
07:48:36.194 | 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_decurtazionepunti' AND kcu.table_name = 'db2_decurtazionepunti' |
07:48:36.480 | 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' |
07:48:36.345 | 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' |
07:48:36.241 | 1.1 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`='11078' |
07:48:36.686 | 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' |
07:48:36.168 | 1.1 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`='1' |
07:48:36.929 | 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' |
07:48:36.248 | 1.1 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='1423' |
07:48:36.973 | 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' |
07:48:36.648 | 1.0 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_proprietario` |
07:48:36.597 | 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' |
07:48:37.027 | 1.0 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`='11078' |
07:48:36.996 | 1.0 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=11078 |
07:48:37.030 | 1.0 ms | yii\db\Command::query | SELECT * FROM `db2_notifica` WHERE `id_bollettario_notifica`='11078' |
07:48:36.649 | 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_proprietario' AND kcu.table_name = 'db2_proprietario' |
07:48:37.049 | 1.0 ms | yii\db\Command::query | SELECT * FROM `db2_rateizzato` WHERE `id_bollettario_rateizzato`=11078 |
07:48:36.496 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_nota` WHERE (`id_ente_nota`=1) AND (`id_bollettario_nota`=11078) ORDER BY `id_nota` DESC LIMIT 20 |
07:48:37.035 | 0.9 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_docallegato` WHERE `id_bollettario_docallegato`='11078' |
07:48:36.577 | 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' |
07:48:36.425 | 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_docallegato' AND kcu.table_name = 'db2_docallegato' |
07:48:36.489 | 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_agente' AND kcu.table_name = 'db1_agente' |
07:48:36.495 | 0.9 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_nota` WHERE (`id_ente_nota`=1) AND (`id_bollettario_nota`=11078) |
07:48:36.881 | 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' |
07:48:37.088 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=11078 |
07:48:37.051 | 0.9 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='1423' |
07:48:37.055 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE (`id_bollettario_infrazione`=11078) AND (`id_ente_infrazione`=1) |
07:48:37.048 | 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' |
07:48:36.491 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=11078 |
07:48:37.009 | 0.9 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='1423' |
07:48:37.092 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=11078 ORDER BY `id_infrazione` DESC LIMIT 15 |
07:48:37.040 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=11078 |
07:48:37.094 | 0.9 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='1423' |
07:48:36.482 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=11 |
07:48:37.018 | 0.9 ms | yii\db\Command::query | SELECT * FROM `istat2021` WHERE `id_articolo`=1423 |
07:48:37.029 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_decurtazionepunti` WHERE `id_bollettario_decurtazionepunti`='11078' |
07:48:36.613 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=38 |
07:48:36.486 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=38 |
07:48:37.004 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=11078 ORDER BY `id_infrazione` DESC LIMIT 15 |
07:48:36.884 | 0.8 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=11078) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20)) |
07:48:36.385 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_nota` WHERE `id_nota`=1470 |
07:48:37.084 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db1_persona` WHERE `id_persona`=10214 |
07:48:37.067 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=18 |
07:48:36.539 | 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' |
07:48:37.081 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=11078) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20)) LIMIT 20 |
07:48:36.885 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=11078) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20)) LIMIT 20 |
07:48:37.054 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_notifica` WHERE `id_bollettario_notifica`=11078 ORDER BY `id_notifica` |
07:48:37.052 | 0.8 ms | yii\db\Command::query | SELECT * FROM `istat2021` WHERE `id_articolo`=1423 |
07:48:36.578 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune`=72006 |
07:48:37.098 | 0.8 ms | yii\db\Command::query | SELECT * FROM `istat2021` WHERE `id_articolo`=1423 |
07:48:37.058 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=11 |
07:48:37.072 | 0.8 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=11078) AND (`tipo_proprietario`=0) |
07:48:37.036 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_docallegato` WHERE `id_bollettario_docallegato`='11078' LIMIT 20 |
07:48:37.020 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune`=72006 |
07:48:36.387 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=11078 |
07:48:36.484 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=11 |
07:48:37.080 | 0.8 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=11078) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20)) |
07:48:37.074 | 0.7 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=11078 |
07:48:37.057 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=11 |
07:48:37.011 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_infrazione`=12160 |
07:48:37.064 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=11078 ORDER BY `id_sottoscritti` DESC LIMIT 15 |
07:48:36.611 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=18 |
07:48:37.087 | 0.7 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_verbaleazienda` WHERE `id_bollettario_verbaleazienda`=11078 |
07:48:37.003 | 0.7 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=11078 |
07:48:37.075 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=11078 LIMIT 20 |
07:48:36.398 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=11 |
07:48:37.091 | 0.7 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=11078 |
07:48:37.063 | 0.7 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=11078 |
07:48:36.522 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=11 |
07:48:37.096 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_infrazione`=12160 |
07:48:36.523 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=11 |
07:48:37.069 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=38 |
07:48:37.100 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune`=72006 |
07:48:37.061 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune`=72006 |
07:48:37.060 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db1_stradario` WHERE `COD_VIA`=21456456 |
07:48:36.396 | 0.6 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=11 |
07:48:37.078 | 0.6 ms | yii\db\Command::query | SELECT * FROM `db1_veicolo` WHERE `id_veicolo`=9148 |
07:48:37.031 | 0.6 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`=1 |
07:48:36.388 | 0.6 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`=1 |
07:48:36.492 | 0.6 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`=1 |
07:48:37.042 | 0.5 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`=1 |