Performance Profiling

Total processing time: 343 ms; Peak memory: 2.314 MB. Show Profiling Timeline

Total 30 items.

Time	Duration	Category	Info

05:39:10.035	55.3 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 (16472, 1, 31, NOW(), '2025-06-29 00:00:00', '15387.07', '516.66', 'rata 6', 'Bonifico')
05:39:10.113	27.5 ms	yii\db\Command::execute	UPDATE `db2_rateizzato` SET `numero_rate_pagate_rateizzato`=6 WHERE `id_rateizzato`=154
05:39:10.142	23.7 ms	yii\db\Command::execute	UPDATE `db2_bollettario` SET `importo_pagamento_verbale_bollettario`='3188.88' WHERE `id_bollettario`=16472
05:39:09.880	4.6 ms	yii\db\Connection::open	Opening DB connection: mysql:host=localhost;dbname=sanzioni1_0
05:39:09.969	3.4 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `articoli_new`
05:39:09.914	2.9 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `db2_bollettario`
05:39:09.959	2.3 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `db2_rateizzato`
05:39:09.950	2.2 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `db2_infrazione`
05:39:09.918	2.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_bollettario' AND kcu.table_name = 'db2_bollettario'
05:39:09.885	1.9 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `db0_user`
05:39:09.953	1.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 = 'db2_infrazione' AND kcu.table_name = 'db2_infrazione'
05:39:09.923	1.8 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `db0_ente`
05:39:09.974	1.8 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'
05:39:09.956	1.8 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE (`id_bollettario_infrazione`='16472') AND (`id_ente_infrazione`='1')
05:39:09.988	1.8 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `db2_pagamento`
05:39:09.889	1.8 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'
05:39:09.925	1.7 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'
05:39:09.920	1.6 ms	yii\db\Command::query	SELECT * FROM `db2_bollettario` WHERE `id_bollettario`='16472'
05:39:09.947	1.6 ms	yii\db\Command::query	SELECT * FROM `db2_bollettario` WHERE `id_bollettario`='16472'
05:39:09.961	1.6 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'
05:39:09.979	1.6 ms	yii\db\Command::query	SHOW FULL COLUMNS FROM `istat2021`
05:39:09.967	1.6 ms	yii\db\Command::query	SELECT * FROM `articoli_new` WHERE `id_articolo`='366'
05:39:09.964	1.6 ms	yii\db\Command::query	SELECT * FROM `db2_rateizzato` WHERE `id_bollettario_rateizzato`='16472'
05:39:09.981	1.5 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'
05:39:09.894	1.5 ms	yii\db\Command::query	SELECT * FROM `db0_user` WHERE `id`=31
05:39:09.990	1.5 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'
05:39:09.986	1.4 ms	yii\db\Command::query	SELECT * FROM `db2_infrazione` WHERE (`id_bollettario_infrazione`='16472') AND (`id_ente_infrazione`='1')
05:39:09.977	1.3 ms	yii\db\Command::query	SELECT * FROM `istat2021` WHERE `id_articolo`=366
05:39:09.927	1.3 ms	yii\db\Command::query	SELECT * FROM `db0_ente` WHERE `id_ente`='1'
05:39:10.091	1.0 ms	yii\db\Command::query	SELECT * FROM `db2_pagamento` WHERE `id_bollettario_pagamento`='16472'