6819ab41a6cdc: GET http://jlggt.com/ at 2025-05-06 02:25:05 pm by 192.168.0.1
Database Queries
总计10条数据。
| # | Time | Duration | Type | Query |
|---|---|---|---|---|
| 1 | 14:25:05.688 | 1.2 ms | SELECT | SELECT * FROM `post` WHERE (`categoryId`=1) AND (publishDate <= '2025-05-06 14:25:05') ORDER BY `publishDate` DESC LIMIT 5
|
| 2 | 14:25:05.686 | 0.9 ms | SHOW | SHOW FULL COLUMNS FROM `category`
|
| 3 | 14:25:05.689 | 0.7 ms | SHOW | SHOW FULL COLUMNS FROM `post`
|
| 4 | 14:25:05.694 | 0.5 ms | SELECT | SELECT * FROM `post` WHERE (`categoryId`=3) AND (publishDate <= '2025-05-06 14:25:05') ORDER BY `publishDate` DESC LIMIT 5
|
| 5 | 14:25:05.685 | 0.5 ms | SELECT | SELECT * FROM `category` WHERE `isDisplayAtHome`=1 ORDER BY `sortNumber`
|
| 6 | 14:25:05.687 | 0.5 ms | SELECT | 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 = 'category' AND kcu.table_name = 'category'
|
| 7 | 14:25:05.696 | 0.5 ms | SELECT | SELECT * FROM `post` WHERE (`categoryId`=4) AND (publishDate <= '2025-05-06 14:25:05') ORDER BY `publishDate` DESC LIMIT 5
|
| 8 | 14:25:05.690 | 0.5 ms | SELECT | 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 = 'post' AND kcu.table_name = 'post'
|
| 9 | 14:25:05.692 | 0.5 ms | SELECT | SELECT * FROM `post` WHERE (`categoryId`=2) AND (publishDate <= '2025-05-06 14:25:05') ORDER BY `publishDate` DESC LIMIT 5
|
| 10 | 14:25:05.697 | 0.4 ms | SELECT | SELECT * FROM `post` WHERE (`categoryId`=5) AND (publishDate <= '2025-05-06 14:25:05') ORDER BY `publishDate` DESC LIMIT 5
|