Total processing time: 489 ms; Peak memory: 3.472 MB. Show Profiling Timeline
Time | Duration | Category | Info |
---|---|---|---|
07:48:20.100 | 83.7 ms | yii\db\Command::query | SELECT COUNT(*) FROM `db2_bollettario` WHERE `db2_bollettario`.`id_ente_bollettario`='1' |
07:48:20.250 | 30.1 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24908 |
07:48:20.185 | 17.2 ms | yii\db\Command::query | SELECT * FROM `db2_bollettario` WHERE `db2_bollettario`.`id_ente_bollettario`='1' ORDER BY `db2_bollettario`.`id_bollettario` DESC LIMIT 20 |
07:48:19.919 | 4.2 ms | yii\db\Connection::open | Opening DB connection: mysql:host=localhost;dbname=sanzioni1_0 |
07:48:20.221 | 3.9 ms | yii\db\Command::query | SELECT * FROM `db1_agente` WHERE `id_agente` IN (42, 51, 67, 43, 54, 55, 53, 18, 71, 65, 56, 24) |
07:48:20.225 | 3.4 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db1_agente` |
07:48:19.923 | 2.9 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db0_user` |
07:48:20.243 | 2.7 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_infrazione` |
07:48:20.229 | 2.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 = 'db1_agente' AND kcu.table_name = 'db1_agente' |
07:48:20.004 | 2.5 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db2_bollettario` |
07:48:20.282 | 1.9 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='1213' |
07:48:20.284 | 1.8 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `articoli_new` |
07:48:20.233 | 1.8 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id` IN (65, 11, 31) |
07:48:19.969 | 1.5 ms | yii\db\Command::query | SHOW FULL COLUMNS FROM `db0_ente` |
07:48:19.932 | 1.4 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' |
07:48:20.246 | 1.4 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' |
07:48:20.248 | 1.2 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24909 |
07:48:19.942 | 1.2 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id`=59 |
07:48:19.971 | 1.2 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' |
07:48:20.288 | 1.2 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' |
07:48:20.007 | 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' |
07:48:20.236 | 1.1 ms | yii\db\Command::query | SELECT * FROM `db0_user` WHERE `id` IN (65, 11, 31) |
07:48:20.309 | 1.0 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24900 |
07:48:20.307 | 1.0 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='1053' |
07:48:20.295 | 1.0 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='155' |
07:48:20.320 | 0.9 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='398' |
07:48:20.311 | 0.9 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='1053' |
07:48:19.972 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db0_ente` WHERE `id_ente`='1' |
07:48:20.291 | 0.9 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='1213' |
07:48:20.314 | 0.9 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='155' |
07:48:20.323 | 0.9 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='155' |
07:48:20.321 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24896 |
07:48:20.298 | 0.9 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='580' |
07:48:20.326 | 0.9 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='155' |
07:48:20.329 | 0.9 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='398' |
07:48:20.335 | 0.9 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='155' |
07:48:20.318 | 0.9 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24897 |
07:48:20.337 | 0.8 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='155' |
07:48:20.315 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24898 |
07:48:20.301 | 0.8 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='1425' |
07:48:20.289 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24907 |
07:48:20.317 | 0.8 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='155' |
07:48:20.300 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24903 |
07:48:20.304 | 0.8 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='155' |
07:48:20.330 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24893 |
07:48:20.303 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24902 |
07:48:20.312 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24899 |
07:48:20.332 | 0.8 ms | yii\db\Command::query | SELECT * FROM `articoli_new` WHERE `id_articolo`='155' |
07:48:20.297 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24904 |
07:48:20.325 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24895 |
07:48:20.306 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24901 |
07:48:20.327 | 0.8 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24894 |
07:48:20.294 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24905 |
07:48:20.333 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24892 |
07:48:20.336 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24891 |
07:48:20.293 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24906 |
07:48:20.339 | 0.7 ms | yii\db\Command::query | SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24890 |