| 0.0005 |
SELECT *
FROM `articles`
WHERE `status` = 1
AND `datetime_start` <= '2025-05-06 13:48:56'
AND `datetime_end` >= '2025-05-06 13:48:56'
AND `category` = '19'
ORDER BY `id` DESC
LIMIT 3, 3
|
| 0.0002 |
SELECT `id`
FROM `articles`
WHERE `status` = 1
AND `datetime_start` <= '2025-05-06 13:48:56'
AND `datetime_end` >= '2025-05-06 13:48:56'
AND `category` = '19'
|
| 0.0002 |
SELECT `name`
FROM `selects_options`
WHERE `id` = '19'
|
| 0.0001 |
SELECT `name`
FROM `selects_options`
WHERE `id` = '19'
|
| 0.0001 |
SELECT `name`
FROM `selects_options`
WHERE `id` = '19'
|
| 0.0003 |
SELECT `id`, CONCAT("articles/detail/", id) AS url, `title`, `updated`, `file_1`
FROM `articles`
WHERE `status` = 1
AND `datetime_start` <= '2025-05-06 13:48:56'
AND `datetime_end` >= '2025-05-06 13:48:56'
ORDER BY `updated` DESC
LIMIT 3
|
| 0.0003 |
SELECT DATE_FORMAT(`updated`, "%Y年%m月") AS `year_month`, DATE_FORMAT(`updated`, "articles/archive/%Y-%m") AS `link`, COUNT(*) AS `count`
FROM `articles`
WHERE `status` = 1
AND `datetime_start` <= '2025-05-06 13:48:56'
AND `datetime_end` >= '2025-05-06 13:48:56'
GROUP BY `year_month`
ORDER BY `year_month` DESC
LIMIT 3
|
| 0.0003 |
SELECT `category`, COUNT(*) AS `count`
FROM `articles`
WHERE `status` = 1
AND `datetime_start` <= '2025-05-06 13:48:56'
AND `datetime_end` >= '2025-05-06 13:48:56'
GROUP BY `category`
ORDER BY `id` DESC
LIMIT 10
|
| 0.0004 |
SELECT `name`
FROM `selects_options`
WHERE `id` = '31'
|
| 0.0002 |
SELECT `name`
FROM `selects_options`
WHERE `id` = '30'
|
| 0.0005 |
SELECT `name`
FROM `selects_options`
WHERE `id` = '20'
|
| 0.0002 |
SELECT `name`
FROM `selects_options`
WHERE `id` = '0'
|
| 0.0001 |
SELECT `name`
FROM `selects_options`
WHERE `id` = '19'
|
