Total processing time: 482 ms; Peak memory: 4.724 MB. Show Profiling Timeline
Time | Duration | Category | Info |
---|---|---|---|
09:00:11.506 | 2.7 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_bollettario` |
09:00:11.524 | 2.6 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_notifica` |
09:00:11.585 | 2.6 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `articoli_new` |
09:00:11.516 | 2.3 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_decurtazionepunti` |
09:00:11.567 | 2.2 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_infrazione` |
09:00:11.510 | 2.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_bollettario' AND kcu.table_name = 'db2_bollettario' |
09:00:11.615 | 2.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db0_comuni` |
09:00:11.549 | 2.0 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_docallegato` |
09:00:11.575 | 2.0 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_rateizzato` |
09:00:11.637 | 2.0 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_agente` |
09:00:11.532 | 2.0 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db0_ente` |
09:00:11.676 | 2.0 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_veicolo` |
09:00:11.629 | 1.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_sottoscritti' AND kcu.table_name = 'db2_sottoscritti' |
09:00:11.647 | 1.9 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_proprietario` |
09:00:11.518 | 1.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_decurtazionepunti' AND kcu.table_name = 'db2_decurtazionepunti' |
09:00:11.422 | 1.9 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db0_user` |
09:00:11.594 | 1.8 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `istat2021` |
09:00:11.656 | 1.8 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_persona` |
09:00:11.608 | 1.8 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_stradario` |
09:00:11.552 | 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' |
09:00:11.420 | 1.8 ms | yii\db\Connection::open | Opening DB connection: mysql:host=localhost;dbname=sanzioni1_0 |
09:00:11.668 | 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_verbaleveicolo' AND kcu.table_name = 'db2_verbaleveicolo' |
09:00:11.535 | 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_ente' AND kcu.table_name = 'db0_ente' |
09:00:11.521 | 1.7 ms | yii\db\Command::query | SELECT * FROM `db2_decurtazionepunti` WHERE `id_bollettario_decurtazionepunti`='21437' |
09:00:11.696 | 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_verbaleazienda' AND kcu.table_name = 'db2_verbaleazienda' |
09:00:11.649 | 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_proprietario' AND kcu.table_name = 'db2_proprietario' |
09:00:11.527 | 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_notifica' AND kcu.table_name = 'db2_notifica' |
09:00:11.627 | 1.7 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_sottoscritti` |
09:00:11.694 | 1.7 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_verbaleazienda` |
09:00:11.583 | 1.7 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='439' |
09:00:11.635 | 1.7 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=58 |
09:00:11.572 | 1.6 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE (`id_bollettario_infrazione`=21437) AND (`id_ente_infrazione`=1) |
09:00:11.674 | 1.6 ms | yii\db\Command::query | SELECT * FROM `db1_veicolo` WHERE `id_veicolo`=17606 |
09:00:11.679 | 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' |
09:00:11.530 | 1.6 ms | yii\db\Command::query | SELECT * FROM `db2_notifica` WHERE `id_bollettario_notifica`='21437' |
09:00:11.659 | 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' |
09:00:11.570 | 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_infrazione' AND kcu.table_name = 'db2_infrazione' |
09:00:11.666 | 1.6 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_verbaleveicolo` |
09:00:11.598 | 1.6 ms | yii\db\Command::query | SELECT * FROM `db2_notifica` WHERE `id_bollettario_notifica`=21437 ORDER BY `id_notifica` |
09:00:11.513 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`='21437' |
09:00:11.654 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db1_persona` WHERE `id_persona`=22090 |
09:00:11.596 | 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 = 'istat2021' AND kcu.table_name = 'istat2021' |
09:00:11.700 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=21437 |
09:00:11.618 | 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_comuni' AND kcu.table_name = 'db0_comuni' |
09:00:11.705 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=21437 ORDER BY `id_infrazione` DESC LIMIT 15 |
09:00:11.578 | 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_rateizzato' AND kcu.table_name = 'db2_rateizzato' |
09:00:11.664 | 1.5 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=21437 |
09:00:11.670 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=21437 LIMIT 20 |
09:00:11.592 | 1.5 ms | yii\db\Command::query | SELECT * FROM `istat2021` WHERE `id_articolo`=439 |
09:00:11.563 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=21437 |
09:00:11.547 | 1.4 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_docallegato` WHERE `id_bollettario_docallegato`='21437' |
09:00:11.555 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db2_docallegato` WHERE `id_bollettario_docallegato`='21437' LIMIT 20 |
09:00:11.692 | 1.4 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_verbaleazienda` WHERE `id_bollettario_verbaleazienda`=21437 |
09:00:11.426 | 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 = 'db0_user' AND kcu.table_name = 'db0_user' |
09:00:11.565 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`=1 |
09:00:11.625 | 1.4 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=21437 |
09:00:11.688 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db1_persona` WHERE `id_persona`=20943 |
09:00:11.645 | 1.4 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=21437) AND (`tipo_proprietario`=0) |
09:00:11.537 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`=1 |
09:00:11.709 | 1.4 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='439' |
09:00:11.685 | 1.3 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 |
09:00:11.714 | 1.3 ms | yii\db\Command::query | SELECT * FROM `istat2021` WHERE `id_articolo`=439 |
09:00:11.610 | 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 = 'db1_stradario' AND kcu.table_name = 'db1_stradario' |
09:00:11.589 | 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' |
09:00:11.683 | 1.3 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=21437) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20)) |
09:00:11.631 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=21437 ORDER BY `id_sottoscritti` DESC LIMIT 15 |
09:00:11.703 | 1.3 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=21437 |
09:00:11.620 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune`=72038 |
09:00:11.602 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=66 |
09:00:11.711 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_infrazione`=24118 |
09:00:11.640 | 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 = 'db1_agente' AND kcu.table_name = 'db1_agente' |
09:00:11.612 | 1.2 ms | yii\db\Command::query | SELECT * FROM `db1_stradario` WHERE `COD_VIA`=231 |
09:00:11.431 | 1.2 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=59 |
09:00:11.604 | 1.2 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=66 |
09:00:11.600 | 1.1 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE (`id_bollettario_infrazione`=21437) AND (`id_ente_infrazione`=1) |
09:00:11.580 | 1.1 ms | yii\db\Command::query | SELECT * FROM `db2_rateizzato` WHERE `id_bollettario_rateizzato`=21437 |
09:00:11.716 | 1.0 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune`=110009 |
09:00:11.651 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=21437) AND (`tipo_proprietario`=0) LIMIT 20 |