Total processing time: 502 ms; Peak memory: 5.378 MB. Show Profiling Timeline
Time | Duration | Category | Info |
---|---|---|---|
13:08:09.868 | 22.4 ms | yii\db\Command::query | SELECT * FROM `db1_stradario` WHERE `COD_VIA`=164655 |
13:08:09.908 | 16.4 ms | yii\db\Command::query | SELECT * FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=8922 ORDER BY `id_sottoscritti` DESC LIMIT 15 |
13:08:09.955 | 16.2 ms | yii\db\Command::query | SELECT * FROM `db1_persona` WHERE `id_persona`=7901 |
13:08:09.933 | 13.3 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=8922) AND (`tipo_proprietario`=0) |
13:08:09.740 | 6.4 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_bollettario` |
13:08:09.705 | 3.6 ms | yii\db\Connection::open | Opening DB connection: mysql:host=localhost;dbname=sanzioni1_0 |
13:08:09.748 | 3.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' |
13:08:09.755 | 3.2 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db0_ente` |
13:08:09.709 | 3.2 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db0_user` |
13:08:09.787 | 3.0 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `articoli_new` |
13:08:09.764 | 2.9 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_decurtazionepunti` |
13:08:09.713 | 2.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_user' AND kcu.table_name = 'db0_user' |
13:08:09.759 | 2.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:08:09.779 | 2.5 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_infrazione` |
13:08:09.752 | 2.2 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`='8922' |
13:08:09.972 | 2.2 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_persona` |
13:08:10.051 | 2.2 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_rateizzato` |
13:08:09.797 | 2.1 ms | yii\db\Command::query | SELECT * FROM `istat2019` WHERE `id_articolo`=1494 |
13:08:09.838 | 2.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_sanzioneacc` |
13:08:09.893 | 2.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db0_comuni` |
13:08:09.720 | 2.1 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=17 |
13:08:09.773 | 2.1 ms | yii\db\Command::query | SELECT * FROM `db2_notifica` WHERE `id_bollettario_notifica`='8922' ORDER BY `id_notifica` DESC |
13:08:09.849 | 2.0 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_agente` |
13:08:09.864 | 2.0 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_stradario` |
13:08:09.768 | 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:08:09.984 | 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_verbaleveicolo' AND kcu.table_name = 'db2_verbaleveicolo' |
13:08:10.031 | 1.9 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_notifica` |
13:08:09.835 | 1.8 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_sanzioneacc` WHERE (`id_ente_sanzioneacc`='1') AND (`id_bollettario_sanzioneacc`='8922') |
13:08:09.949 | 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:08:09.998 | 1.8 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_verbaleazienda` WHERE `id_bollettario_verbaleazienda`=8922 |
13:08:09.802 | 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 = 'istat2019' AND kcu.table_name = 'istat2019' |
13:08:09.947 | 1.8 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_proprietario` |
13:08:09.826 | 1.8 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_docallegato` WHERE `id_bollettario_docallegato`='8922' |
13:08:09.813 | 1.8 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_nota` WHERE (`id_ente_nota`='1') AND (`id_bollettario_nota`='8922') |
13:08:09.902 | 1.7 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=8922 |
13:08:09.800 | 1.7 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `istat2019` |
13:08:09.980 | 1.7 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=8922 |
13:08:09.904 | 1.7 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_sottoscritti` |
13:08:09.841 | 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:08:09.782 | 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:08:10.110 | 1.7 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=8922 ORDER BY `id_infrazione` DESC LIMIT 15 |
13:08:10.062 | 1.7 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE (`id_bollettario_infrazione`=8922) AND (`id_ente_infrazione`=1) |
13:08:10.034 | 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_notifica' AND kcu.table_name = 'db2_notifica' |
13:08:09.866 | 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_stradario' AND kcu.table_name = 'db1_stradario' |
13:08:09.817 | 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:08:10.053 | 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:08:09.895 | 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 = 'db0_comuni' AND kcu.table_name = 'db0_comuni' |
13:08:09.990 | 1.6 ms | yii\db\Command::query | SELECT * FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=8922) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20)) LIMIT 20 |
13:08:10.057 | 1.6 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='1494' |
13:08:09.831 | 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_docallegato' AND kcu.table_name = 'db2_docallegato' |
13:08:09.784 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`='8922' |
13:08:09.829 | 1.5 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_docallegato` |
13:08:10.009 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=8922 ORDER BY `id_infrazione` DESC LIMIT 15 |
13:08:09.906 | 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_sottoscritti' AND kcu.table_name = 'db2_sottoscritti' |
13:08:09.770 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_decurtazionepunti` WHERE `id_bollettario_decurtazionepunti`='8922' |
13:08:09.762 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`='1' |
13:08:10.075 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=8922 ORDER BY `id_sottoscritti` DESC LIMIT 15 |
13:08:09.791 | 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 = 'articoli_new' AND kcu.table_name = 'articoli_new' |
13:08:10.113 | 1.5 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='1494' |
13:08:09.848 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=29 |
13:08:09.793 | 1.5 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='1494' |
13:08:09.975 | 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 = 'db1_persona' AND kcu.table_name = 'db1_persona' |
13:08:09.856 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=8922 |
13:08:09.815 | 1.5 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_nota` |
13:08:09.982 | 1.5 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_verbaleveicolo` |
13:08:09.852 | 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 = 'db1_agente' AND kcu.table_name = 'db1_agente' |
13:08:10.088 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db1_persona` WHERE `id_persona`=7901 |
13:08:10.027 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`='8922' |
13:08:10.070 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune`=72004 |
13:08:09.993 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db1_persona` WHERE `id_persona`=7901 |
13:08:10.048 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE (`id_bollettario_infrazione`=8922) AND (`id_ente_infrazione`=1) |
13:08:10.118 | 1.4 ms | yii\db\Command::query | SELECT * FROM `istat2019` WHERE `id_articolo`=1494 |
13:08:10.115 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_infrazione`=9770 |
13:08:09.952 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=8922) AND (`tipo_proprietario`=0) LIMIT 20 |
13:08:10.103 | 1.4 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_verbaleazienda` WHERE `id_bollettario_verbaleazienda`=8922 |
13:08:10.099 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db1_persona` WHERE `id_persona`=7901 |
13:08:10.017 | 1.4 ms | yii\db\Command::query | SELECT * FROM `istat2019` WHERE `id_articolo`=1494 |
13:08:10.041 | 1.4 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_docallegato` WHERE `id_bollettario_docallegato`='8922' |
13:08:10.046 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`=1 |
13:08:10.007 | 1.4 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=8922 |
13:08:10.105 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=8922 |
13:08:10.036 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db2_notifica` WHERE `id_bollettario_notifica`='8922' |
13:08:10.083 | 1.4 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=8922) AND (`tipo_proprietario`=0) |
13:08:10.066 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=31 |
13:08:10.085 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=8922) AND (`tipo_proprietario`=0) LIMIT 20 |
13:08:10.095 | 1.4 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=8922) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20)) |
13:08:09.928 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=29 |
13:08:10.060 | 1.3 ms | yii\db\Command::query | SELECT * FROM `istat2019` WHERE `id_articolo`=1494 |
13:08:09.926 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=35 |
13:08:09.988 | 1.3 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=8922) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20)) |
13:08:10.056 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db2_rateizzato` WHERE `id_bollettario_rateizzato`=8922 |
13:08:10.030 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db2_decurtazionepunti` WHERE `id_bollettario_decurtazionepunti`='8922' |
13:08:10.015 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_infrazione`=9770 |
13:08:09.858 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`=1 |
13:08:10.108 | 1.3 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=8922 |
13:08:10.038 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`=1 |
13:08:10.078 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=35 |
13:08:10.068 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db1_stradario` WHERE `COD_VIA`=164655 |
13:08:10.004 | 1.2 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=8922 |
13:08:10.092 | 1.2 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=8922 |
13:08:10.013 | 1.2 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='1494' |
13:08:09.843 | 1.2 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=31 |
13:08:10.020 | 1.2 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune` IS NULL |
13:08:10.001 | 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_verbaleazienda' AND kcu.table_name = 'db2_verbaleazienda' |
13:08:10.044 | 1.1 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=8922 |
13:08:10.000 | 1.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_verbaleazienda` |
13:08:10.097 | 1.1 ms | yii\db\Command::query | SELECT * FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=8922) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20)) LIMIT 20 |
13:08:09.897 | 1.1 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune`=72004 |
13:08:09.861 | 1.1 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_nota` WHERE (`id_ente_nota`=1) AND (`id_bollettario_nota`=8922) |
13:08:09.845 | 1.0 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=31 |
13:08:10.064 | 1.0 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=31 |
13:08:10.073 | 1.0 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=8922 |
13:08:10.080 | 1.0 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=29 |
13:08:10.121 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune` IS NULL |