Performance Profiling

Total processing time: 285 ms; Peak memory: 4.357 MB. Show Profiling Timeline

Total 88 items.
TimeDurationCategoryInfo
  
05:38:25.8682.0 msyii\db\Command::querySHOW FULL COLUMNS FROM `db2_bollettario`
05:38:25.8981.8 msyii\db\Command::querySHOW FULL COLUMNS FROM `articoli_new`
05:38:25.9681.7 msyii\db\Command::querySHOW FULL COLUMNS FROM `db0_comuni`
05:38:25.9291.6 msyii\db\Command::querySHOW FULL COLUMNS FROM `db2_notifica`
05:38:25.9851.6 msyii\db\Command::querySHOW FULL COLUMNS FROM `db1_agente`
05:38:26.0041.6 msyii\db\Command::querySHOW FULL COLUMNS FROM `db1_persona`
05:38:25.8901.5 msyii\db\Command::querySHOW FULL COLUMNS FROM `db2_rateizzato`
05:38:25.8841.4 msyii\db\Command::querySHOW FULL COLUMNS FROM `db2_pagamento`
05:38:25.8791.4 msyii\db\Command::querySHOW FULL COLUMNS FROM `db2_infrazione`
05:38:25.9241.4 msyii\db\Command::querySHOW FULL COLUMNS FROM `db2_decurtazionepunti`
05:38:26.0201.3 msyii\db\Command::querySHOW FULL COLUMNS FROM `db1_veicolo`
05:38:25.9631.3 msyii\db\Command::querySHOW FULL COLUMNS FROM `db1_stradario`
05:38:25.8421.3 msyii\db\Command::querySHOW FULL COLUMNS FROM `db0_user`
05:38:26.0121.3 msyii\db\Command::querySHOW FULL COLUMNS FROM `db2_verbaleveicolo`
05:38:26.0221.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 = 'db1_veicolo' AND kcu.table_name = 'db1_veicolo'
05:38:25.9441.3 msyii\db\Command::querySHOW FULL COLUMNS FROM `db2_docallegato`
05:38:25.8411.2 msyii\db\Connection::openOpening DB connection: mysql:host=localhost;dbname=sanzioni1_0
05:38:25.9701.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_comuni' AND kcu.table_name = 'db0_comuni'
05:38:25.9871.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_agente' AND kcu.table_name = 'db1_agente'
05:38:25.9041.2 msyii\db\Command::querySHOW FULL COLUMNS FROM `istat2021`
05:38:25.9771.2 msyii\db\Command::querySHOW FULL COLUMNS FROM `db2_sottoscritti`
05:38:25.9971.2 msyii\db\Command::querySHOW FULL COLUMNS FROM `db2_proprietario`
05:38:25.9791.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_sottoscritti' AND kcu.table_name = 'db2_sottoscritti'
05:38:25.8751.1 msyii\db\Command::querySHOW FULL COLUMNS FROM `db0_ente`
05:38:25.8451.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_user' AND kcu.table_name = 'db0_user'
05:38:26.0361.1 msyii\db\Command::querySHOW FULL COLUMNS FROM `db2_verbaleazienda`
05:38:25.8711.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_bollettario' AND kcu.table_name = 'db2_bollettario'
05:38:26.0371.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'
05:38:26.0141.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_verbaleveicolo' AND kcu.table_name = 'db2_verbaleveicolo'
05:38:25.8811.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'
05:38:25.9451.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'
05:38:25.9261.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_decurtazionepunti' AND kcu.table_name = 'db2_decurtazionepunti'
05:38:25.9491.1 msyii\db\Command::querySELECT * FROM `db2_bollettario` WHERE `id_bollettario`=16472
05:38:25.9641.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_stradario' AND kcu.table_name = 'db1_stradario'
05:38:25.9051.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 = 'istat2021' AND kcu.table_name = 'istat2021'
05:38:26.0071.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_persona' AND kcu.table_name = 'db1_persona'
05:38:25.8861.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_pagamento' AND kcu.table_name = 'db2_pagamento'
05:38:25.8961.0 msyii\db\Command::querySELECT * FROM `articoli_new` WHERE `id_articolo`='366'
05:38:25.9991.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'
05:38:25.8761.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_ente' AND kcu.table_name = 'db0_ente'
05:38:25.9761.0 msyii\db\Command::querySELECT COUNT(*) FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=16472
05:38:25.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_rateizzato' AND kcu.table_name = 'db2_rateizzato'
05:38:26.0031.0 msyii\db\Command::querySELECT * FROM `db1_persona` WHERE `id_persona`=15809
05:38:25.9311.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'
05:38:26.0111.0 msyii\db\Command::querySELECT COUNT(*) FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=16472
05:38:25.9960.9 msyii\db\Command::querySELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=16472) AND (`tipo_proprietario`=0)
05:38:25.9000.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'
05:38:25.9330.9 msyii\db\Command::querySELECT * FROM `db2_notifica` WHERE `id_bollettario_notifica`='16472'
05:38:25.8820.9 msyii\db\Command::querySELECT * FROM `db2_infrazione` WHERE (`id_bollettario_infrazione`='16472') AND (`id_ente_infrazione`='1')
05:38:25.9570.9 msyii\db\Command::querySELECT * FROM `db2_infrazione` WHERE (`id_bollettario_infrazione`=16472) AND (`id_ente_infrazione`=1)
05:38:26.0400.9 msyii\db\Command::querySELECT * FROM `db2_bollettario` WHERE `id_bollettario`=16472
05:38:25.9520.9 msyii\db\Command::querySELECT * FROM `db2_infrazione` WHERE (`id_bollettario_infrazione`=16472) AND (`id_ente_infrazione`=1)
05:38:25.9020.9 msyii\db\Command::querySELECT * FROM `istat2021` WHERE `id_articolo`=366
05:38:26.0000.9 msyii\db\Command::querySELECT * FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=16472) AND (`tipo_proprietario`=0) LIMIT 20
05:38:26.0250.9 msyii\db\Command::querySELECT COUNT(*) FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=16472) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20))
05:38:25.8880.9 msyii\db\Command::querySELECT * FROM `db2_pagamento` WHERE `id_bollettario_pagamento`='16472'
05:38:25.9840.9 msyii\db\Command::querySELECT * FROM `db1_agente` WHERE `id_agente`=24
05:38:25.9800.9 msyii\db\Command::querySELECT * FROM `db2_sottoscritti` WHERE `id_bollettario_sottoscritti`=16472 ORDER BY `id_sottoscritti` DESC LIMIT 15
05:38:25.9430.9 msyii\db\Command::querySELECT COUNT(*) FROM `db2_docallegato` WHERE `id_bollettario_docallegato`='16472'
05:38:25.8730.9 msyii\db\Command::querySELECT * FROM `db2_bollettario` WHERE `id_bollettario`='16472'
05:38:25.9220.8 msyii\db\Command::querySELECT * FROM `db2_bollettario` WHERE `id_bollettario`='16472'
05:38:26.0260.8 msyii\db\Command::querySELECT * FROM `db2_proprietario` WHERE (`id_bollettario_proprietario`=16472) AND (`tipo_proprietario` IN (1, 2, 3, 4, 20)) LIMIT 20
05:38:26.0500.8 msyii\db\Command::querySELECT * FROM `istat2021` WHERE `id_articolo`=366
05:38:26.0340.8 msyii\db\Command::querySELECT COUNT(*) FROM `db2_verbaleazienda` WHERE `id_bollettario_verbaleazienda`=16472
05:38:26.0190.8 msyii\db\Command::querySELECT * FROM `db1_veicolo` WHERE `id_veicolo`=13493
05:38:26.0280.8 msyii\db\Command::querySELECT * FROM `db1_persona` WHERE `id_persona`=15810
05:38:26.0150.8 msyii\db\Command::querySELECT * FROM `db2_verbaleveicolo` WHERE `id_bollettario_verbaleveicolo`=16472 LIMIT 20
05:38:26.0460.8 msyii\db\Command::querySELECT * FROM `articoli_new` WHERE `id_articolo`='366'
05:38:25.8930.8 msyii\db\Command::querySELECT * FROM `db2_rateizzato` WHERE `id_bollettario_rateizzato`='16472'
05:38:26.0430.8 msyii\db\Command::querySELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=16472 ORDER BY `id_infrazione` DESC LIMIT 15
05:38:25.9660.8 msyii\db\Command::querySELECT * FROM `db1_stradario` WHERE `COD_VIA`=152616
05:38:26.0310.8 msyii\db\Command::querySELECT * FROM `db1_persona` WHERE `id_persona`=15811
05:38:25.9900.8 msyii\db\Command::querySELECT * FROM `db1_agente` WHERE `id_agente`=56
05:38:25.8500.8 msyii\db\Command::querySELECT * FROM `db0_user` WHERE `id`=31
05:38:25.9550.8 msyii\db\Command::querySELECT * FROM `articoli_new` WHERE `id_articolo`='366'
05:38:25.9530.8 msyii\db\Command::querySELECT * FROM `db2_rateizzato` WHERE `id_bollettario_rateizzato`=16472
05:38:25.9920.8 msyii\db\Command::querySELECT * FROM `db1_agente` WHERE `id_agente`=58
05:38:25.9270.8 msyii\db\Command::querySELECT * FROM `db2_decurtazionepunti` WHERE `id_bollettario_decurtazionepunti`='16472'
05:38:26.0520.7 msyii\db\Command::querySELECT * FROM `db0_comuni` WHERE `id_comune`=72006
05:38:26.0420.7 msyii\db\Command::querySELECT COUNT(*) FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=16472
05:38:25.9560.7 msyii\db\Command::querySELECT * FROM `istat2021` WHERE `id_articolo`=366
05:38:25.9510.7 msyii\db\Command::querySELECT * FROM `db0_ente` WHERE `id_ente`=1
05:38:26.0480.6 msyii\db\Command::querySELECT * FROM `db2_infrazione` WHERE `id_infrazione`=18597
05:38:25.9590.6 msyii\db\Command::querySELECT * FROM `db0_user` WHERE `id`=11
05:38:25.9720.6 msyii\db\Command::querySELECT * FROM `db0_comuni` WHERE `id_comune`=72024
05:38:25.8770.6 msyii\db\Command::querySELECT * FROM `db0_ente` WHERE `id_ente`='1'
05:38:25.9600.6 msyii\db\Command::querySELECT * FROM `db0_user` WHERE `id`=11
05:38:25.9340.5 msyii\db\Command::querySELECT * FROM `db0_ente` WHERE `id_ente`=1