| 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` = '77'
AND `t1`.`theme_alias` = 'back'
|
| 0.0010 |
SELECT *
FROM `theme_list`
WHERE `theme_seq` = '77'
|
| 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` = '77'
|
| 0.0011 |
SELECT `theme_seq` as `seq`, `theme` as `name`
FROM `theme_list`
WHERE `theme_head` = '37'
AND `theme_seq` != '77'
|
| 0.0011 |
SELECT *
FROM `theme_list`
WHERE `theme_seq` = '77'
|
| 0.0017 |
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` = '77'
ORDER BY `replyCount` DESC, `picCount` DESC
LIMIT 15
|
| 0.0079 |
SELECT *
FROM `reply`
WHERE `sid` IN('86034', '193320', '418398', '455230')
GROUP BY `sid`
ORDER BY `date` DESC, `rid` DESC
|
| 0.0011 |
SELECT *
FROM `theme_list`
WHERE `theme_seq` = '77'
|
| 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` = '77'
|
