Total processing time: 1,012 ms; Peak memory: 5.940 MB. Show Profiling Timeline
Time | Duration | Category | Info |
---|---|---|---|
12:44:31.270 | 112.6 ms | yii\db\Command::query | SELECT * FROM `db2_notifica` WHERE `id_bollettario_notifica`='9374' ORDER BY `id_notifica` DESC |
12:44:31.156 | 112.4 ms | yii\db\Command::query | SELECT * FROM `db2_decurtazionepunti` WHERE `id_bollettario_decurtazionepunti`='9374' |
12:44:31.622 | 44.0 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_sanzioneacc` WHERE (`id_ente_sanzioneacc`='1') AND (`id_bollettario_sanzioneacc`='9374') |
12:44:31.458 | 39.6 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_nota` WHERE (`id_ente_nota`='1') AND (`id_bollettario_nota`='9374') |
12:44:31.576 | 18.9 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_docallegato` WHERE `id_bollettario_docallegato`='9374' |
12:44:31.503 | 18.8 ms | yii\db\Command::query | SELECT * FROM `db2_nota` WHERE (`id_ente_nota`='1') AND (`id_bollettario_nota`='9374') ORDER BY `id_nota` DESC LIMIT 20 |
12:44:31.601 | 17.1 ms | yii\db\Command::query | SELECT * FROM `db2_docallegato` WHERE `id_bollettario_docallegato`='9374' LIMIT 20 |
12:44:31.763 | 16.6 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=9374 |
12:44:31.429 | 15.6 ms | yii\db\Command::query | SELECT * FROM `istat2019` WHERE `id_articolo`=1425 |
12:44:31.798 | 15.3 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=9374) AND (`tipo_proprietario`=0) |
12:44:31.832 | 15.2 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=9374 |
12:44:31.857 | 10.4 ms | yii\db\Command::query | SELECT * FROM `db1_veicolo` WHERE `id_veicolo`=7794 |
12:44:31.784 | 4.6 ms | yii\db\Command::query | SELECT * FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=9374 ORDER BY `id_sottoscritti` DESC LIMIT 15 |
12:44:31.104 | 3.1 ms | yii\db\Connection::open | Opening DB connection: mysql:host=localhost;dbname=sanzioni1_0 |
12:44:31.401 | 3.0 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `articoli_new` |
12:44:31.852 | 2.5 ms | yii\db\Command::query | SELECT * FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=9374 LIMIT 20 |
12:44:31.136 | 2.4 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_bollettario` |
12:44:31.151 | 2.4 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_decurtazionepunti` |
12:44:31.707 | 2.3 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=42 |
12:44:31.946 | 2.3 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_rateizzato` |
12:44:31.824 | 2.3 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_persona` |
12:44:31.746 | 2.2 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_stradario` |
12:44:31.666 | 2.2 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_sanzioneacc` |
12:44:31.868 | 2.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_veicolo` |
12:44:31.382 | 2.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_notifica` |
12:44:31.753 | 2.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db0_comuni` |
12:44:31.595 | 2.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_docallegato` |
12:44:31.393 | 2.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_infrazione` |
12:44:31.145 | 2.0 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db0_ente` |
12:44:31.884 | 2.0 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_verbaleazienda` WHERE `id_bollettario_verbaleazienda`=9374 |
12:44:31.499 | 1.9 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_nota` |
12:44:31.710 | 1.9 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_agente` |
12:44:31.107 | 1.9 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db0_user` |
12:44:31.395 | 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_infrazione' AND kcu.table_name = 'db2_infrazione' |
12:44:31.871 | 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 = 'db1_veicolo' AND kcu.table_name = 'db1_veicolo' |
12:44:31.943 | 1.9 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE (`id_bollettario_infrazione`=9374) AND (`id_ente_infrazione`=1) |
12:44:31.598 | 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' |
12:44:31.814 | 1.8 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_proprietario` |
12:44:31.670 | 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_sanzioneacc' AND kcu.table_name = 'db2_sanzioneacc' |
12:44:31.827 | 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 = 'db1_persona' AND kcu.table_name = 'db1_persona' |
12:44:31.887 | 1.8 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_verbaleazienda` |
12:44:31.140 | 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_bollettario' AND kcu.table_name = 'db2_bollettario' |
12:44:31.782 | 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_sottoscritti' AND kcu.table_name = 'db2_sottoscritti' |
12:44:31.385 | 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_notifica' AND kcu.table_name = 'db2_notifica' |
12:44:31.780 | 1.7 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_sottoscritti` |
12:44:31.447 | 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 = 'istat2019' AND kcu.table_name = 'istat2019' |
12:44:31.722 | 1.7 ms | yii\db\Command::query | SELECT * FROM `db2_nota` WHERE (`id_ente_nota`=1) AND (`id_bollettario_nota`=9374) ORDER BY `id_nota` DESC LIMIT 20 |
12:44:31.444 | 1.7 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `istat2019` |
12:44:31.848 | 1.7 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_verbaleveicolo` |
12:44:31.957 | 1.7 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE (`id_bollettario_infrazione`=9374) AND (`id_ente_infrazione`=1) |
12:44:31.756 | 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' |
12:44:31.111 | 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_user' AND kcu.table_name = 'db0_user' |
12:44:31.816 | 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_proprietario' AND kcu.table_name = 'db2_proprietario' |
12:44:31.889 | 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' |
12:44:31.850 | 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' |
12:44:31.142 | 1.6 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`='9374' |
12:44:31.672 | 1.6 ms | yii\db\Command::query | SELECT * FROM `db2_sanzioneacc` WHERE (`id_ente_sanzioneacc`='1') AND (`id_bollettario_sanzioneacc`='9374') ORDER BY `id_sanzioneacc` DESC LIMIT 20 |
12:44:31.501 | 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' |
12:44:31.713 | 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' |
12:44:31.822 | 1.6 ms | yii\db\Command::query | SELECT * FROM `db1_persona` WHERE `id_persona`=8366 |
12:44:31.405 | 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' |
12:44:31.949 | 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' |
12:44:31.560 | 1.6 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=9374 |
12:44:31.898 | 1.6 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=9374 ORDER BY `id_infrazione` DESC LIMIT 15 |
12:44:31.934 | 1.6 ms | yii\db\Command::query | SELECT * FROM `db2_docallegato` WHERE `id_bollettario_docallegato`='9374' LIMIT 20 |
12:44:31.538 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=9374 |
12:44:31.953 | 1.5 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='1425' |
12:44:31.901 | 1.5 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='1425' |
12:44:31.938 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=9374 |
12:44:31.971 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=9374 ORDER BY `id_sottoscritti` DESC LIMIT 15 |
12:44:32.014 | 1.5 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='1425' |
12:44:31.408 | 1.5 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='1425' |
12:44:31.951 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_rateizzato` WHERE `id_bollettario_rateizzato`=9374 |
12:44:31.926 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_notifica` WHERE `id_bollettario_notifica`='9374' |
12:44:31.715 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=9374 |
12:44:31.720 | 1.5 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_nota` WHERE (`id_ente_nota`=1) AND (`id_bollettario_nota`=9374) |
12:44:31.893 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=9374 |
12:44:31.880 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db1_persona` WHERE `id_persona`=8367 |
12:44:31.921 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`='9374' |
12:44:32.011 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=9374 ORDER BY `id_infrazione` DESC LIMIT 15 |
12:44:32.001 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db1_persona` WHERE `id_persona`=8367 |
12:44:31.750 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db1_stradario` WHERE `COD_VIA`=144 |
12:44:31.877 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=9374) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20)) LIMIT 20 |
12:44:31.974 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=32 |
12:44:31.147 | 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_ente' AND kcu.table_name = 'db0_ente' |
12:44:31.116 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=5 |
12:44:31.793 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=42 |
12:44:31.398 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`='9374' |
12:44:31.980 | 1.4 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=9374) AND (`tipo_proprietario`=0) |
12:44:31.699 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=11 |
12:44:31.981 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=9374) AND (`tipo_proprietario`=0) LIMIT 20 |
12:44:31.969 | 1.4 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=9374 |
12:44:31.818 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=9374) AND (`tipo_proprietario`=0) LIMIT 20 |
12:44:31.909 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune`=72006 |
12:44:31.924 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db2_decurtazionepunti` WHERE `id_bollettario_decurtazionepunti`='9374' |
12:44:31.896 | 1.4 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=9374 |
12:44:31.998 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=9374) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20)) LIMIT 20 |
12:44:31.565 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=8 |
12:44:31.932 | 1.4 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_docallegato` WHERE `id_bollettario_docallegato`='9374' |
12:44:31.988 | 1.3 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=9374 |
12:44:31.955 | 1.3 ms | yii\db\Command::query | SELECT * FROM `istat2019` WHERE `id_articolo`=1425 |
12:44:31.990 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=9374 LIMIT 20 |
12:44:31.790 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=32 |
12:44:31.993 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db1_veicolo` WHERE `id_veicolo`=7794 |
12:44:31.536 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db2_nota` WHERE `id_nota`=1382 |
12:44:31.875 | 1.3 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=9374) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20)) |
12:44:31.738 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=31 |
12:44:32.021 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune`=72006 |
12:44:31.558 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db2_nota` WHERE `id_nota`=1202 |
12:44:31.694 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=5 |
12:44:31.692 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=5 |
12:44:31.962 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=11 |
12:44:31.964 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db1_stradario` WHERE `COD_VIA`=144 |
12:44:32.004 | 1.3 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_verbaleazienda` WHERE `id_bollettario_verbaleazienda`=9374 |
12:44:31.567 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=5 |
12:44:32.009 | 1.3 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=9374 |
12:44:31.552 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=31 |
12:44:31.149 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`='1' |
12:44:31.736 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=31 |
12:44:31.554 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=31 |
12:44:31.741 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=8 |
12:44:31.702 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=11 |
12:44:31.928 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`=1 |
12:44:31.960 | 1.2 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=11 |
12:44:31.758 | 1.2 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune`=89005 |
12:44:31.941 | 1.2 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`=1 |
12:44:31.717 | 1.2 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`=1 |
12:44:31.704 | 1.2 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=11 |
12:44:31.697 | 1.2 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=11 |
12:44:31.984 | 1.2 ms | yii\db\Command::query | SELECT * FROM `db1_persona` WHERE `id_persona`=8366 |
12:44:31.562 | 1.2 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`=1 |
12:44:31.996 | 1.1 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=9374) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20)) |
12:44:31.976 | 1.1 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=42 |
12:44:31.154 | 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_decurtazionepunti' AND kcu.table_name = 'db2_decurtazionepunti' |
12:44:32.007 | 1.1 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=9374 |
12:44:31.540 | 1.1 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`=1 |
12:44:31.904 | 1.1 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_infrazione`=10276 |
12:44:32.019 | 1.0 ms | yii\db\Command::query | SELECT * FROM `istat2019` WHERE `id_articolo`=1425 |
12:44:31.748 | 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' |
12:44:31.906 | 1.0 ms | yii\db\Command::query | SELECT * FROM `istat2019` WHERE `id_articolo`=1425 |
12:44:32.016 | 1.0 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_infrazione`=10276 |
12:44:31.743 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=5 |
12:44:31.966 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune`=89005 |