SHOW FULL COLUMNS FROM `xkyx_classify` [ RunTime:0.000899s ]
SELECT * FROM `xkyx_classify` WHERE `pid` = 0 [ RunTime:0.000555s ]
SELECT * FROM `xkyx_classify` WHERE `pid` = 12 [ RunTime:0.000546s ]
SELECT `title` FROM `xkyx_classify` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000446s ]
SELECT * FROM `xkyx_classify` WHERE `pid` = 684 [ RunTime:0.000480s ]
SELECT `title` FROM `xkyx_classify` WHERE `id` = 684 LIMIT 1 [ RunTime:0.000425s ]
SELECT `title` FROM `xkyx_classify` WHERE `id` = 774 LIMIT 1 [ RunTime:0.000425s ]
SHOW FULL COLUMNS FROM `xkyx_brand` [ RunTime:0.000747s ]
SELECT `title` FROM `xkyx_brand` WHERE `id` = 419 LIMIT 1 [ RunTime:0.000436s ]
SHOW FULL COLUMNS FROM `xkyx_goods` [ RunTime:0.000875s ]
SELECT `b`.`title`,`b`.`id` FROM `xkyx_goods` `g` INNER JOIN `xkyx_brand` `b` ON `g`.`brand`=`b`.`id` WHERE `g`.`g_c` = '12' AND `g`.`g_cs` = '684' AND `g`.`g_ct` = '774' AND `g`.`brand` = '419' GROUP BY `brand` [ RunTime:0.000749s ]
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`.`g_c` = '12' AND `g`.`g_cs` = '684' AND `g`.`g_ct` = '774' AND `g`.`brand` = '419' AND `g`.`use_shop` = '1' AND `p`.`default` = '1' LIMIT 1 [ RunTime:0.000759s ]
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`.`g_c` = '12' AND `g`.`g_cs` = '684' AND `g`.`g_ct` = '774' AND `g`.`brand` = '419' AND `g`.`use_shop` = '1' AND `p`.`default` = '1' ORDER BY g.id desc LIMIT 0,18 [ RunTime:0.000808s ]
加入美音聲光，開始您的合作之旅。