681964bb62e5f: GET http://www.jlggt.com/category/3 at 2025-05-06 09:24:11 am by 192.168.0.1
Database Queries
总计7条数据。
| # | Time | Duration | Type | Query |
|---|---|---|---|---|
| 1 | 09:24:11.421 | 7.1 ms | SELECT | SELECT COUNT(*) FROM `post` WHERE (`categoryId`=3) AND (publishDate <= '2025-05-06 09:24:11')
|
| 2 | 09:24:11.412 | 4.1 ms | SHOW | SHOW FULL COLUMNS FROM `category`
|
| 3 | 09:24:11.428 | 1.0 ms | SHOW | SHOW FULL COLUMNS FROM `post`
|
| 4 | 09:24:11.430 | 0.6 ms | SELECT | SELECT * FROM `post` WHERE (`categoryId`=3) AND (publishDate <= '2025-05-06 09:24:11') LIMIT 20
|
| 5 | 09:24:11.429 | 0.6 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'
|
| 6 | 09:24:11.416 | 0.6 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 | 09:24:11.411 | 0.5 ms | SELECT | SELECT * FROM `category` WHERE `id`='3'
|