0.0017 |
SELECT * FROM `store` WHERE `sid` = 374615
|
0.0020 |
SELECT * FROM `picture` WHERE `sid` = '374615' AND `delflag` =0 LIMIT 9
|
0.0017 |
SELECT COUNT(*) AS `numrows` FROM `picture` WHERE `sid` = 374615 AND `delflag` =0
|
0.0055 |
SELECT COUNT(*) AS `numrows` FROM `reply` WHERE `sid` = 374615
|
0.0012 |
SELECT * FROM `area_group` WHERE `area_start_lat` <= 37.567236 AND `area_end_lat` >= 37.567236 AND `area_start_long` <= 126.9931463 AND `area_end_long` >= 126.9931463
|
0.0022 |
SELECT * FROM `store_theme` WHERE `sid` = 374615
|
0.0036 |
SELECT * FROM `theme_list` WHERE `theme_seq` = '6'
|
0.0044 |
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` = '6' ORDER BY `replyCount` DESC, `picCount` DESC LIMIT 5
|
0.0592 |
SELECT * FROM `reply` WHERE `sid` IN('189582', '74096', '78554', '377116', '374615') GROUP BY `sid` ORDER BY `date` DESC, `rid` DESC
|
0.0035 |
SELECT * FROM `theme_list` WHERE `theme_seq` = '6'
|
0.0041 |
SELECT COUNT(*) AS `numrows` FROM `theme_list` JOIN `theme_links` ON `link_theme` = `theme_seq` JOIN `store` ON `link_store` = `sid` WHERE `theme_seq` = '6'
|
1개의 댓글