Performance Profiling

Total processing time: 770 ms; Peak memory: 3.249 MB. Show Profiling Timeline

Total 34 items.
TimeDurationCategoryInfo
  
08:59:34.074285.3 msyii\db\Command::querySELECT COUNT(*) FROM `db2_bollettario` WHERE (`db2_bollettario`.`id_ente_bollettario`='1') AND (`num_ordine_bollettario`='1106')
08:59:34.361228.0 msyii\db\Command::querySELECT * FROM `db2_bollettario` WHERE (`db2_bollettario`.`id_ente_bollettario`='1') AND (`num_ordine_bollettario`='1106') ORDER BY `db2_bollettario`.`id_bollettario` DESC LIMIT 20
08:59:34.62913.2 msyii\db\Command::querySELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=17908
08:59:34.65511.1 msyii\db\Command::querySELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=11579
08:59:34.6128.5 msyii\db\Command::querySELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=21437
08:59:34.6457.6 msyii\db\Command::querySELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=14572
08:59:34.0115.1 msyii\db\Command::querySHOW FULL COLUMNS FROM `db2_bollettario`
08:59:33.9973.5 msyii\db\Command::querySHOW FULL COLUMNS FROM `db0_ente`
08:59:33.9663.5 msyii\db\Command::querySHOW FULL COLUMNS FROM `db0_user`
08:59:34.6733.4 msyii\db\Command::querySELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=4194
08:59:33.9713.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'
08:59:33.9633.0 msyii\db\Connection::openOpening DB connection: mysql:host=localhost;dbname=sanzioni1_0
08:59:34.6682.8 msyii\db\Command::querySELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=8618
08:59:34.0012.7 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'
08:59:34.0172.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'
08:59:34.6252.0 msyii\db\Command::querySHOW FULL COLUMNS FROM `articoli_new`
08:59:34.5942.0 msyii\db\Command::querySHOW FULL COLUMNS FROM `db1_agente`
08:59:34.6222.0 msyii\db\Command::querySELECT * FROM `articoli_new` WHERE `id_articolo`='439'
08:59:34.6781.9 msyii\db\Command::querySELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=1106
08:59:34.5921.8 msyii\db\Command::querySELECT * FROM `db1_agente` WHERE `id_agente` IN (58, 23, 11, 38, 29, 30)
08:59:33.9781.7 msyii\db\Command::querySELECT * FROM `db0_user` WHERE `id`=59
08:59:34.5971.7 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'
08:59:34.0041.6 msyii\db\Command::querySELECT * FROM `db0_ente` WHERE `id_ente`='1'
08:59:34.6001.6 msyii\db\Command::querySELECT * FROM `db0_user` WHERE `id` IN (66, 11, 52, 31, 10)
08:59:34.6091.5 msyii\db\Command::querySHOW FULL COLUMNS FROM `db2_infrazione`
08:59:34.6031.2 msyii\db\Command::querySELECT * FROM `db0_user` WHERE `id` IN (66, 11, 52, 31, 10)
08:59:34.6811.2 msyii\db\Command::querySELECT * FROM `articoli_new` WHERE `id_articolo`='1239'
08:59:34.6111.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'
08:59:34.6280.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'
08:59:34.6660.9 msyii\db\Command::querySELECT * FROM `articoli_new` WHERE `id_articolo`='1423'
08:59:34.6530.9 msyii\db\Command::querySELECT * FROM `articoli_new` WHERE `id_articolo`='155'
08:59:34.6770.8 msyii\db\Command::querySELECT * FROM `articoli_new` WHERE `id_articolo`='155'
08:59:34.6710.8 msyii\db\Command::querySELECT * FROM `articoli_new` WHERE `id_articolo`='155'
08:59:34.6430.8 msyii\db\Command::querySELECT * FROM `articoli_new` WHERE `id_articolo`='1425'