Performance Profiling

Total processing time: 299 ms; Peak memory: 4.635 MB. Show Profiling Timeline

Total 91 items.
TimeDurationCategoryInfo
  
13:26:58.7382.4 msyii\db\Command::querySHOW FULL COLUMNS FROM `db2_docallegato`
13:26:58.7072.0 msyii\db\Command::querySHOW FULL COLUMNS FROM `db2_bollettario`
13:26:58.8051.9 msyii\db\Command::querySHOW FULL COLUMNS FROM `articoli_new`
13:26:58.7481.7 msyii\db\Command::querySHOW FULL COLUMNS FROM `db2_alertdoc`
13:26:58.8271.7 msyii\db\Command::querySHOW FULL COLUMNS FROM `db0_comuni`
13:26:58.7751.6 msyii\db\Command::querySHOW FULL COLUMNS FROM `db2_notifica`
13:26:58.8221.5 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'
13:26:58.7921.5 msyii\db\Command::querySHOW FULL COLUMNS FROM `db2_infrazione`
13:26:58.8611.5 msyii\db\Command::querySHOW FULL COLUMNS FROM `db1_persona`
13:26:58.6791.4 msyii\db\Connection::openOpening DB connection: mysql:host=localhost;dbname=sanzioni1_0
13:26:58.8441.4 msyii\db\Command::querySHOW FULL COLUMNS FROM `db1_agente`
13:26:58.8201.3 msyii\db\Command::querySHOW FULL COLUMNS FROM `db1_stradario`
13:26:58.7981.3 msyii\db\Command::querySHOW FULL COLUMNS FROM `db2_rateizzato`
13:26:58.7501.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_alertdoc' AND kcu.table_name = 'db2_alertdoc'
13:26:58.6801.3 msyii\db\Command::querySHOW FULL COLUMNS FROM `db0_user`
13:26:58.7701.3 msyii\db\Command::querySHOW FULL COLUMNS FROM `db2_decurtazionepunti`
13:26:58.7521.3 msyii\db\Command::querySELECT * FROM `db2_alertdoc` WHERE (`id_ente_alertdoc`=1) AND (`id_bollettario_alertdoc`=9374)
13:26:58.8771.3 msyii\db\Command::querySHOW FULL COLUMNS FROM `db1_veicolo`
13:26:58.8911.2 msyii\db\Command::querySHOW FULL COLUMNS FROM `db2_verbaleazienda`
13:26:58.8111.2 msyii\db\Command::querySHOW FULL COLUMNS FROM `istat2019`
13:26:58.7141.1 msyii\db\Command::querySHOW FULL COLUMNS FROM `db0_ente`
13:26:58.8361.1 msyii\db\Command::querySHOW FULL COLUMNS FROM `db2_sottoscritti`
13:26:58.7441.1 msyii\db\Command::querySELECT * FROM `db2_docallegato` WHERE (`id_ente_docallegato`=1) AND (`id_bollettario_docallegato`=9374) LIMIT 20
13:26:58.8541.1 msyii\db\Command::querySHOW FULL COLUMNS FROM `db2_proprietario`
13:26:58.8691.1 msyii\db\Command::querySHOW FULL COLUMNS FROM `db2_verbaleveicolo`
13:26:58.7361.1 msyii\db\Command::querySELECT COUNT(*) FROM `db2_docallegato` WHERE (`id_ente_docallegato`=1) AND (`id_bollettario_docallegato`=9374)
13:26:58.7411.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_docallegato' AND kcu.table_name = 'db2_docallegato'
13:26:58.8791.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 = 'db1_veicolo' AND kcu.table_name = 'db1_veicolo'
13:26:58.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 = 'db2_rateizzato' AND kcu.table_name = 'db2_rateizzato'
13:26:58.8041.0 msyii\db\Command::querySELECT * FROM `articoli_new` WHERE `id_articolo`='1425'
13:26:58.7541.0 msyii\db\Command::querySELECT * FROM `db2_alertdoc` WHERE (`id_ente_alertdoc`=1) AND (`id_bollettario_alertdoc`=9374)
13:26:58.8711.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'
13:26:58.6831.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 = 'db0_user' AND kcu.table_name = 'db0_user'
13:26:58.8371.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'
13:26:58.8921.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_verbaleazienda' AND kcu.table_name = 'db2_verbaleazienda'
13:26:58.7721.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'
13:26:58.7101.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_bollettario' AND kcu.table_name = 'db2_bollettario'
13:26:58.8461.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'
13:26:58.8551.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'
13:26:58.8631.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_persona' AND kcu.table_name = 'db1_persona'
13:26:58.7781.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'
13:26:58.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 = 'db2_infrazione' AND kcu.table_name = 'db2_infrazione'
13:26:58.8761.0 msyii\db\Command::querySELECT * FROM `db1_veicolo` WHERE `id_veicolo`=7794
13:26:58.8991.0 msyii\db\Command::querySELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=9374 ORDER BY `id_infrazione` DESC LIMIT 15
13:26:58.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 = 'articoli_new' AND kcu.table_name = 'articoli_new'
13:26:58.8130.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 = 'istat2019' AND kcu.table_name = 'istat2019'
13:26:58.7150.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 = 'db0_ente' AND kcu.table_name = 'db0_ente'
13:26:58.9020.9 msyii\db\Command::querySELECT * FROM `articoli_new` WHERE `id_articolo`='1425'
13:26:58.8950.9 msyii\db\Command::querySELECT * FROM `db2_bollettario` WHERE `id_bollettario`=9374
13:26:58.8680.9 msyii\db\Command::querySELECT COUNT(*) FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=9374
13:26:58.8600.9 msyii\db\Command::querySELECT * FROM `db1_persona` WHERE `id_persona`=8366
13:26:58.7840.9 msyii\db\Command::querySELECT * FROM `db2_docallegato` WHERE `id_bollettario_docallegato`='9374' LIMIT 20
13:26:58.7960.9 msyii\db\Command::querySELECT * FROM `db2_infrazione` WHERE (`id_bollettario_infrazione`=9374) AND (`id_ente_infrazione`=1)
13:26:58.8530.9 msyii\db\Command::querySELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=9374) AND (`tipo_proprietario`=0)
13:26:58.8100.9 msyii\db\Command::querySELECT * FROM `istat2019` WHERE `id_articolo`=1425
13:26:58.6880.9 msyii\db\Command::querySELECT * FROM `db0_user` WHERE `id`=5
13:26:58.8290.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 = 'db0_comuni' AND kcu.table_name = 'db0_comuni'
13:26:58.8420.9 msyii\db\Command::querySELECT * FROM `db1_agente` WHERE `id_agente`=32
13:26:58.7120.9 msyii\db\Command::querySELECT * FROM `db2_bollettario` WHERE `id_bollettario`='9374'
13:26:58.8350.9 msyii\db\Command::querySELECT COUNT(*) FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=9374
13:26:58.7210.9 msyii\db\Command::querySELECT * FROM `db2_bollettario` WHERE `id_bollettario`=9374
13:26:58.8150.9 msyii\db\Command::querySELECT * FROM `db2_infrazione` WHERE (`id_bollettario_infrazione`=9374) AND (`id_ente_infrazione`=1)
13:26:58.8980.9 msyii\db\Command::querySELECT COUNT(*) FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=9374
13:26:58.8900.9 msyii\db\Command::querySELECT COUNT(*) FROM `db2_verbaleazienda` WHERE `id_bollettario_verbaleazienda`=9374
13:26:58.7680.8 msyii\db\Command::querySELECT * FROM `db2_bollettario` WHERE `id_bollettario`='9374'
13:26:58.7790.8 msyii\db\Command::querySELECT * FROM `db2_notifica` WHERE `id_bollettario_notifica`='9374'
13:26:58.7890.8 msyii\db\Command::querySELECT * FROM `db2_bollettario` WHERE `id_bollettario`=9374
13:26:58.8860.8 msyii\db\Command::querySELECT * FROM `db1_persona` WHERE `id_persona`=8367
13:26:58.8830.8 msyii\db\Command::querySELECT * FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=9374) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20)) LIMIT 20
13:26:58.8820.8 msyii\db\Command::querySELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=9374) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20))
13:26:58.8570.8 msyii\db\Command::querySELECT * FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=9374) AND (`tipo_proprietario`=0) LIMIT 20
13:26:58.8720.8 msyii\db\Command::querySELECT * FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=9374 LIMIT 20
13:26:58.8390.8 msyii\db\Command::querySELECT * FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=9374 ORDER BY `id_sottoscritti` DESC LIMIT 15
13:26:58.7730.8 msyii\db\Command::querySELECT * FROM `db2_decurtazionepunti` WHERE `id_bollettario_decurtazionepunti`='9374'
13:26:58.9080.8 msyii\db\Command::querySELECT * FROM `db0_comuni` WHERE `id_comune`=72006
13:26:58.9060.8 msyii\db\Command::querySELECT * FROM `istat2019` WHERE `id_articolo`=1425
13:26:58.8480.8 msyii\db\Command::querySELECT * FROM `db1_agente` WHERE `id_agente`=42
13:26:58.7590.7 msyii\db\Command::querySELECT * FROM `db2_alertdoc` WHERE (`id_ente_alertdoc`=1) AND (`id_bollettario_alertdoc`=9374)
13:26:58.7570.7 msyii\db\Command::querySELECT * FROM `db2_alertdoc` WHERE (`id_ente_alertdoc`=1) AND (`id_bollettario_alertdoc`=9374)
13:26:58.7830.7 msyii\db\Command::querySELECT COUNT(*) FROM `db2_docallegato` WHERE `id_bollettario_docallegato`='9374'
13:26:58.8010.7 msyii\db\Command::querySELECT * FROM `db2_rateizzato` WHERE `id_bollettario_rateizzato`=9374
13:26:58.9040.7 msyii\db\Command::querySELECT * FROM `db2_infrazione` WHERE `id_infrazione`=10276
13:26:58.8240.7 msyii\db\Command::querySELECT * FROM `db1_stradario` WHERE `COD_VIA`=144
13:26:58.7160.7 msyii\db\Command::querySELECT * FROM `db0_ente` WHERE `id_ente`='1'
13:26:58.8160.7 msyii\db\Command::querySELECT * FROM `db0_user` WHERE `id`=11
13:26:58.7900.7 msyii\db\Command::querySELECT * FROM `db0_ente` WHERE `id_ente`=1
13:26:58.8300.7 msyii\db\Command::querySELECT * FROM `db0_comuni` WHERE `id_comune`=89005
13:26:58.7800.6 msyii\db\Command::querySELECT * FROM `db0_ente` WHERE `id_ente`=1
13:26:58.8180.6 msyii\db\Command::querySELECT * FROM `db0_user` WHERE `id`=11
13:26:58.7220.6 msyii\db\Command::querySELECT * FROM `db0_ente` WHERE `id_ente`=1
13:26:58.7560.6 msyii\db\Command::querySELECT * FROM `db2_alertdoc` WHERE (`id_ente_alertdoc`=1) AND (`id_bollettario_alertdoc`=9374)