Total processing time: 285 ms; Peak memory: 4.357 MB. Show Profiling Timeline
Time | Duration | Category | Info |
---|---|---|---|
05:38:25.868 | 2.0 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_bollettario` |
05:38:25.898 | 1.8 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `articoli_new` |
05:38:25.968 | 1.7 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db0_comuni` |
05:38:25.929 | 1.6 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_notifica` |
05:38:25.985 | 1.6 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_agente` |
05:38:26.004 | 1.6 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_persona` |
05:38:25.890 | 1.5 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_rateizzato` |
05:38:25.884 | 1.4 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_pagamento` |
05:38:25.879 | 1.4 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_infrazione` |
05:38:25.924 | 1.4 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_decurtazionepunti` |
05:38:26.020 | 1.3 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_veicolo` |
05:38:25.963 | 1.3 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_stradario` |
05:38:25.842 | 1.3 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db0_user` |
05:38:26.012 | 1.3 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_verbaleveicolo` |
05:38:26.022 | 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' |
05:38:25.944 | 1.3 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_docallegato` |
05:38:25.841 | 1.2 ms | yii\db\Connection::open | Opening DB connection: mysql:host=localhost;dbname=sanzioni1_0 |
05:38:25.970 | 1.2 ms | yii\db\Command::query | SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'db0_comuni' AND kcu.table_name = 'db0_comuni' |
05:38:25.987 | 1.2 ms | yii\db\Command::query | SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'db1_agente' AND kcu.table_name = 'db1_agente' |
05:38:25.904 | 1.2 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `istat2021` |
05:38:25.977 | 1.2 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_sottoscritti` |
05:38:25.997 | 1.2 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_proprietario` |
05:38:25.979 | 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_sottoscritti' AND kcu.table_name = 'db2_sottoscritti' |
05:38:25.875 | 1.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db0_ente` |
05:38:25.845 | 1.1 ms | yii\db\Command::query | SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'db0_user' AND kcu.table_name = 'db0_user' |
05:38:26.036 | 1.1 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_verbaleazienda` |
05:38:25.871 | 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_bollettario' AND kcu.table_name = 'db2_bollettario' |
05:38:26.037 | 1.1 ms | yii\db\Command::query | SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'db2_verbaleazienda' AND kcu.table_name = 'db2_verbaleazienda' |
05:38:26.014 | 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_verbaleveicolo' AND kcu.table_name = 'db2_verbaleveicolo' |
05:38:25.881 | 1.1 ms | yii\db\Command::query | SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'db2_infrazione' AND kcu.table_name = 'db2_infrazione' |
05:38:25.945 | 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_docallegato' AND kcu.table_name = 'db2_docallegato' |
05:38:25.926 | 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' |
05:38:25.949 | 1.1 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=16472 |
05:38:25.964 | 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 = 'db1_stradario' AND kcu.table_name = 'db1_stradario' |
05:38:25.905 | 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 = 'istat2021' AND kcu.table_name = 'istat2021' |
05:38:26.007 | 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 = 'db1_persona' AND kcu.table_name = 'db1_persona' |
05:38:25.886 | 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_pagamento' AND kcu.table_name = 'db2_pagamento' |
05:38:25.896 | 1.0 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='366' |
05:38:25.999 | 1.0 ms | yii\db\Command::query | SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'db2_proprietario' AND kcu.table_name = 'db2_proprietario' |
05:38:25.876 | 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 = 'db0_ente' AND kcu.table_name = 'db0_ente' |
05:38:25.976 | 1.0 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=16472 |
05:38:25.892 | 1.0 ms | yii\db\Command::query | SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'db2_rateizzato' AND kcu.table_name = 'db2_rateizzato' |
05:38:26.003 | 1.0 ms | yii\db\Command::query | SELECT * FROM `db1_persona` WHERE `id_persona`=15809 |
05:38:25.931 | 1.0 ms | yii\db\Command::query | SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'db2_notifica' AND kcu.table_name = 'db2_notifica' |
05:38:26.011 | 1.0 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=16472 |
05:38:25.996 | 0.9 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=16472) AND (`tipo_proprietario`=0) |
05:38:25.900 | 0.9 ms | yii\db\Command::query | SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'articoli_new' AND kcu.table_name = 'articoli_new' |
05:38:25.933 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_notifica` WHERE `id_bollettario_notifica`='16472' |
05:38:25.882 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE (`id_bollettario_infrazione`='16472') AND (`id_ente_infrazione`='1') |
05:38:25.957 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE (`id_bollettario_infrazione`=16472) AND (`id_ente_infrazione`=1) |
05:38:26.040 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`=16472 |
05:38:25.952 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE (`id_bollettario_infrazione`=16472) AND (`id_ente_infrazione`=1) |
05:38:25.902 | 0.9 ms | yii\db\Command::query | SELECT * FROM `istat2021` WHERE `id_articolo`=366 |
05:38:26.000 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=16472) AND (`tipo_proprietario`=0) LIMIT 20 |
05:38:26.025 | 0.9 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=16472) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20)) |
05:38:25.888 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_pagamento` WHERE `id_bollettario_pagamento`='16472' |
05:38:25.984 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=24 |
05:38:25.980 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=16472 ORDER BY `id_sottoscritti` DESC LIMIT 15 |
05:38:25.943 | 0.9 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_docallegato` WHERE `id_bollettario_docallegato`='16472' |
05:38:25.873 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`='16472' |
05:38:25.922 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `id_bollettario`='16472' |
05:38:26.026 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=16472) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20)) LIMIT 20 |
05:38:26.050 | 0.8 ms | yii\db\Command::query | SELECT * FROM `istat2021` WHERE `id_articolo`=366 |
05:38:26.034 | 0.8 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_verbaleazienda` WHERE `id_bollettario_verbaleazienda`=16472 |
05:38:26.019 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db1_veicolo` WHERE `id_veicolo`=13493 |
05:38:26.028 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db1_persona` WHERE `id_persona`=15810 |
05:38:26.015 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=16472 LIMIT 20 |
05:38:26.046 | 0.8 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='366' |
05:38:25.893 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_rateizzato` WHERE `id_bollettario_rateizzato`='16472' |
05:38:26.043 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=16472 ORDER BY `id_infrazione` DESC LIMIT 15 |
05:38:25.966 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db1_stradario` WHERE `COD_VIA`=152616 |
05:38:26.031 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db1_persona` WHERE `id_persona`=15811 |
05:38:25.990 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=56 |
05:38:25.850 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=31 |
05:38:25.955 | 0.8 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='366' |
05:38:25.953 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_rateizzato` WHERE `id_bollettario_rateizzato`=16472 |
05:38:25.992 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente`=58 |
05:38:25.927 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_decurtazionepunti` WHERE `id_bollettario_decurtazionepunti`='16472' |
05:38:26.052 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune`=72006 |
05:38:26.042 | 0.7 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=16472 |
05:38:25.956 | 0.7 ms | yii\db\Command::query | SELECT * FROM `istat2021` WHERE `id_articolo`=366 |
05:38:25.951 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`=1 |
05:38:26.048 | 0.6 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_infrazione`=18597 |
05:38:25.959 | 0.6 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=11 |
05:38:25.972 | 0.6 ms | yii\db\Command::query | SELECT * FROM `db0_comuni` WHERE `id_comune`=72024 |
05:38:25.877 | 0.6 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`='1' |
05:38:25.960 | 0.6 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=11 |
05:38:25.934 | 0.5 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`=1 |