0.0013 |
SELECT * FROM `store` WHERE `sid` = 399130
|
0.0020 |
SELECT * FROM `picture` WHERE `sid` = '399130' AND `delflag` =0 LIMIT 9
|
0.0011 |
SELECT COUNT(*) AS `numrows` FROM `picture` WHERE `sid` = 399130 AND `delflag` =0
|
0.0018 |
SELECT COUNT(*) AS `numrows` FROM `reply` WHERE `sid` = 399130
|
0.0012 |
SELECT * FROM `area_group` WHERE `area_start_lat` <= 37.5256661 AND `area_end_lat` >= 37.5256661 AND `area_start_long` <= 126.9187055 AND `area_end_long` >= 126.9187055
|
0.0015 |
SELECT * FROM `store_theme` WHERE `sid` = 399130
|
0.0011 |
SELECT * FROM `theme_list` WHERE `theme_seq` = '79'
|
0.0019 |
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 5
|
0.0043 |
SELECT * FROM `reply` WHERE `sid` IN('399130', '287197', '283887', '132511', '485749') GROUP BY `sid` ORDER BY `date` DESC, `rid` DESC
|
0.0011 |
SELECT * FROM `theme_list` WHERE `theme_seq` = '79'
|
0.0014 |
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'
|
1개의 댓글