0.0015 |
SELECT * FROM `store` WHERE `sid` = 93746
|
0.0023 |
SELECT * FROM `picture` WHERE `sid` = '93746' AND `delflag` =0 LIMIT 9
|
0.0021 |
SELECT COUNT(*) AS `numrows` FROM `picture` WHERE `sid` = 93746 AND `delflag` =0
|
0.0013 |
SELECT COUNT(*) AS `numrows` FROM `reply` WHERE `sid` = 93746
|
0.0012 |
SELECT * FROM `area_group` WHERE `area_start_lat` <= 36.4503089 AND `area_end_lat` >= 36.4503089 AND `area_start_long` <= 127.1478609 AND `area_end_long` >= 127.1478609
|
0.0014 |
SELECT * FROM `store_theme` WHERE `sid` = 93746
|
0.0011 |
SELECT * FROM `theme_list` WHERE `theme_seq` = '30'
|
0.0018 |
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` = '30' ORDER BY `replyCount` DESC, `picCount` DESC LIMIT 5
|
0.0019 |
SELECT * FROM `reply` WHERE `sid` IN('345648', '93746') GROUP BY `sid` ORDER BY `date` DESC, `rid` DESC
|
0.0012 |
SELECT * FROM `theme_list` WHERE `theme_seq` = '30'
|
0.0013 |
SELECT COUNT(*) AS `numrows` FROM `theme_list` JOIN `theme_links` ON `link_theme` = `theme_seq` JOIN `store` ON `link_store` = `sid` WHERE `theme_seq` = '30'
|
54개의 댓글