Performance Profiling

Total processing time: 487 ms; Peak memory: 4.348 MB. Show Profiling Timeline

Total 85 items.
TimeDurationCategoryInfo
  
16:41:17.66072.8 msyii\db\Command::querySELECT * FROM `db2_alertdoc` WHERE (`id_ente_alertdoc`=1) AND (`id_bollettario_alertdoc`=18749)
16:41:17.63325.1 msyii\db\Command::querySHOW FULL COLUMNS FROM `db2_alertdoc`
16:41:17.5622.2 msyii\db\Command::querySHOW FULL COLUMNS FROM `db2_bollettario`
16:41:17.4722.1 msyii\db\Connection::openOpening DB connection: mysql:host=localhost;dbname=sanzioni1_0
16:41:17.5751.9 msyii\db\Command::querySHOW FULL COLUMNS FROM `db2_docallegato`
16:41:17.5691.8 msyii\db\Command::querySHOW FULL COLUMNS FROM `db0_ente`
16:41:17.7911.7 msyii\db\Command::querySHOW FULL COLUMNS FROM `articoli_new`
16:41:17.8111.6 msyii\db\Command::querySHOW FULL COLUMNS FROM `db0_comuni`
16:41:17.7551.6 msyii\db\Command::querySHOW FULL COLUMNS FROM `db2_notifica`
16:41:17.7781.5 msyii\db\Command::querySHOW FULL COLUMNS FROM `db2_infrazione`
16:41:17.8471.4 msyii\db\Command::querySHOW FULL COLUMNS FROM `db1_persona`
16:41:17.5651.3 msyii\db\Command::querySELECT 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'
16:41:17.5771.3 msyii\db\Command::querySELECT 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'
16:41:17.7501.3 msyii\db\Command::querySHOW FULL COLUMNS FROM `db2_decurtazionepunti`
16:41:17.4741.3 msyii\db\Command::querySHOW FULL COLUMNS FROM `db0_user`
16:41:17.5711.3 msyii\db\Command::querySELECT 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'
16:41:17.7841.3 msyii\db\Command::querySHOW FULL COLUMNS FROM `db2_rateizzato`
16:41:17.8061.3 msyii\db\Command::querySHOW FULL COLUMNS FROM `db1_stradario`
16:41:17.8281.3 msyii\db\Command::querySHOW FULL COLUMNS FROM `db1_agente`
16:41:17.5671.2 msyii\db\Command::querySELECT * FROM `db2_bollettario` WHERE `id_bollettario`='18749'
16:41:17.8491.2 msyii\db\Command::querySELECT 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'
16:41:17.4771.2 msyii\db\Command::querySELECT 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'
16:41:17.8621.2 msyii\db\Command::querySHOW FULL COLUMNS FROM `db1_veicolo`
16:41:17.6591.2 msyii\db\Command::querySELECT 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_alertdoc' AND kcu.table_name = 'db2_alertdoc'
16:41:17.8401.1 msyii\db\Command::querySHOW FULL COLUMNS FROM `db2_proprietario`
16:41:17.8201.1 msyii\db\Command::querySHOW FULL COLUMNS FROM `db2_sottoscritti`
16:41:17.8141.1 msyii\db\Command::querySELECT 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'
16:41:17.7981.1 msyii\db\Command::querySHOW FULL COLUMNS FROM `istat2021`
16:41:17.8771.1 msyii\db\Command::querySELECT 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'
16:41:17.8761.1 msyii\db\Command::querySHOW FULL COLUMNS FROM `db2_verbaleazienda`
16:41:17.7801.1 msyii\db\Command::querySELECT 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'
16:41:17.8551.1 msyii\db\Command::querySHOW FULL COLUMNS FROM `db2_verbaleveicolo`
16:41:17.7861.0 msyii\db\Command::querySELECT 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'
16:41:17.7901.0 msyii\db\Command::querySELECT * FROM `articoli_new` WHERE `id_articolo`='1425'
16:41:17.8421.0 msyii\db\Command::querySELECT 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'
16:41:17.8221.0 msyii\db\Command::querySELECT 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'
16:41:17.8641.0 msyii\db\Command::querySELECT 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'
16:41:17.7521.0 msyii\db\Command::querySELECT 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'
16:41:17.8301.0 msyii\db\Command::querySELECT 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'
16:41:17.7581.0 msyii\db\Command::querySELECT 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'
16:41:17.7991.0 msyii\db\Command::querySELECT 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'
16:41:17.7821.0 msyii\db\Command::querySELECT * FROM `db2_infrazione` WHERE (`id_bollettario_infrazione`=18749) AND (`id_ente_infrazione`=1)
16:41:17.8561.0 msyii\db\Command::querySELECT 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'
16:41:17.7941.0 msyii\db\Command::querySELECT 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'
16:41:17.7481.0 msyii\db\Command::querySELECT * FROM `db2_bollettario` WHERE `id_bollettario`='18749'
16:41:17.7531.0 msyii\db\Command::querySELECT * FROM `db2_decurtazionepunti` WHERE `id_bollettario_decurtazionepunti`='18749'
16:41:17.7961.0 msyii\db\Command::querySELECT * FROM `istat2021` WHERE `id_articolo`=1425
16:41:17.8390.9 msyii\db\Command::querySELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=18749) AND (`tipo_proprietario`=0)
16:41:17.8460.9 msyii\db\Command::querySELECT * FROM `db1_persona` WHERE `id_persona`=18307
16:41:17.8670.9 msyii\db\Command::querySELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=18749) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20))
16:41:17.8610.9 msyii\db\Command::querySELECT * FROM `db1_veicolo` WHERE `id_veicolo`=15363
16:41:17.7590.9 msyii\db\Command::querySELECT * FROM `db2_notifica` WHERE `id_bollettario_notifica`='18749'
16:41:17.8270.9 msyii\db\Command::querySELECT * FROM `db1_agente` WHERE `id_agente`=60
16:41:17.7700.9 msyii\db\Command::querySELECT * FROM `db2_docallegato` WHERE `id_bollettario_docallegato`='18749' LIMIT 20
16:41:17.8540.9 msyii\db\Command::querySELECT COUNT(*) FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=18749
16:41:17.8190.9 msyii\db\Command::querySELECT COUNT(*) FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=18749
16:41:17.8080.9 msyii\db\Command::querySELECT 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'
16:41:17.8860.9 msyii\db\Command::querySELECT * FROM `articoli_new` WHERE `id_articolo`='1425'
16:41:17.8230.9 msyii\db\Command::querySELECT * FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=18749 ORDER BY `id_sottoscritti` DESC LIMIT 15
16:41:17.8900.9 msyii\db\Command::querySELECT * FROM `istat2021` WHERE `id_articolo`=1425
16:41:17.8680.9 msyii\db\Command::querySELECT * FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=18749) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20)) LIMIT 20
16:41:17.8800.9 msyii\db\Command::querySELECT * FROM `db2_bollettario` WHERE `id_bollettario`=18749
16:41:17.8580.9 msyii\db\Command::querySELECT * FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=18749 LIMIT 20
16:41:17.8740.8 msyii\db\Command::querySELECT COUNT(*) FROM `db2_verbaleazienda` WHERE `id_bollettario_verbaleazienda`=18749
16:41:17.8010.8 msyii\db\Command::querySELECT * FROM `db2_infrazione` WHERE (`id_bollettario_infrazione`=18749) AND (`id_ente_infrazione`=1)
16:41:17.4820.8 msyii\db\Command::querySELECT * FROM `db0_user` WHERE `id`=11
16:41:17.8830.8 msyii\db\Command::querySELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=18749 ORDER BY `id_infrazione` DESC LIMIT 15
16:41:17.7750.8 msyii\db\Command::querySELECT * FROM `db2_bollettario` WHERE `id_bollettario`=18749
16:41:17.5790.8 msyii\db\Command::querySELECT * FROM `db2_docallegato` WHERE `id_docallegato`='11590'
16:41:17.8020.8 msyii\db\Command::querySELECT * FROM `db0_user` WHERE `id`=11
16:41:17.8430.8 msyii\db\Command::querySELECT * FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=18749) AND (`tipo_proprietario`=0) LIMIT 20
16:41:17.5730.8 msyii\db\Command::querySELECT * FROM `db0_ente` WHERE `id_ente`='1'
16:41:17.8820.8 msyii\db\Command::querySELECT COUNT(*) FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=18749
16:41:17.8330.7 msyii\db\Command::querySELECT * FROM `db1_agente` WHERE `id_agente`=55
16:41:17.7670.7 msyii\db\Command::querySELECT COUNT(*) FROM `db2_docallegato` WHERE `id_bollettario_docallegato`='18749'
16:41:17.8350.7 msyii\db\Command::querySELECT * FROM `db1_agente` WHERE `id_agente`=38
16:41:17.8700.7 msyii\db\Command::querySELECT * FROM `db1_persona` WHERE `id_persona`=18307
16:41:17.7870.7 msyii\db\Command::querySELECT * FROM `db2_rateizzato` WHERE `id_bollettario_rateizzato`=18749
16:41:17.8880.7 msyii\db\Command::querySELECT * FROM `db2_infrazione` WHERE `id_infrazione`=21328
16:41:17.8920.7 msyii\db\Command::querySELECT * FROM `db0_comuni` WHERE `id_comune`=72006
16:41:17.7600.6 msyii\db\Command::querySELECT * FROM `db0_ente` WHERE `id_ente`=1
16:41:17.8040.6 msyii\db\Command::querySELECT * FROM `db0_user` WHERE `id`=11
16:41:17.8150.6 msyii\db\Command::querySELECT * FROM `db0_comuni` WHERE `id_comune`=72002
16:41:17.8090.6 msyii\db\Command::querySELECT * FROM `db1_stradario` WHERE `COD_VIA`=14546
16:41:17.7770.5 msyii\db\Command::querySELECT * FROM `db0_ente` WHERE `id_ente`=1