0.0014 |
SELECT * FROM `store` WHERE `sid` = 278354
|
0.0021 |
SELECT * FROM `picture` WHERE `sid` = '278354' AND `delflag` =0 LIMIT 9
|
0.0011 |
SELECT COUNT(*) AS `numrows` FROM `picture` WHERE `sid` = 278354 AND `delflag` =0
|
0.0011 |
SELECT COUNT(*) AS `numrows` FROM `reply` WHERE `sid` = 278354
|
0.0011 |
SELECT * FROM `area_group` WHERE `area_start_lat` <= 35.0990241 AND `area_end_lat` >= 35.0990241 AND `area_start_long` <= 129.0310612 AND `area_end_long` >= 129.0310612
|
0.0014 |
SELECT * FROM `store_theme` WHERE `sid` = 278354
|
0.0010 |
SELECT * FROM `theme_list` WHERE `theme_seq` = '27'
|
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` = '27' ORDER BY `replyCount` DESC, `picCount` DESC LIMIT 5
|
0.0018 |
SELECT * FROM `reply` WHERE `sid` IN('262193', '408900', '278354') GROUP BY `sid` ORDER BY `date` DESC, `rid` DESC
|
0.0010 |
SELECT * FROM `theme_list` WHERE `theme_seq` = '27'
|
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` = '27'
|
4개의 댓글