| 0.0011 |
SELECT `t1`.`theme_seq` as `theme_parent`, `t2`.*, `t1`.`theme_alias`
FROM `theme_list` `t1`
JOIN `theme_list` `t2` ON `t1`.`theme_seq` = `t2`.`theme_head`
WHERE `t2`.`theme_seq` = '79'
AND `t1`.`theme_alias` = 'back'
|
| 0.0018 |
SELECT *
FROM `theme_list`
WHERE `theme_seq` = '79'
|
| 0.0034 |
SELECT COUNT(*) AS `numrows`
FROM `theme_list`
JOIN `theme_links` ON `link_theme` = `theme_seq`
JOIN `store` ON `link_store` = `sid`
WHERE `theme_seq` = '79'
|
| 0.0012 |
SELECT `theme_seq` as `seq`, `theme` as `name`
FROM `theme_list`
WHERE `theme_head` = '37'
AND `theme_seq` != '79'
|
| 0.0011 |
SELECT *
FROM `theme_list`
WHERE `theme_seq` = '79'
|
| 0.0022 |
SELECT `theme_list`.*, `s`.*
FROM `store` `s`
JOIN `theme_links` ON `link_store` = `sid`
JOIN `theme_list` ON `link_theme` = `theme_seq`
WHERE `theme_seq` = '79'
ORDER BY `replyCount` DESC, `picCount` DESC
LIMIT 15
|
| 0.0052 |
SELECT *
FROM `reply`
WHERE `sid` IN('399130', '287197', '283887', '132511', '485749')
GROUP BY `sid`
ORDER BY `date` DESC, `rid` DESC
|
| 0.0010 |
SELECT *
FROM `theme_list`
WHERE `theme_seq` = '79'
|
| 0.0012 |
SELECT COUNT(*) AS `numrows`
FROM `theme_list`
JOIN `theme_links` ON `link_theme` = `theme_seq`
JOIN `store` ON `link_store` = `sid`
WHERE `theme_seq` = '79'
|
