Total processing time: 373 ms; Peak memory: 5.464 MB. Show Profiling Timeline
Time | Duration | Category | Info |
---|---|---|---|
13:14:47.432 | 1.9 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `articoli_new` |
13:14:47.449 | 1.8 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_bollettario` |
13:14:47.292 | 1.8 ms | yii\db\Connection::open | Opening DB connection: mysql:host=localhost;dbname=sanzioni1_0 |
13:14:47.320 | 1.8 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db3_bollettario_acc` |
13:14:47.477 | 1.6 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_infrazione` |
13:14:47.366 | 1.5 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db0_comuni` |
13:14:47.408 | 1.5 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_persona` |
13:14:47.455 | 1.5 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_decurtazionepunti` |
13:14:47.469 | 1.4 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_docallegato` |
13:14:47.460 | 1.4 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_notifica` |
13:14:47.342 | 1.4 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_agente` |
13:14:47.483 | 1.3 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_rateizzato` |
13:14:47.294 | 1.3 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db0_user` |
13:14:47.361 | 1.3 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_stradario` |
13:14:47.424 | 1.2 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db3_infrazione_acc` |
13:14:47.355 | 1.2 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db3_docallegato_acc` |
13:14:47.399 | 1.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_veicolo` |
13:14:47.385 | 1.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db3_proprietario_acc` |
13:14:47.490 | 1.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `istat2019` |
13:14:47.542 | 1.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_verbaleazienda` |
13:14:47.479 | 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' |
13:14:47.323 | 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 = 'db3_bollettario_acc' AND kcu.table_name = 'db3_bollettario_acc' |
13:14:47.503 | 1.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_sottoscritti` |
13:14:47.326 | 1.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db0_ente` |
13:14:47.376 | 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 = 'db3_sottoscritti_acc' AND kcu.table_name = 'db3_sottoscritti_acc' |
13:14:47.527 | 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' |
13:14:47.357 | 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 = 'db3_docallegato_acc' AND kcu.table_name = 'db3_docallegato_acc' |
13:14:47.411 | 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' |
13:14:47.517 | 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' |
13:14:47.375 | 1.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db3_sottoscritti_acc` |
13:14:47.543 | 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' |
13:14:47.516 | 1.0 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_proprietario` |
13:14:47.416 | 1.0 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db3_verbaleazienda_acc` |
13:14:47.387 | 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 = 'db3_proprietario_acc' AND kcu.table_name = 'db3_proprietario_acc' |
13:14:47.462 | 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_notifica' AND kcu.table_name = 'db2_notifica' |
13:14:47.392 | 1.0 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db3_verbaleveicolo_acc` |
13:14:47.492 | 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' |
13:14:47.505 | 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' |
13:14:47.435 | 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' |
13:14:47.457 | 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' |
13:14:47.393 | 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 = 'db3_verbaleveicolo_acc' AND kcu.table_name = 'db3_verbaleveicolo_acc' |
13:14:47.526 | 1.0 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_verbaleveicolo` |
13:14:47.297 | 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' |
13:14:47.452 | 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' |
13:14:47.474 | 1.0 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=3566 |
13:14:47.417 | 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 = 'db3_verbaleazienda_acc' AND kcu.table_name = 'db3_verbaleazienda_acc' |
13:14:47.426 | 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 = 'db3_infrazione_acc' AND kcu.table_name = 'db3_infrazione_acc' |
13:14:47.362 | 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_stradario' AND kcu.table_name = 'db1_stradario' |
13:14:47.374 | 1.0 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db3_sottoscritti_acc` WHERE `id_bollettario_sottoscritti_acc`=3566 |
13:14:47.328 | 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_ente' AND kcu.table_name = 'db0_ente' |
13:14:47.354 | 1.0 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db3_docallegato_acc` WHERE `id_bollettario_acc_docallegato_acc`='3566' |
13:14:47.423 | 1.0 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db3_infrazione_acc` WHERE `id_bollettario_infrazione_acc`=3566 |
13:14:47.514 | 1.0 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=3566) AND (`tipo_proprietario`=0) |
13:14:47.552 | 1.0 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='1425' |
13:14:47.471 | 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_docallegato' AND kcu.table_name = 'db2_docallegato' |
13:14:47.415 | 1.0 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db3_verbaleazienda_acc` WHERE `id_bollettario_verbaleazienda_acc`=3566 |
13:14:47.344 | 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' |
13:14:47.378 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db3_sottoscritti_acc` WHERE `id_bollettario_sottoscritti_acc`=3566 ORDER BY `id_sottoscritti_acc` DESC LIMIT 15 |
13:14:47.341 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=58 |
13:14:47.550 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=3566 ORDER BY `id_infrazione` DESC LIMIT 15 |
13:14:47.535 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=3566) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20)) LIMIT 20 |
13:14:47.489 | 0.9 ms | yii\db\Command::query | SELECT * FROM `istat2019` WHERE `id_articolo`=1425 |
13:14:47.420 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db3_bollettario_acc` WHERE `id_bollettario_acc`=3566 |
13:14:47.481 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE (`id_bollettario_infrazione`=3566) AND (`id_ente_infrazione`=1) |
13:14:47.453 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`='3566' |
13:14:47.400 | 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' |
13:14:47.458 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_decurtazionepunti` WHERE `id_bollettario_decurtazionepunti`='3566' |
13:14:47.485 | 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' |
13:14:47.391 | 0.9 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db3_verbaleveicolo_acc` WHERE `id_bollettario_verbaleveicolo_acc`=3566 |
13:14:47.493 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE (`id_bollettario_infrazione`=3566) AND (`id_ente_infrazione`=1) |
13:14:47.384 | 0.9 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db3_proprietario_acc` WHERE (`id_bollettario_proprietario_acc`=3566) AND (`tipo_proprietario_acc`=0) |
13:14:47.525 | 0.9 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=3566 |
13:14:47.368 | 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' |
13:14:47.546 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=3566 |
13:14:47.436 | 0.9 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='1318' |
13:14:47.398 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db1_veicolo` WHERE `id_veicolo`=16948 |
13:14:47.407 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db1_persona` WHERE `id_persona`=20294 |
13:14:47.541 | 0.9 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_verbaleazienda` WHERE `id_bollettario_verbaleazienda`=3566 |
13:14:47.510 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=32 |
13:14:47.403 | 0.8 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db3_proprietario_acc` WHERE (`id_bollettario_proprietario_acc`=3566) AND (`tipo_proprietario_acc` IN (1, 2, 3, 4, 20)) |
13:14:47.468 | 0.8 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_docallegato` WHERE `id_bollettario_docallegato`='3566' |
13:14:47.502 | 0.8 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=3566 |
13:14:47.487 | 0.8 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='1425' |
13:14:47.428 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db3_infrazione_acc` WHERE `id_bollettario_infrazione_acc`=3566 ORDER BY `id_infrazione_acc` DESC LIMIT 15 |
13:14:47.556 | 0.8 ms | yii\db\Command::query | SELECT * FROM `istat2019` WHERE `id_articolo`=1425 |
13:14:47.506 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=3566 ORDER BY `id_sottoscritti` DESC LIMIT 15 |
13:14:47.521 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db1_persona` WHERE `id_persona`=2844 |
13:14:47.534 | 0.8 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=3566) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20)) |
13:14:47.496 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=8 |
13:14:47.464 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_notifica` WHERE `id_bollettario_notifica`='3566' |
13:14:47.324 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db3_bollettario_acc` WHERE `id_bollettario_acc`='3566' |
13:14:47.519 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=3566) AND (`tipo_proprietario`=0) LIMIT 20 |
13:14:47.337 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=59 |
13:14:47.475 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`=1 |
13:14:47.549 | 0.8 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=3566 |
13:14:47.537 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db1_persona` WHERE `id_persona`=2845 |
13:14:47.529 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=3566 LIMIT 20 |
13:14:47.531 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db1_veicolo` WHERE `id_veicolo`=3089 |
13:14:47.394 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db3_verbaleveicolo_acc` WHERE `id_bollettario_verbaleveicolo_acc`=3566 LIMIT 20 |
13:14:47.554 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_infrazione`=3838 |
13:14:47.558 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune`=72020 |
13:14:47.405 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db3_proprietario_acc` WHERE (`id_bollettario_proprietario_acc`=3566) AND (`tipo_proprietario_acc` IN (1, 2, 3, 4, 20)) LIMIT 20 |
13:14:47.465 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`=1 |
13:14:47.380 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=58 |
13:14:47.438 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db3_infrazione_acc` WHERE `id_infrazione_acc`=3640 |
13:14:47.369 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune`=72006 |
13:14:47.440 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune`=72006 |
13:14:47.338 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=59 |
13:14:47.301 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=4 |
13:14:47.486 | 0.6 ms | yii\db\Command::query | SELECT * FROM `db2_rateizzato` WHERE `id_bollettario_rateizzato`=3566 |
13:14:47.498 | 0.6 ms | yii\db\Command::query | SELECT * FROM `db1_stradario` WHERE `COD_VIA`=85 |
13:14:47.508 | 0.6 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=42 |
13:14:47.495 | 0.6 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=8 |
13:14:47.364 | 0.6 ms | yii\db\Command::query | SELECT * FROM `db1_stradario` WHERE `COD_VIA`=56577 |
13:14:47.329 | 0.6 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`='1' |
13:14:47.499 | 0.5 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune` IS NULL |