SHOW FULL COLUMNS FROM `xkyx_shopapp` [ RunTime:0.001022s ]
SELECT `id`,`title`,`pc_bg`,`first_city`,`secondary_city`,`city`,`key`,`shop_code` FROM `xkyx_shopapp` WHERE `id` = 195 LIMIT 1 [ RunTime:0.000572s ]
SHOW FULL COLUMNS FROM `xkyx_region` [ RunTime:0.000698s ]
SELECT `name` FROM `xkyx_region` WHERE `id` IN (19,289,3042) ORDER BY FIELD(id,19,289,3042) [ RunTime:0.000595s ]
SHOW FULL COLUMNS FROM `xkyx_goods` [ RunTime:0.000799s ]
SELECT COUNT(`id`) AS think_count FROM `xkyx_goods` WHERE `sid` = 195 AND `use_shop` = 1 LIMIT 1 [ RunTime:0.000718s ]
SHOW FULL COLUMNS FROM `xkyx_exashop` [ RunTime:0.000662s ]
SELECT `capital`,`person`,`licadd`,`range`,`credit`,`registration_authority`,`enterprise_scale`,`taxpayer_qualification`,`enterprise_name`,`establishment_time`,`registration_status` FROM `xkyx_exashop` WHERE `sid` = 195 LIMIT 1 [ RunTime:0.000639s ]
SELECT `b`.`id`,`b`.`title` FROM `xkyx_goods` `g` INNER JOIN `xkyx_brand` `b` ON `g`.`brand`=`b`.`id` WHERE `g`.`sid` = '195' GROUP BY `g`.`brand` LIMIT 5 [ RunTime:0.000886s ]
SELECT `g_c` FROM `xkyx_goods` WHERE `sid` = 195 GROUP BY `g_c` [ RunTime:0.000775s ]
SHOW FULL COLUMNS FROM `xkyx_classify` [ RunTime:0.000610s ]
SELECT * FROM `xkyx_classify` WHERE `id` IN (1,3,10,12,113,115) [ RunTime:0.000442s ]
SELECT `g_cs` FROM `xkyx_goods` WHERE `sid` = 195 AND `g_c` = 1 GROUP BY `g_cs` [ RunTime:0.000811s ]
SELECT * FROM `xkyx_classify` WHERE `id` IN (16,18,70,71,72,137,674) [ RunTime:0.000454s ]
SELECT `title` FROM `xkyx_classify` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000431s ]
SELECT `g_ct` FROM `xkyx_goods` WHERE `sid` = 195 AND `g_cs` = 16 GROUP BY `g_ct` [ RunTime:0.000773s ]
SELECT * FROM `xkyx_classify` WHERE `id` IN (36,37,64,87,692,699,700,809) [ RunTime:0.000448s ]
SELECT `title` FROM `xkyx_classify` WHERE `id` = 16 LIMIT 1 [ RunTime:0.000464s ]
SELECT `title` FROM `xkyx_classify` WHERE `id` = 36 LIMIT 1 [ RunTime:0.000412s ]
SHOW FULL COLUMNS FROM `xkyx_brand` [ RunTime:0.000763s ]
SELECT `title` FROM `xkyx_brand` WHERE `id` = 280 LIMIT 1 [ RunTime:0.000414s ]
SELECT `b`.`title`,`b`.`id` FROM `xkyx_goods` `g` INNER JOIN `xkyx_brand` `b` ON `g`.`brand`=`b`.`id` WHERE `g`.`sid` = '195' AND `g`.`g_c` = '1' AND `g`.`g_cs` = '16' AND `g`.`g_ct` = '36' AND `g`.`brand` = '280' GROUP BY `brand` [ RunTime:0.000829s ]
SELECT COUNT(*) AS think_count FROM `xkyx_goods` `g` LEFT JOIN `xkyx_brand` `b` ON `g`.`brand`=`b`.`id` LEFT JOIN `xkyx_br_address` `br` ON `br`.`id`=`b`.`address` LEFT JOIN `xkyx_picture` `pic` ON `pic`.`id`=`g`.`pic` INNER JOIN `xkyx_goods_price` `gp` ON `g`.`id`=`gp`.`goods_id` INNER JOIN `xkyx_price` `p` ON `p`.`id`=`gp`.`price_id` INNER JOIN `xkyx_shopapp` `s` ON `g`.`sid`=`s`.`id` WHERE `g`.`sid` = '195' AND `g`.`g_c` = '1' AND `g`.`g_cs` = '16' AND `g`.`g_ct` = '36' AND `g`.`brand` = '280' AND `g`.`use_shop` = '1' AND `p`.`default` = '1' LIMIT 1 [ RunTime:0.001117s ]
SELECT `g`.`id`,`g`.`title`,`g`.`sid`,`g`.`brand`,`pic`.`path`,`g`.`mod`,`g`.`meter`,b.title as brandTitle,gp.value as price,s.title as shopTitle FROM `xkyx_goods` `g` LEFT JOIN `xkyx_brand` `b` ON `g`.`brand`=`b`.`id` LEFT JOIN `xkyx_br_address` `br` ON `br`.`id`=`b`.`address` LEFT JOIN `xkyx_picture` `pic` ON `pic`.`id`=`g`.`pic` INNER JOIN `xkyx_goods_price` `gp` ON `g`.`id`=`gp`.`goods_id` INNER JOIN `xkyx_price` `p` ON `p`.`id`=`gp`.`price_id` INNER JOIN `xkyx_shopapp` `s` ON `g`.`sid`=`s`.`id` WHERE `g`.`sid` = '195' AND `g`.`g_c` = '1' AND `g`.`g_cs` = '16' AND `g`.`g_ct` = '36' AND `g`.`brand` = '280' AND `g`.`use_shop` = '1' AND `p`.`default` = '1' ORDER BY g.id desc LIMIT 0,18 [ RunTime:0.001112s ]
加入美音聲光，開始您的合作之旅。