Total processing time: 865 ms; Peak memory: 5.676 MB. Show Profiling Timeline
Time | Duration | Category | Info |
---|---|---|---|
09:22:15.676 | 4.8 ms | yii\db\Connection::open | Opening DB connection: mysql:host=localhost;dbname=sanzioni1_0 |
09:22:15.754 | 2.8 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `articoli_new` |
09:22:15.714 | 2.6 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_bollettario` |
09:22:15.814 | 2.5 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_sanzioneacc` |
09:22:15.797 | 2.4 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_docallegato` |
09:22:15.896 | 2.4 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_persona` |
09:22:15.855 | 2.3 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db0_comuni` |
09:22:15.782 | 2.3 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_nota` |
09:22:15.738 | 2.2 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_notifica` |
09:22:15.812 | 2.1 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_sanzioneacc` WHERE (`id_ente_sanzioneacc`='1') AND (`id_bollettario_sanzioneacc`='22396') |
09:22:15.989 | 2.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_rateizzato` |
09:22:15.833 | 2.0 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_agente` |
09:22:15.722 | 2.0 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db0_ente` |
09:22:15.729 | 2.0 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_decurtazionepunti` |
09:22:15.804 | 2.0 ms | yii\db\Command::query | SELECT * FROM `db2_docallegato` WHERE `id_bollettario_docallegato`='22396' LIMIT 20 |
09:22:15.931 | 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_verbaleazienda' AND kcu.table_name = 'db2_verbaleazienda' |
09:22:15.978 | 1.9 ms | yii\db\Command::query | SELECT * FROM `db2_docallegato` WHERE `id_bollettario_docallegato`='22396' LIMIT 20 |
09:22:15.766 | 1.9 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `istat2021` |
09:22:15.848 | 1.9 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_stradario` |
09:22:15.916 | 1.9 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_veicolo` |
09:22:15.681 | 1.9 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db0_user` |
09:22:15.785 | 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_nota' AND kcu.table_name = 'db2_nota' |
09:22:15.685 | 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 = 'db0_user' AND kcu.table_name = 'db0_user' |
09:22:15.820 | 1.8 ms | yii\db\Command::query | SELECT * FROM `db2_sanzioneacc` WHERE (`id_ente_sanzioneacc`='1') AND (`id_bollettario_sanzioneacc`='22396') ORDER BY `id_sanzioneacc` DESC LIMIT 20 |
09:22:15.906 | 1.8 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_verbaleveicolo` |
09:22:15.749 | 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_infrazione' AND kcu.table_name = 'db2_infrazione' |
09:22:15.886 | 1.7 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_proprietario` |
09:22:15.818 | 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' |
09:22:15.758 | 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 = 'articoli_new' AND kcu.table_name = 'articoli_new' |
09:22:15.836 | 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 = 'db1_agente' AND kcu.table_name = 'db1_agente' |
09:22:15.929 | 1.7 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_verbaleazienda` |
09:22:15.720 | 1.7 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`='22396' |
09:22:15.746 | 1.7 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_infrazione` |
09:22:15.768 | 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 = 'istat2021' AND kcu.table_name = 'istat2021' |
09:22:15.732 | 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_decurtazionepunti' AND kcu.table_name = 'db2_decurtazionepunti' |
09:22:15.718 | 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_bollettario' AND kcu.table_name = 'db2_bollettario' |
09:22:15.760 | 1.6 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='366' |
09:22:15.764 | 1.6 ms | yii\db\Command::query | SELECT * FROM `istat2021` WHERE `id_articolo`=366 |
09:22:15.795 | 1.6 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_docallegato` WHERE `id_bollettario_docallegato`='22396' |
09:22:15.858 | 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' |
09:22:16.013 | 1.6 ms | yii\db\Command::query | SELECT * FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=22396 ORDER BY `id_sottoscritti` DESC LIMIT 15 |
09:22:15.899 | 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:22:16.059 | 1.6 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='366' |
09:22:15.908 | 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' |
09:22:15.869 | 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_sottoscritti' AND kcu.table_name = 'db2_sottoscritti' |
09:22:15.832 | 1.6 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=18 |
09:22:16.000 | 1.6 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE (`id_bollettario_infrazione`=22396) AND (`id_ente_infrazione`=1) |
09:22:15.800 | 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' |
09:22:15.941 | 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_azienda' AND kcu.table_name = 'db1_azienda' |
09:22:15.879 | 1.6 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=18 |
09:22:15.919 | 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:22:15.894 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db1_persona` WHERE `id_persona`=21993 |
09:22:16.052 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=22396 |
09:22:15.952 | 1.5 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='366' |
09:22:15.840 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=22396 |
09:22:15.986 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE (`id_bollettario_infrazione`=22396) AND (`id_ente_infrazione`=1) |
09:22:16.016 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=21 |
09:22:15.736 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_notifica` WHERE `id_bollettario_notifica`='22396' ORDER BY `id_notifica` DESC |
09:22:16.056 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=22396 ORDER BY `id_infrazione` DESC LIMIT 15 |
09:22:15.865 | 1.5 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=22396 |
09:22:15.992 | 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:22:15.937 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db1_azienda` WHERE `id_azienda`=2752 |
09:22:15.957 | 1.5 ms | yii\db\Command::query | SELECT * FROM `istat2021` WHERE `id_articolo`=366 |
09:22:15.976 | 1.5 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_docallegato` WHERE `id_bollettario_docallegato`='22396' |
09:22:15.691 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=8 |
09:22:15.889 | 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_proprietario' AND kcu.table_name = 'db2_proprietario' |
09:22:15.939 | 1.5 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_azienda` |
09:22:15.890 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=22396) AND (`tipo_proprietario`=0) LIMIT 20 |
09:22:15.725 | 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' |
09:22:15.996 | 1.4 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='366' |
09:22:16.026 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=22396) AND (`tipo_proprietario`=0) LIMIT 20 |
09:22:16.029 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db1_persona` WHERE `id_persona`=21993 |
09:22:15.923 | 1.4 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=22396) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20)) |
09:22:16.041 | 1.4 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=22396) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20)) |
09:22:16.034 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=22396 LIMIT 20 |
09:22:16.046 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db2_verbaleazienda` WHERE `id_bollettario_verbaleazienda`=22396 LIMIT 20 |
09:22:15.867 | 1.4 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_sottoscritti` |
09:22:15.904 | 1.4 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=22396 |
09:22:15.914 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db1_veicolo` WHERE `id_veicolo`=18425 |
09:22:15.910 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=22396 LIMIT 20 |
09:22:15.993 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db2_rateizzato` WHERE `id_bollettario_rateizzato`=22396 |
09:22:15.751 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`='22396' |
09:22:15.884 | 1.4 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=22396) AND (`tipo_proprietario`=0) |
09:22:15.780 | 1.4 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_nota` WHERE (`id_ente_nota`='1') AND (`id_bollettario_nota`='22396') |
09:22:15.734 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db2_decurtazionepunti` WHERE `id_bollettario_decurtazionepunti`='22396' |
09:22:16.037 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db1_veicolo` WHERE `id_veicolo`=18425 |
09:22:15.933 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db2_verbaleazienda` WHERE `id_bollettario_verbaleazienda`=22396 LIMIT 20 |
09:22:16.044 | 1.3 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_verbaleazienda` WHERE `id_bollettario_verbaleazienda`=22396 |
09:22:15.874 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=21 |
09:22:15.845 | 1.3 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_nota` WHERE (`id_ente_nota`=1) AND (`id_bollettario_nota`=22396) |
09:22:15.969 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db2_decurtazionepunti` WHERE `id_bollettario_decurtazionepunti`='22396' |
09:22:16.004 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=52 |
09:22:16.021 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=18 |
09:22:15.871 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=22396 ORDER BY `id_sottoscritti` DESC LIMIT 15 |
09:22:15.972 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`=1 |
09:22:15.851 | 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:22:15.741 | 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_notifica' AND kcu.table_name = 'db2_notifica' |
09:22:15.877 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=67 |
09:22:15.861 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune`=72033 |
09:22:15.852 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db1_stradario` WHERE `COD_VIA`=14703 |
09:22:16.002 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=52 |
09:22:16.033 | 1.3 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=22396 |
09:22:16.049 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db1_azienda` WHERE `id_azienda`=2752 |
09:22:15.727 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`='1' |
09:22:15.998 | 1.3 ms | yii\db\Command::query | SELECT * FROM `istat2021` WHERE `id_articolo`=366 |
09:22:15.954 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_infrazione`=25139 |
09:22:15.927 | 1.2 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_verbaleazienda` WHERE `id_bollettario_verbaleazienda`=22396 |
09:22:15.944 | 1.2 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=22396 |
09:22:16.006 | 1.2 ms | yii\db\Command::query | SELECT * FROM `db1_stradario` WHERE `COD_VIA`=14703 |
09:22:16.064 | 1.2 ms | yii\db\Command::query | SELECT * FROM `istat2021` WHERE `id_articolo`=366 |
09:22:15.842 | 1.2 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`=1 |
09:22:15.984 | 1.2 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`=1 |
09:22:15.824 | 1.2 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=52 |
09:22:15.971 | 1.2 ms | yii\db\Command::query | SELECT * FROM `db2_notifica` WHERE `id_bollettario_notifica`='22396' |
09:22:15.967 | 1.2 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`='22396' |
09:22:15.960 | 1.1 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune`=72006 |
09:22:16.067 | 1.1 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune`=72006 |
09:22:16.009 | 1.1 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune`=72033 |
09:22:15.983 | 1.1 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=22396 |
09:22:15.829 | 1.1 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=52 |
09:22:16.011 | 1.1 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=22396 |
09:22:16.055 | 1.0 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=22396 |
09:22:16.025 | 1.0 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=22396) AND (`tipo_proprietario`=0) |
09:22:15.827 | 1.0 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=52 |
09:22:15.823 | 1.0 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=52 |
09:22:15.949 | 1.0 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=22396 ORDER BY `id_infrazione` DESC LIMIT 15 |
09:22:16.019 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=67 |
09:22:15.947 | 0.9 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=22396 |
09:22:16.062 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_infrazione`=25139 |