All Latest
6874ed7ab8a85: GET https://www.sanzioni.cloud/index.php/anagrafica/persona/viewall?id=1 at 2025-07-14 11:43:54 am by 93.51.208.125

Database Queries

2 duplicated queries found.

Total 16 items.
TimeDurationTypeDuplicatedQuery
   
11:43:54.7411.2 msSHOW1
SHOW FULL COLUMNS FROM `db0_user`
11:43:54.7431.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 = 'db0_user' AND kcu.table_name = 'db0_user'

11:43:54.7480.6 msSELECT1
SELECT * FROM `db0_user` WHERE `id`=59

11:43:54.8021.2 msSHOW1
SHOW FULL COLUMNS FROM `db0_ente`
11:43:54.8031.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'

11:43:54.8050.6 msSELECT1
SELECT * FROM `db0_ente` WHERE `id_ente`='1'

11:43:54.8301.7 msSHOW1
SHOW FULL COLUMNS FROM `db1_persona`
11:43:54.8331.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 = 'db1_persona' AND kcu.table_name = 'db1_persona'

11:43:54.861235.1 msSELECT1
SELECT COUNT(*) FROM `db1_persona` WHERE `db1_persona`.`id_ente_persona`='1'

11:43:55.09718.6 msSELECT1
SELECT * FROM `db1_persona` WHERE `db1_persona`.`id_ente_persona`='1' ORDER BY `db1_persona`.`id_persona` DESC LIMIT 20

11:43:55.12144.5 msSELECT1
SELECT * FROM `db0_comuni` WHERE `id_comune` IN (72011, 72029, 72006, 61005, 72023, 72004, 72037, 512252, 72024, 72044, 72012, 20565)

11:43:55.1661.4 msSHOW1
SHOW FULL COLUMNS FROM `db0_comuni`
11:43:55.1680.9 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_comuni' AND kcu.table_name = 'db0_comuni'

11:43:55.1712.3 msSELECT1
SELECT * FROM `db0_comuni` WHERE `id_comune` IN (72011, 72029, 72048, 72006, 72023, 512252, 99999999, 72024, 72044, 72012, 72004)

11:43:55.1741.0 msSELECT2
SELECT * FROM `db0_user` WHERE `id` IN (8, 11, 31)

11:43:55.1760.7 msSELECT2
SELECT * FROM `db0_user` WHERE `id` IN (8, 11, 31)