Total processing time: 570 ms; Peak memory: 5.566 MB. Show Profiling Timeline
Time | Duration | Category | Info |
---|---|---|---|
13:33:14.205 | 19.1 ms | yii\db\Command::query | SELECT * FROM `db2_notifica` WHERE `id_bollettario_notifica`='24617' ORDER BY `id_notifica` DESC |
13:33:14.396 | 18.4 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=24617) AND (`tipo_proprietario`=0) |
13:33:14.289 | 16.2 ms | yii\db\Command::query | SELECT * FROM `db2_docallegato` WHERE `id_bollettario_docallegato`='24617' LIMIT 20 |
13:33:14.440 | 15.5 ms | yii\db\Command::query | SELECT * FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=24617 LIMIT 20 |
13:33:14.370 | 13.2 ms | yii\db\Command::query | SELECT * FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=24617 ORDER BY `id_sottoscritti` DESC LIMIT 15 |
13:33:14.174 | 5.6 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_bollettario` |
13:33:14.141 | 3.4 ms | yii\db\Connection::open | Opening DB connection: mysql:host=localhost;dbname=sanzioni1_0 |
13:33:14.181 | 3.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_bollettario' AND kcu.table_name = 'db2_bollettario' |
13:33:14.196 | 3.2 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_decurtazionepunti` |
13:33:14.188 | 2.8 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db0_ente` |
13:33:14.309 | 2.6 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_sanzioneacc` WHERE (`id_ente_sanzioneacc`='1') AND (`id_bollettario_sanzioneacc`='24617') |
13:33:14.240 | 2.6 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `articoli_new` |
13:33:14.265 | 2.5 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_nota` WHERE (`id_ente_nota`='1') AND (`id_bollettario_nota`='24617') |
13:33:14.148 | 2.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 = 'db0_user' AND kcu.table_name = 'db0_user' |
13:33:14.185 | 2.4 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`='24617' |
13:33:14.144 | 2.4 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db0_user` |
13:33:14.425 | 2.3 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_persona` |
13:33:14.530 | 2.3 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_rateizzato` |
13:33:14.280 | 2.3 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_docallegato` WHERE `id_bollettario_docallegato`='24617' |
13:33:14.330 | 2.2 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=15 |
13:33:14.355 | 2.2 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db0_comuni` |
13:33:14.347 | 2.2 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_stradario` |
13:33:14.433 | 2.2 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=24617 |
13:33:14.477 | 2.2 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_verbaleazienda` WHERE `id_bollettario_verbaleazienda`=24617 |
13:33:14.461 | 2.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_veicolo` |
13:33:14.283 | 2.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_docallegato` |
13:33:14.364 | 2.1 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=24617 |
13:33:14.436 | 2.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_verbaleveicolo` |
13:33:14.200 | 2.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' |
13:33:14.312 | 2.0 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_sanzioneacc` |
13:33:14.459 | 2.0 ms | yii\db\Command::query | SELECT * FROM `db1_veicolo` WHERE `id_veicolo`=20205 |
13:33:14.225 | 2.0 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_notifica` |
13:33:14.332 | 1.9 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_agente` |
13:33:14.268 | 1.9 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_nota` |
13:33:14.414 | 1.9 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_proprietario` |
13:33:14.250 | 1.8 ms | yii\db\Command::query | SELECT * FROM `istat2021` WHERE `id_articolo`=276 |
13:33:14.285 | 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' |
13:33:14.191 | 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 = 'db0_ente' AND kcu.table_name = 'db0_ente' |
13:33:14.233 | 1.8 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_infrazione` |
13:33:14.366 | 1.8 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_sottoscritti` |
13:33:14.417 | 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_proprietario' AND kcu.table_name = 'db2_proprietario' |
13:33:14.480 | 1.7 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_verbaleazienda` |
13:33:14.527 | 1.7 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE (`id_bollettario_infrazione`=24617) AND (`id_ente_infrazione`=1) |
13:33:14.252 | 1.7 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `istat2021` |
13:33:14.358 | 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_comuni' AND kcu.table_name = 'db0_comuni' |
13:33:14.317 | 1.7 ms | yii\db\Command::query | SELECT * FROM `db2_sanzioneacc` WHERE (`id_ente_sanzioneacc`='1') AND (`id_bollettario_sanzioneacc`='24617') ORDER BY `id_sanzioneacc` DESC LIMIT 20 |
13:33:14.235 | 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' |
13:33:14.315 | 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_sanzioneacc' AND kcu.table_name = 'db2_sanzioneacc' |
13:33:14.537 | 1.7 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='276' |
13:33:14.202 | 1.6 ms | yii\db\Command::query | SELECT * FROM `db2_decurtazionepunti` WHERE `id_bollettario_decurtazionepunti`='24617' |
13:33:14.271 | 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_nota' AND kcu.table_name = 'db2_nota' |
13:33:14.533 | 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_rateizzato' AND kcu.table_name = 'db2_rateizzato' |
13:33:14.428 | 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' |
13:33:14.438 | 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_verbaleveicolo' AND kcu.table_name = 'db2_verbaleveicolo' |
13:33:14.254 | 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 = 'istat2021' AND kcu.table_name = 'istat2021' |
13:33:14.584 | 1.6 ms | yii\db\Command::query | SELECT * FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=24617) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20)) LIMIT 20 |
13:33:14.335 | 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_agente' AND kcu.table_name = 'db1_agente' |
13:33:14.244 | 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 = 'articoli_new' AND kcu.table_name = 'articoli_new' |
13:33:14.464 | 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' |
13:33:14.423 | 1.6 ms | yii\db\Command::query | SELECT * FROM `db1_persona` WHERE `id_persona`=24261 |
13:33:14.500 | 1.6 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune`=110009 |
13:33:14.339 | 1.6 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=24617 |
13:33:14.558 | 1.6 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=65 |
13:33:14.482 | 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_verbaleazienda' AND kcu.table_name = 'db2_verbaleazienda' |
13:33:14.571 | 1.6 ms | yii\db\Command::query | SELECT * FROM `db1_persona` WHERE `id_persona`=24261 |
13:33:14.154 | 1.6 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=5 |
13:33:14.593 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=24617 |
13:33:14.519 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_docallegato` WHERE `id_bollettario_docallegato`='24617' LIMIT 20 |
13:33:14.598 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24617 ORDER BY `id_infrazione` DESC LIMIT 15 |
13:33:14.419 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=24617) AND (`tipo_proprietario`=0) LIMIT 20 |
13:33:14.540 | 1.5 ms | yii\db\Command::query | SELECT * FROM `istat2021` WHERE `id_articolo`=276 |
13:33:14.485 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=24617 |
13:33:14.512 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_notifica` WHERE `id_bollettario_notifica`='24617' |
13:33:14.498 | 1.5 ms | yii\db\Command::query | SELECT * FROM `istat2021` WHERE `id_articolo`=276 |
13:33:14.535 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_rateizzato` WHERE `id_bollettario_rateizzato`=24617 |
13:33:14.237 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`='24617' |
13:33:14.523 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=24617 |
13:33:14.517 | 1.5 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_docallegato` WHERE `id_bollettario_docallegato`='24617' |
13:33:14.469 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=24617) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20)) LIMIT 20 |
13:33:14.322 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=11 |
13:33:14.351 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db1_stradario` WHERE `COD_VIA`=231 |
13:33:14.495 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_infrazione`=27830 |
13:33:14.385 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=65 |
13:33:14.609 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune`=110009 |
13:33:14.601 | 1.4 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='276' |
13:33:14.568 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=24617) AND (`tipo_proprietario`=0) LIMIT 20 |
13:33:14.603 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_infrazione`=27830 |
13:33:14.472 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db1_persona` WHERE `id_persona`=24262 |
13:33:14.587 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db1_persona` WHERE `id_persona`=24262 |
13:33:14.227 | 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_notifica' AND kcu.table_name = 'db2_notifica' |
13:33:14.369 | 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_sottoscritti' AND kcu.table_name = 'db2_sottoscritti' |
13:33:14.606 | 1.4 ms | yii\db\Command::query | SELECT * FROM `istat2021` WHERE `id_articolo`=276 |
13:33:14.555 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=24617 ORDER BY `id_sottoscritti` DESC LIMIT 15 |
13:33:14.194 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`='1' |
13:33:14.542 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE (`id_bollettario_infrazione`=24617) AND (`id_ente_infrazione`=1) |
13:33:14.388 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=39 |
13:33:14.467 | 1.3 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=24617) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20)) |
13:33:14.562 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=15 |
13:33:14.320 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=31 |
13:33:14.578 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db1_veicolo` WHERE `id_veicolo`=20205 |
13:33:14.324 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=31 |
13:33:14.391 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=15 |
13:33:14.344 | 1.3 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_nota` WHERE (`id_ente_nota`=1) AND (`id_bollettario_nota`=24617) |
13:33:14.544 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=31 |
13:33:14.341 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`=1 |
13:33:14.514 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`=1 |
13:33:14.591 | 1.3 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_verbaleazienda` WHERE `id_bollettario_verbaleazienda`=24617 |
13:33:14.326 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=31 |
13:33:14.246 | 1.3 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='276' |
13:33:14.510 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db2_decurtazionepunti` WHERE `id_bollettario_decurtazionepunti`='24617' |
13:33:14.574 | 1.2 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=24617 |
13:33:14.548 | 1.2 ms | yii\db\Command::query | SELECT * FROM `db1_stradario` WHERE `COD_VIA`=231 |
13:33:14.553 | 1.2 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=24617 |
13:33:14.525 | 1.2 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`=1 |
13:33:14.582 | 1.2 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=24617) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20)) |
13:33:14.493 | 1.2 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='276' |
13:33:14.576 | 1.1 ms | yii\db\Command::query | SELECT * FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=24617 LIMIT 20 |
13:33:14.546 | 1.1 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=31 |
13:33:14.350 | 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_stradario' AND kcu.table_name = 'db1_stradario' |
13:33:14.508 | 1.1 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`='24617' |
13:33:14.596 | 1.1 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24617 |
13:33:14.488 | 1.1 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24617 |
13:33:14.566 | 1.0 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=24617) AND (`tipo_proprietario`=0) |
13:33:14.550 | 1.0 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune`=72038 |
13:33:14.490 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24617 ORDER BY `id_infrazione` DESC LIMIT 15 |
13:33:14.360 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune`=72038 |
13:33:14.560 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=39 |