Total processing time: 448 ms; Peak memory: 5.443 MB. Show Profiling Timeline
Time | Duration | Category | Info |
---|---|---|---|
15:05:08.646 | 6.2 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_bollettario` |
15:05:08.612 | 3.4 ms | yii\db\Connection::open | Opening DB connection: mysql:host=localhost;dbname=sanzioni1_0 |
15:05:08.654 | 3.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_bollettario' AND kcu.table_name = 'db2_bollettario' |
15:05:08.620 | 3.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 = 'db0_user' AND kcu.table_name = 'db0_user' |
15:05:08.669 | 2.4 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_decurtazionepunti` |
15:05:08.695 | 2.4 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `articoli_new` |
15:05:08.616 | 2.3 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db0_user` |
15:05:08.658 | 2.3 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`='22018' |
15:05:08.745 | 2.2 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_sanzioneacc` |
15:05:08.677 | 2.2 ms | yii\db\Command::query | SELECT * FROM `db2_notifica` WHERE `id_bollettario_notifica`='22018' ORDER BY `id_notifica` DESC |
15:05:08.661 | 2.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db0_ente` |
15:05:08.814 | 2.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_persona` |
15:05:08.688 | 2.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_infrazione` |
15:05:08.780 | 2.0 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db0_comuni` |
15:05:08.671 | 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' |
15:05:08.679 | 1.9 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_notifica` |
15:05:08.833 | 1.9 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_veicolo` |
15:05:08.807 | 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_proprietario' AND kcu.table_name = 'db2_proprietario' |
15:05:08.664 | 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 = 'db0_ente' AND kcu.table_name = 'db0_ente' |
15:05:08.723 | 1.8 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_nota` |
15:05:08.905 | 1.8 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='1053' |
15:05:08.758 | 1.8 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_agente` |
15:05:08.852 | 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_verbaleazienda' AND kcu.table_name = 'db2_verbaleazienda' |
15:05:08.775 | 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_stradario' AND kcu.table_name = 'db1_stradario' |
15:05:08.736 | 1.8 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_docallegato` |
15:05:08.772 | 1.8 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_stradario` |
15:05:08.849 | 1.7 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_verbaleazienda` |
15:05:08.826 | 1.7 ms | yii\db\Command::query | SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'db2_verbaleveicolo' AND kcu.table_name = 'db2_verbaleveicolo' |
15:05:08.817 | 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_persona' AND kcu.table_name = 'db1_persona' |
15:05:08.793 | 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_sottoscritti' AND kcu.table_name = 'db2_sottoscritti' |
15:05:08.824 | 1.7 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_verbaleveicolo` |
15:05:08.626 | 1.7 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=8 |
15:05:08.725 | 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' |
15:05:08.791 | 1.6 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_sottoscritti` |
15:05:08.760 | 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' |
15:05:08.749 | 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_sanzioneacc' AND kcu.table_name = 'db2_sanzioneacc' |
15:05:08.674 | 1.6 ms | yii\db\Command::query | SELECT * FROM `db2_decurtazionepunti` WHERE `id_bollettario_decurtazionepunti`='22018' |
15:05:08.744 | 1.6 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_sanzioneacc` WHERE (`id_ente_sanzioneacc`='1') AND (`id_bollettario_sanzioneacc`='22018') |
15:05:08.789 | 1.5 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=22018 |
15:05:08.855 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=22018 |
15:05:08.907 | 1.5 ms | yii\db\Command::query | SELECT * FROM `istat2021` WHERE `id_articolo`=1053 |
15:05:08.966 | 1.5 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='1053' |
15:05:08.739 | 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_docallegato' AND kcu.table_name = 'db2_docallegato' |
15:05:08.682 | 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_notifica' AND kcu.table_name = 'db2_notifica' |
15:05:08.884 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_notifica` WHERE `id_bollettario_notifica`='22018' |
15:05:08.899 | 1.5 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_rateizzato` |
15:05:08.721 | 1.5 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_nota` WHERE (`id_ente_nota`='1') AND (`id_bollettario_nota`='22018') |
15:05:08.949 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=22018) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20)) LIMIT 20 |
15:05:08.860 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=22018 ORDER BY `id_infrazione` DESC LIMIT 15 |
15:05:08.764 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=22018 |
15:05:08.690 | 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_infrazione' AND kcu.table_name = 'db2_infrazione' |
15:05:08.911 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE (`id_bollettario_infrazione`=22018) AND (`id_ente_infrazione`=1) |
15:05:08.931 | 1.5 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=22018) AND (`tipo_proprietario`=0) |
15:05:08.803 | 1.5 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=22018) AND (`tipo_proprietario`=0) |
15:05:08.933 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=22018) AND (`tipo_proprietario`=0) LIMIT 20 |
15:05:08.782 | 1.5 ms | yii\db\Command::query | SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'db0_comuni' AND kcu.table_name = 'db0_comuni' |
15:05:08.901 | 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' |
15:05:08.880 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`='22018' |
15:05:08.924 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=22018 ORDER BY `id_sottoscritti` DESC LIMIT 15 |
15:05:08.958 | 1.5 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=22018 |
15:05:08.869 | 1.4 ms | yii\db\Command::query | SELECT * FROM `istat2021` WHERE `id_articolo`=1053 |
15:05:08.889 | 1.4 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_docallegato` WHERE `id_bollettario_docallegato`='22018' |
15:05:08.841 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=22018) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20)) LIMIT 20 |
15:05:08.756 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=65 |
15:05:08.961 | 1.4 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=22018 |
15:05:08.903 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db2_rateizzato` WHERE `id_bollettario_rateizzato`=22018 |
15:05:08.705 | 1.4 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `istat2021` |
15:05:08.809 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=22018) AND (`tipo_proprietario`=0) LIMIT 20 |
15:05:08.866 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_infrazione`=24731 |
15:05:08.784 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune`=72006 |
15:05:08.805 | 1.4 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_proprietario` |
15:05:08.864 | 1.4 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='1053' |
15:05:08.832 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db1_veicolo` WHERE `id_veicolo`=17476 |
15:05:08.936 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db1_persona` WHERE `id_persona`=20793 |
15:05:08.970 | 1.4 ms | yii\db\Command::query | SELECT * FROM `istat2021` WHERE `id_articolo`=1053 |
15:05:08.822 | 1.4 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=22018 |
15:05:08.769 | 1.4 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_nota` WHERE (`id_ente_nota`=1) AND (`id_bollettario_nota`=22018) |
15:05:08.915 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=11 |
15:05:08.795 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=22018 ORDER BY `id_sottoscritti` DESC LIMIT 15 |
15:05:08.913 | 1.4 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=11 |
15:05:08.944 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db1_veicolo` WHERE `id_veicolo`=17476 |
15:05:08.839 | 1.3 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=22018) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20)) |
15:05:08.836 | 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_veicolo' AND kcu.table_name = 'db1_veicolo' |
15:05:08.919 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune`=72006 |
15:05:08.927 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=58 |
15:05:08.963 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=22018 ORDER BY `id_infrazione` DESC LIMIT 15 |
15:05:08.767 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`=1 |
15:05:08.955 | 1.3 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_verbaleazienda` WHERE `id_bollettario_verbaleazienda`=22018 |
15:05:08.707 | 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 = 'istat2021' AND kcu.table_name = 'istat2021' |
15:05:08.973 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune`=72006 |
15:05:08.923 | 1.3 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=22018 |
15:05:08.947 | 1.3 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=22018) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20)) |
15:05:08.777 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db1_stradario` WHERE `COD_VIA`=56577 |
15:05:08.917 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db1_stradario` WHERE `COD_VIA`=56577 |
15:05:08.666 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`='1' |
15:05:08.735 | 1.3 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_docallegato` WHERE `id_bollettario_docallegato`='22018' |
15:05:08.751 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=11 |
15:05:08.858 | 1.3 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=22018 |
15:05:08.872 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune`=72006 |
15:05:08.882 | 1.3 ms | yii\db\Command::query | SELECT * FROM `db2_decurtazionepunti` WHERE `id_bollettario_decurtazionepunti`='22018' |
15:05:08.753 | 1.2 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=11 |
15:05:08.698 | 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 = 'articoli_new' AND kcu.table_name = 'articoli_new' |
15:05:08.895 | 1.2 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE (`id_bollettario_infrazione`=22018) AND (`id_ente_infrazione`=1) |
15:05:08.939 | 1.2 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=22018 |
15:05:08.812 | 1.2 ms | yii\db\Command::query | SELECT * FROM `db1_persona` WHERE `id_persona`=20793 |
15:05:08.798 | 1.2 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=58 |
15:05:08.828 | 1.2 ms | yii\db\Command::query | SELECT * FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=22018 LIMIT 20 |
15:05:08.952 | 1.2 ms | yii\db\Command::query | SELECT * FROM `db1_persona` WHERE `id_persona`=20794 |
15:05:08.941 | 1.2 ms | yii\db\Command::query | SELECT * FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=22018 LIMIT 20 |
15:05:08.692 | 1.1 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`='22018' |
15:05:08.909 | 1.1 ms | yii\db\Command::query | SELECT * FROM `db2_notifica` WHERE `id_bollettario_notifica`=22018 ORDER BY `id_notifica` |
15:05:08.704 | 1.1 ms | yii\db\Command::query | SELECT * FROM `istat2021` WHERE `id_articolo`=1053 |
15:05:08.892 | 1.1 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=22018 |
15:05:08.848 | 1.1 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_verbaleazienda` WHERE `id_bollettario_verbaleazienda`=22018 |
15:05:08.886 | 1.0 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`=1 |
15:05:08.700 | 1.0 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='1053' |
15:05:08.844 | 1.0 ms | yii\db\Command::query | SELECT * FROM `db1_persona` WHERE `id_persona`=20794 |
15:05:08.968 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_infrazione`=24731 |
15:05:08.894 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`=1 |