Total processing time: 487 ms; Peak memory: 4.348 MB. Show Profiling Timeline
Time | Duration | Category | Info |
---|---|---|---|
16:41:17.660 | 72.8 ms | yii\db\Command::query | SELECT * FROM `db2_alertdoc` WHERE (`id_ente_alertdoc`=1) AND (`id_bollettario_alertdoc`=18749) |
16:41:17.633 | 25.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_alertdoc` |
16:41:17.562 | 2.2 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_bollettario` |
16:41:17.472 | 2.1 ms | yii\db\Connection::open | Opening DB connection: mysql:host=localhost;dbname=sanzioni1_0 |
16:41:17.575 | 1.9 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_docallegato` |
16:41:17.569 | 1.8 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db0_ente` |
16:41:17.791 | 1.7 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `articoli_new` |
16:41:17.811 | 1.6 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db0_comuni` |
16:41:17.755 | 1.6 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_notifica` |
16:41:17.778 | 1.5 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_infrazione` |
16:41:17.847 | 1.4 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_persona` |
16:41:17.565 | 1.3 ms | yii\db\Command::query | SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'db2_bollettario' AND kcu.table_name = 'db2_bollettario' |
16:41:17.577 | 1.3 ms | yii\db\Command::query | SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'db2_docallegato' AND kcu.table_name = 'db2_docallegato' |
16:41:17.750 | 1.3 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_decurtazionepunti` |
16:41:17.474 | 1.3 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db0_user` |
16:41:17.571 | 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_ente' AND kcu.table_name = 'db0_ente' |
16:41:17.784 | 1.3 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_rateizzato` |
16:41:17.806 | 1.3 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_stradario` |
16:41:17.828 | 1.3 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_agente` |
16:41:17.567 | 1.2 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`='18749' |
16:41:17.849 | 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' |
16:41:17.477 | 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 = 'db0_user' AND kcu.table_name = 'db0_user' |
16:41:17.862 | 1.2 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_veicolo` |
16:41:17.659 | 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_alertdoc' AND kcu.table_name = 'db2_alertdoc' |
16:41:17.840 | 1.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_proprietario` |
16:41:17.820 | 1.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_sottoscritti` |
16:41:17.814 | 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 = 'db0_comuni' AND kcu.table_name = 'db0_comuni' |
16:41:17.798 | 1.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `istat2021` |
16:41:17.877 | 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' |
16:41:17.876 | 1.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_verbaleazienda` |
16:41:17.780 | 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' |
16:41:17.855 | 1.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_verbaleveicolo` |
16:41:17.786 | 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_rateizzato' AND kcu.table_name = 'db2_rateizzato' |
16:41:17.790 | 1.0 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='1425' |
16:41:17.842 | 1.0 ms | yii\db\Command::query | SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'db2_proprietario' AND kcu.table_name = 'db2_proprietario' |
16:41:17.822 | 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' |
16:41:17.864 | 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_veicolo' AND kcu.table_name = 'db1_veicolo' |
16:41:17.752 | 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' |
16:41:17.830 | 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' |
16:41:17.758 | 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' |
16:41:17.799 | 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' |
16:41:17.782 | 1.0 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE (`id_bollettario_infrazione`=18749) AND (`id_ente_infrazione`=1) |
16:41:17.856 | 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_verbaleveicolo' AND kcu.table_name = 'db2_verbaleveicolo' |
16:41:17.794 | 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' |
16:41:17.748 | 1.0 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`='18749' |
16:41:17.753 | 1.0 ms | yii\db\Command::query | SELECT * FROM `db2_decurtazionepunti` WHERE `id_bollettario_decurtazionepunti`='18749' |
16:41:17.796 | 1.0 ms | yii\db\Command::query | SELECT * FROM `istat2021` WHERE `id_articolo`=1425 |
16:41:17.839 | 0.9 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=18749) AND (`tipo_proprietario`=0) |
16:41:17.846 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db1_persona` WHERE `id_persona`=18307 |
16:41:17.867 | 0.9 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=18749) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20)) |
16:41:17.861 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db1_veicolo` WHERE `id_veicolo`=15363 |
16:41:17.759 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_notifica` WHERE `id_bollettario_notifica`='18749' |
16:41:17.827 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=60 |
16:41:17.770 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_docallegato` WHERE `id_bollettario_docallegato`='18749' LIMIT 20 |
16:41:17.854 | 0.9 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=18749 |
16:41:17.819 | 0.9 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=18749 |
16:41:17.808 | 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' |
16:41:17.886 | 0.9 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='1425' |
16:41:17.823 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=18749 ORDER BY `id_sottoscritti` DESC LIMIT 15 |
16:41:17.890 | 0.9 ms | yii\db\Command::query | SELECT * FROM `istat2021` WHERE `id_articolo`=1425 |
16:41:17.868 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=18749) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20)) LIMIT 20 |
16:41:17.880 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=18749 |
16:41:17.858 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=18749 LIMIT 20 |
16:41:17.874 | 0.8 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_verbaleazienda` WHERE `id_bollettario_verbaleazienda`=18749 |
16:41:17.801 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE (`id_bollettario_infrazione`=18749) AND (`id_ente_infrazione`=1) |
16:41:17.482 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=11 |
16:41:17.883 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=18749 ORDER BY `id_infrazione` DESC LIMIT 15 |
16:41:17.775 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=18749 |
16:41:17.579 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_docallegato` WHERE `id_docallegato`='11590' |
16:41:17.802 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=11 |
16:41:17.843 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=18749) AND (`tipo_proprietario`=0) LIMIT 20 |
16:41:17.573 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`='1' |
16:41:17.882 | 0.8 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=18749 |
16:41:17.833 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=55 |
16:41:17.767 | 0.7 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_docallegato` WHERE `id_bollettario_docallegato`='18749' |
16:41:17.835 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=38 |
16:41:17.870 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db1_persona` WHERE `id_persona`=18307 |
16:41:17.787 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db2_rateizzato` WHERE `id_bollettario_rateizzato`=18749 |
16:41:17.888 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_infrazione`=21328 |
16:41:17.892 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune`=72006 |
16:41:17.760 | 0.6 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`=1 |
16:41:17.804 | 0.6 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=11 |
16:41:17.815 | 0.6 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune`=72002 |
16:41:17.809 | 0.6 ms | yii\db\Command::query | SELECT * FROM `db1_stradario` WHERE `COD_VIA`=14546 |
16:41:17.777 | 0.5 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`=1 |