ConfigurationRequestRouterLogsProfilingDatabaseEventsAsset BundlesMailTimelineUserDump
Prev Next
All Latest
686cd9d721779: GET https://www.sanzioni.cloud/index.php/codicestrada/bollettario/viewall?id=1&tipo=&anno=2025&stato=&datain=&dataout= at 2025-07-08 08:41:59 am by 93.51.208.125

Database Queries

17 duplicated queries found.

Total 56 items.
TimeDurationTypeDuplicatedQuery
   
08:41:59.1201.5 msSHOW1
SHOW FULL COLUMNS FROM `db0_user`
08:41:59.1231.1 msSELECT1
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'

[+] Explain
08:41:59.1280.9 msSELECT1
SELECT * FROM `db0_user` WHERE `id`=31

[+] Explain
08:41:59.1491.3 msSHOW1
SHOW FULL COLUMNS FROM `db0_ente`
08:41:59.1501.1 msSELECT1
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'

[+] Explain
08:41:59.1520.8 msSELECT1
SELECT * FROM `db0_ente` WHERE `id_ente`='1'

[+] Explain
08:41:59.2063.6 msSHOW1
SHOW FULL COLUMNS FROM `db2_bollettario`
08:41:59.2111.4 msSELECT1
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'

[+] Explain
08:41:59.30672.6 msSELECT1
SELECT COUNT(*) FROM `db2_bollettario` WHERE `db2_bollettario`.`id_ente_bollettario`='1'

[+] Explain
08:41:59.3802.4 msSELECT1
SELECT * FROM `db2_bollettario` WHERE `db2_bollettario`.`id_ente_bollettario`='1' ORDER BY `db2_bollettario`.`id_bollettario` DESC LIMIT 20

[+] Explain
08:41:59.4052.0 msSELECT1
SELECT * FROM `db1_agente` WHERE `id_agente` IN (42, 51, 67, 43, 54, 55, 53, 18, 71, 65, 56, 24)

[+] Explain
08:41:59.4081.9 msSHOW1
SHOW FULL COLUMNS FROM `db1_agente`
08:41:59.4101.2 msSELECT1
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'

[+] Explain
08:41:59.4141.0 msSELECT2
SELECT * FROM `db0_user` WHERE `id` IN (65, 11, 31)

[+] Explain
08:41:59.4160.9 msSELECT2
SELECT * FROM `db0_user` WHERE `id` IN (65, 11, 31)

[+] Explain
08:41:59.4241.9 msSHOW1
SHOW FULL COLUMNS FROM `db2_infrazione`
08:41:59.4271.1 msSELECT1
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'

[+] Explain
08:41:59.4281.0 msSELECT1
SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24909

[+] Explain
08:41:59.4301.0 msSELECT1
SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24908

[+] Explain
08:41:59.4331.6 msSELECT2
SELECT * FROM `articoli_new` WHERE `id_articolo`='1213'

[+] Explain
08:41:59.4352.1 msSHOW1
SHOW FULL COLUMNS FROM `articoli_new`
08:41:59.4381.0 msSELECT1
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'

[+] Explain
08:41:59.4401.2 msSELECT1
SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24907

[+] Explain
08:41:59.4410.9 msSELECT2
SELECT * FROM `articoli_new` WHERE `id_articolo`='1213'

[+] Explain
08:41:59.4430.8 msSELECT1
SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24906

[+] Explain
08:41:59.4440.8 msSELECT1
SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24905

[+] Explain
08:41:59.4461.0 msSELECT9
SELECT * FROM `articoli_new` WHERE `id_articolo`='155'

[+] Explain
08:41:59.4480.9 msSELECT1
SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24904

[+] Explain
08:41:59.4491.0 msSELECT1
SELECT * FROM `articoli_new` WHERE `id_articolo`='580'

[+] Explain
08:41:59.4510.9 msSELECT1
SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24903

[+] Explain
08:41:59.4520.9 msSELECT1
SELECT * FROM `articoli_new` WHERE `id_articolo`='1425'

[+] Explain
08:41:59.4540.8 msSELECT1
SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24902

[+] Explain
08:41:59.4550.9 msSELECT9
SELECT * FROM `articoli_new` WHERE `id_articolo`='155'

[+] Explain
08:41:59.4570.8 msSELECT1
SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24901

[+] Explain
08:41:59.4591.1 msSELECT2
SELECT * FROM `articoli_new` WHERE `id_articolo`='1053'

[+] Explain
08:41:59.4600.8 msSELECT1
SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24900

[+] Explain
08:41:59.4620.9 msSELECT2
SELECT * FROM `articoli_new` WHERE `id_articolo`='1053'

[+] Explain
08:41:59.4640.8 msSELECT1
SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24899

[+] Explain
08:41:59.4650.9 msSELECT9
SELECT * FROM `articoli_new` WHERE `id_articolo`='155'

[+] Explain
08:41:59.4671.1 msSELECT1
SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24898

[+] Explain
08:41:59.4680.8 msSELECT9
SELECT * FROM `articoli_new` WHERE `id_articolo`='155'

[+] Explain
08:41:59.4701.0 msSELECT1
SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24897

[+] Explain
08:41:59.4710.9 msSELECT2
SELECT * FROM `articoli_new` WHERE `id_articolo`='398'

[+] Explain
08:41:59.4730.8 msSELECT1
SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24896

[+] Explain
08:41:59.4740.9 msSELECT9
SELECT * FROM `articoli_new` WHERE `id_articolo`='155'

[+] Explain
08:41:59.4760.9 msSELECT1
SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24895

[+] Explain
08:41:59.4780.8 msSELECT9
SELECT * FROM `articoli_new` WHERE `id_articolo`='155'

[+] Explain
08:41:59.4790.8 msSELECT1
SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24894

[+] Explain
08:41:59.4810.9 msSELECT2
SELECT * FROM `articoli_new` WHERE `id_articolo`='398'

[+] Explain
08:41:59.4820.8 msSELECT1
SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24893

[+] Explain
08:41:59.4840.8 msSELECT9
SELECT * FROM `articoli_new` WHERE `id_articolo`='155'

[+] Explain
08:41:59.4850.9 msSELECT1
SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24892

[+] Explain
08:41:59.4870.9 msSELECT9
SELECT * FROM `articoli_new` WHERE `id_articolo`='155'

[+] Explain
08:41:59.4881.1 msSELECT1
SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24891

[+] Explain
08:41:59.4900.9 msSELECT9
SELECT * FROM `articoli_new` WHERE `id_articolo`='155'

[+] Explain
08:41:59.4920.8 msSELECT1
SELECT * FROM `db2_infrazione` WHERE `id_bollettario_infrazione`=24890

[+] Explain