Performance Profiling

Total processing time: 345 ms; Peak memory: 2.311 MB. Show Profiling Timeline

Total 30 items.

Time	Duration	Category	Info

09:10:24.280	46.1 ms	yii\db\Command::execute	INSERT INTO `db2_pagamento` (`id_bollettario_pagamento`, `id_ente_pagamento`, `id_user_created_pagamento`, `data_created_pagamento`, `data_pagamento`, `importotot_verbale_pagamento`, `importopagato_pagamento`, `estremi_pagamento`, `modalita_pagamento`) VALUES (22396, 1, 31, NOW(), '2025-04-28 00:00:00', '15461.30', '255.00', '', 'Bonifico')
09:10:24.356	37.1 ms	yii\db\Command::execute	UPDATE `db2_rateizzato` SET `numero_rate_pagate_rateizzato`=4 WHERE `id_rateizzato`=158
09:10:24.395	23.1 ms	yii\db\Command::execute	UPDATE `db2_bollettario` SET `importo_pagamento_verbale_bollettario`='1189.8' WHERE `id_bollettario`=22396
09:10:24.126	3.5 ms	yii\db\Connection::open	Opening DB connection: mysql:host=localhost;dbname=sanzioni1_0
09:10:24.156	2.1 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `db2_bollettario`
09:10:24.202	1.7 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `articoli_new`
09:10:24.130	1.5 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `db0_user`
09:10:24.189	1.5 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `db2_infrazione`
09:10:24.221	1.4 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `db2_pagamento`
09:10:24.195	1.3 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `db2_rateizzato`
09:10:24.163	1.2 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `db0_ente`
09:10:24.208	1.1 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `istat2021`
09:10:24.159	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'
09:10:24.191	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'
09:10:24.223	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'
09:10:24.133	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'
09:10:24.327	1.0 ms	yii\db\Command::query	SELECT * FROM `db2_pagamento` WHERE `id_bollettario_pagamento`='22396'
09:10:24.205	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 = 'articoli_new' AND kcu.table_name = 'articoli_new'
09:10:24.187	1.0 ms	yii\db\Command::query	SELECT * FROM `db2_bollettario` WHERE `id_bollettario`='22396'
09:10:24.201	1.0 ms	yii\db\Command::query	SELECT * FROM `articoli_new` WHERE `id_articolo`='366'
09:10:24.196	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'
09:10:24.193	1.0 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE (`id_bollettario_infrazione`='22396') AND (`id_ente_infrazione`='1')
09:10:24.210	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 = 'istat2021' AND kcu.table_name = 'istat2021'
09:10:24.219	0.9 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE (`id_bollettario_infrazione`='22396') AND (`id_ente_infrazione`='1')
09:10:24.164	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 = 'db0_ente' AND kcu.table_name = 'db0_ente'
09:10:24.160	0.9 ms	yii\db\Command::query	SELECT * FROM `db2_bollettario` WHERE `id_bollettario`='22396'
09:10:24.207	0.9 ms	yii\db\Command::query	SELECT * FROM `istat2021` WHERE `id_articolo`=366
09:10:24.198	0.9 ms	yii\db\Command::query	SELECT * FROM `db2_rateizzato` WHERE `id_bollettario_rateizzato`='22396'
09:10:24.137	0.8 ms	yii\db\Command::query	SELECT * FROM `db0_user` WHERE `id`=31
09:10:24.165	0.6 ms	yii\db\Command::query	SELECT * FROM `db0_ente` WHERE `id_ente`='1'