Total processing time: 2,531 ms; Peak memory: 5.543 MB. Show Profiling Timeline
Time | Duration | Category | Info |
---|---|---|---|
08:59:37.080 | 128.4 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_sanzioneacc` WHERE (`id_ente_sanzioneacc`='1') AND (`id_bollettario_sanzioneacc`='21437') |
08:59:36.839 | 97.7 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_nota` WHERE (`id_ente_nota`='1') AND (`id_bollettario_nota`='21437') |
08:59:37.767 | 83.4 ms | yii\db\Command::query | SELECT * FROM `db1_persona` WHERE `id_persona`=22090 |
08:59:36.346 | 76.6 ms | yii\db\Command::query | SELECT * FROM `db2_notifica` WHERE `id_bollettario_notifica`='21437' ORDER BY `id_notifica` DESC |
08:59:36.466 | 68.2 ms | yii\db\Command::query | SELECT * FROM `istat2021` WHERE `id_articolo`=439 |
08:59:37.950 | 63.3 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=21437 |
08:59:38.068 | 57.2 ms | yii\db\Command::query | SELECT * FROM `db1_veicolo` WHERE `id_veicolo`=17606 |
08:59:36.949 | 52.4 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_docallegato` WHERE `id_bollettario_docallegato`='21437' |
08:59:37.487 | 50.6 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune`=72038 |
08:59:37.671 | 48.9 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=21437) AND (`tipo_proprietario`=0) |
08:59:38.159 | 48.9 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_verbaleazienda` WHERE `id_bollettario_verbaleazienda`=21437 |
08:59:38.469 | 42.9 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE (`id_bollettario_infrazione`=21437) AND (`id_ente_infrazione`=1) |
08:59:38.352 | 34.0 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune`=110009 |
08:59:37.590 | 30.8 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=21437 |
08:59:36.313 | 30.7 ms | yii\db\Command::query | SELECT * FROM `db2_decurtazionepunti` WHERE `id_bollettario_decurtazionepunti`='21437' |
08:59:37.389 | 25.3 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_stradario` |
08:59:38.558 | 23.7 ms | yii\db\Command::query | SELECT * FROM `db2_rateizzato` WHERE `id_bollettario_rateizzato`=21437 |
08:59:38.534 | 22.3 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_rateizzato` |
08:59:37.463 | 22.3 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db0_comuni` |
08:59:37.007 | 21.9 ms | yii\db\Command::query | SELECT * FROM `db2_docallegato` WHERE `id_bollettario_docallegato`='21437' LIMIT 20 |
08:59:37.416 | 21.0 ms | yii\db\Command::query | SELECT * FROM `db1_stradario` WHERE `COD_VIA`=231 |
08:59:36.292 | 18.5 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_decurtazionepunti` |
08:59:38.031 | 15.2 ms | yii\db\Command::query | SELECT * FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=21437 LIMIT 20 |
08:59:38.014 | 14.7 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_verbaleveicolo` |
08:59:37.624 | 10.6 ms | yii\db\Command::query | SELECT * FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=21437 ORDER BY `id_sottoscritti` DESC LIMIT 15 |
08:59:36.457 | 2.0 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `articoli_new` |
08:59:37.209 | 2.0 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_sanzioneacc` |
08:59:36.262 | 1.9 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_bollettario` |
08:59:36.210 | 1.9 ms | yii\db\Connection::open | Opening DB connection: mysql:host=localhost;dbname=sanzioni1_0 |
08:59:38.136 | 1.8 ms | yii\db\Command::query | SELECT * FROM `db1_persona` WHERE `id_persona`=20943 |
08:59:36.450 | 1.7 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_infrazione` |
08:59:37.851 | 1.6 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_persona` |
08:59:36.212 | 1.6 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db0_user` |
08:59:37.212 | 1.5 ms | yii\db\Command::query | SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'db2_sanzioneacc' AND kcu.table_name = 'db2_sanzioneacc' |
08:59:36.423 | 1.5 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_notifica` |
08:59:38.126 | 1.5 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_veicolo` |
08:59:38.447 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db2_docallegato` WHERE `id_bollettario_docallegato`='21437' LIMIT 20 |
08:59:38.030 | 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_verbaleveicolo' AND kcu.table_name = 'db2_verbaleveicolo' |
08:59:38.393 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`='21437' |
08:59:37.214 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db2_sanzioneacc` WHERE (`id_ente_sanzioneacc`='1') AND (`id_bollettario_sanzioneacc`='21437') ORDER BY `id_sanzioneacc` DESC LIMIT 20 |
08:59:37.309 | 1.4 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_agente` |
08:59:36.217 | 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 = 'db0_user' AND kcu.table_name = 'db0_user' |
08:59:37.002 | 1.3 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_docallegato` |
08:59:36.937 | 1.3 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_nota` |
08:59:38.397 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db2_notifica` WHERE `id_bollettario_notifica`='21437' |
08:59:38.466 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=21437 |
08:59:37.854 | 1.2 ms | yii\db\Command::query | SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'db1_persona' AND kcu.table_name = 'db1_persona' |
08:59:36.269 | 1.2 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db0_ente` |
08:59:38.395 | 1.2 ms | yii\db\Command::query | SELECT * FROM `db2_decurtazionepunti` WHERE `id_bollettario_decurtazionepunti`='21437' |
08:59:38.128 | 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_veicolo' AND kcu.table_name = 'db1_veicolo' |
08:59:37.282 | 1.2 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=66 |
08:59:37.722 | 1.2 ms | yii\db\Command::query | SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'db2_proprietario' AND kcu.table_name = 'db2_proprietario' |
08:59:36.265 | 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_bollettario' AND kcu.table_name = 'db2_bollettario' |
08:59:38.208 | 1.2 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_verbaleazienda` |
08:59:36.425 | 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' |
08:59:36.535 | 1.2 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `istat2021` |
08:59:37.621 | 1.2 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_sottoscritti` |
08:59:36.311 | 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' |
08:59:38.557 | 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_rateizzato' AND kcu.table_name = 'db2_rateizzato' |
08:59:36.453 | 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' |
08:59:37.005 | 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_docallegato' AND kcu.table_name = 'db2_docallegato' |
08:59:38.312 | 1.1 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='439' |
08:59:38.210 | 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' |
08:59:37.622 | 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' |
08:59:38.286 | 1.1 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=21437 ORDER BY `id_infrazione` DESC LIMIT 15 |
08:59:37.720 | 1.0 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_proprietario` |
08:59:38.132 | 1.0 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=21437) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20)) |
08:59:36.938 | 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_nota' AND kcu.table_name = 'db2_nota' |
08:59:38.588 | 1.0 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE (`id_bollettario_infrazione`=21437) AND (`id_ente_infrazione`=1) |
08:59:37.311 | 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' |
08:59:38.350 | 1.0 ms | yii\db\Command::query | SELECT * FROM `istat2021` WHERE `id_articolo`=439 |
08:59:38.583 | 1.0 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='439' |
08:59:36.536 | 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' |
08:59:36.461 | 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' |
08:59:38.586 | 1.0 ms | yii\db\Command::query | SELECT * FROM `db2_notifica` WHERE `id_bollettario_notifica`=21437 ORDER BY `id_notifica` |
08:59:37.361 | 1.0 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=21437 |
08:59:37.290 | 1.0 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=66 |
08:59:38.593 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=66 |
08:59:37.308 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=58 |
08:59:38.133 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=21437) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20)) LIMIT 20 |
08:59:38.284 | 0.9 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=21437 |
08:59:38.604 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=58 |
08:59:38.445 | 0.9 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_docallegato` WHERE `id_bollettario_docallegato`='21437' |
08:59:36.455 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`='21437' |
08:59:38.623 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db1_persona` WHERE `id_persona`=20943 |
08:59:38.602 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=21437 ORDER BY `id_sottoscritti` DESC LIMIT 15 |
08:59:38.585 | 0.9 ms | yii\db\Command::query | SELECT * FROM `istat2021` WHERE `id_articolo`=439 |
08:59:38.609 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=21437) AND (`tipo_proprietario`=0) LIMIT 20 |
08:59:37.723 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=21437) AND (`tipo_proprietario`=0) LIMIT 20 |
08:59:37.415 | 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' |
08:59:37.486 | 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' |
08:59:36.267 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`='21437' |
08:59:37.369 | 0.9 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_nota` WHERE (`id_ente_nota`=1) AND (`id_bollettario_nota`=21437) |
08:59:36.462 | 0.9 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='439' |
08:59:38.620 | 0.9 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=21437) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20)) |
08:59:38.621 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=21437) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20)) LIMIT 20 |
08:59:36.271 | 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' |
08:59:38.628 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=21437 |
08:59:38.637 | 0.9 ms | yii\db\Command::query | SELECT * FROM `istat2021` WHERE `id_articolo`=439 |
08:59:38.634 | 0.9 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='439' |
08:59:37.297 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=66 |
08:59:38.611 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db1_persona` WHERE `id_persona`=22090 |
08:59:38.259 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=21437 |
08:59:38.632 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=21437 ORDER BY `id_infrazione` DESC LIMIT 15 |
08:59:38.607 | 0.8 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=21437) AND (`tipo_proprietario`=0) |
08:59:38.591 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=66 |
08:59:38.314 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_infrazione`=24118 |
08:59:36.227 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=59 |
08:59:38.630 | 0.8 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=21437 |
08:59:38.399 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`=1 |
08:59:38.617 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db1_veicolo` WHERE `id_veicolo`=17606 |
08:59:38.598 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune`=72038 |
08:59:38.614 | 0.8 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=21437 |
08:59:38.601 | 0.8 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=21437 |
08:59:38.615 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=21437 LIMIT 20 |
08:59:37.305 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=66 |
08:59:38.626 | 0.7 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_verbaleazienda` WHERE `id_bollettario_verbaleazienda`=21437 |
08:59:38.596 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db1_stradario` WHERE `COD_VIA`=231 |
08:59:37.363 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`=1 |
08:59:38.468 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`=1 |
08:59:38.639 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune`=110009 |
08:59:37.655 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=58 |
08:59:38.635 | 0.6 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_infrazione`=24118 |
08:59:36.272 | 0.6 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`='1' |