Database Queries

Всего 8 записей.
TimeDurationTypeDuplicatedQuery
   
08:53:52.9940.4 msSHOW1
SHOW FULL COLUMNS FROM `league`
08:53:52.9950.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 = 'league' AND kcu.table_name = 'league'

08:53:52.9950.0 msSELECT1
SELECT * FROM `league` WHERE `leagueId`='0'

08:53:52.9950.0 msSELECT1
SELECT * FROM `league` WHERE `leagueId` IS NULL

08:53:52.9950.0 msSELECT1
SELECT * FROM `league` ORDER BY `leagueId`

08:53:52.9950.3 msSELECT1
SELECT * FROM `news` WHERE (`leagueId`=1) AND (`type`='0') ORDER BY `createdAt` DESC LIMIT 30

08:53:52.9960.3 msSHOW1
SHOW FULL COLUMNS FROM `news`
08:53:52.9960.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 = 'news' AND kcu.table_name = 'news'