0.0013 |
SELECT * FROM `store` WHERE `sid` = 166722
|
0.0031 |
SELECT * FROM `picture` WHERE `sid` = '166722' AND `delflag` =0 LIMIT 9
|
0.0016 |
SELECT COUNT(*) AS `numrows` FROM `picture` WHERE `sid` = 166722 AND `delflag` =0
|
0.0012 |
SELECT COUNT(*) AS `numrows` FROM `reply` WHERE `sid` = 166722
|
0.0012 |
SELECT * FROM `area_group` WHERE `area_start_lat` <= 37.5673466 AND `area_end_lat` >= 37.5673466 AND `area_start_long` <= 126.9808112 AND `area_end_long` >= 126.9808112
|
0.0015 |
SELECT * FROM `store_theme` WHERE `sid` = 166722
|
0.0012 |
SELECT * FROM `theme_list` WHERE `theme_seq` = '70'
|
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` = '70' ORDER BY `replyCount` DESC, `picCount` DESC LIMIT 5
|
0.0014 |
SELECT * FROM `reply` WHERE `sid` IN('166722', '89495', '327983') GROUP BY `sid` ORDER BY `date` DESC, `rid` DESC
|
0.0012 |
SELECT * FROM `theme_list` WHERE `theme_seq` = '70'
|
0.0015 |
SELECT COUNT(*) AS `numrows` FROM `theme_list` JOIN `theme_links` ON `link_theme` = `theme_seq` JOIN `store` ON `link_store` = `sid` WHERE `theme_seq` = '70'
|
8개의 댓글