SHOW FULL COLUMNS FROM `xkyx_shopapp` [ RunTime:0.001094s ]
SELECT `id`,`title`,`pc_bg`,`first_city`,`secondary_city`,`city`,`key`,`shop_code` FROM `xkyx_shopapp` WHERE `id` = 1000 LIMIT 1 [ RunTime:0.000661s ]
SHOW FULL COLUMNS FROM `xkyx_region` [ RunTime:0.000851s ]
SELECT `name` FROM `xkyx_region` WHERE `id` IN (22,45055,374) ORDER BY FIELD(id,22,45055,374) [ RunTime:0.000702s ]
SHOW FULL COLUMNS FROM `xkyx_goods` [ RunTime:0.000942s ]
SELECT COUNT(`id`) AS think_count FROM `xkyx_goods` WHERE `sid` = 1000 AND `use_shop` = 1 LIMIT 1 [ RunTime:0.000632s ]
SHOW FULL COLUMNS FROM `xkyx_exashop` [ RunTime:0.000897s ]
SELECT `capital`,`person`,`licadd`,`range`,`credit`,`registration_authority`,`enterprise_scale`,`taxpayer_qualification`,`enterprise_name`,`establishment_time`,`registration_status` FROM `xkyx_exashop` WHERE `sid` = 1000 LIMIT 1 [ RunTime:0.001373s ]
SELECT `b`.`id`,`b`.`title` FROM `xkyx_goods` `g` INNER JOIN `xkyx_brand` `b` ON `g`.`brand`=`b`.`id` WHERE `g`.`sid` = '1000' GROUP BY `g`.`brand` LIMIT 5 [ RunTime:0.000602s ]