[ DB ] CONNECT:[ UseTime:0.001073s ] mysql:host=172.31.9.1;port=3306;dbname=mache_store;charset=utf8
[ SQL ] SHOW COLUMNS FROM `ns_platform_adv` [ RunTime:0.000613s ]
[ SQL ] UPDATE `ns_platform_adv` SET `count`=`count`+1 WHERE `adv_id` = 0 [ RunTime:0.000368s ]
[ SQL ] SHOW COLUMNS FROM `ns_goods_category` [ RunTime:0.000567s ]
[ SQL ] SELECT * FROM `ns_goods_category` WHERE `category_id` = 0 LIMIT 1 [ RunTime:0.000362s ]
[ SQL ] SHOW COLUMNS FROM `ns_goods` [ RunTime:0.000677s ]
[ SQL ] SELECT `ng`.`goods_id`,`ng`.`goods_name`,`ng_sap`.`pic_cover_mid`,`ng`.`promotion_price`,`ng`.`market_price`,`ng`.`goods_type`,`ng`.`stock`,`ng_sap`.`pic_id`,`ng`.`max_buy`,`ng`.`state`,`ng`.`is_hot`,`ng`.`is_recommend`,`ng`.`is_new`,`ng`.`sales`,`ng_sap`.`pic_cover_small`,`ng`.`group_id_array`,`ng`.`shipping_fee`,`ng`.`point_exchange_type`,`ng`.`point_exchange`,`ng`.`is_open_presell`,`ng`.`img_id_array`,`ng`.`introduction` FROM `ns_goods` `ng` LEFT JOIN `sys_album_picture` `ng_sap` ON `ng_sap`.`pic_id`=`ng`.`picture` WHERE ( `ng`.`goods_name` LIKE '%广东塑木厂,广州恒温游泳馆推荐,江门电梯厂家,广州白云化妆品厂,广东检测设备公司等欢迎访问体育百科官方网站:www.ty.gs%' OR `ng`.`keywords` LIKE '%广东塑木厂,广州恒温游泳馆推荐,江门电梯厂家,广州白云化妆品厂,广东检测设备公司等欢迎访问体育百科官方网站:www.ty.gs%' ) AND `ng`.`state` = 1 AND `ng`.`is_search` = 1 ORDER BY `ng`.`sales` DESC,`ng`.`goods_id` DESC LIMIT 0,16 [ RunTime:0.000790s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ns_goods` `ng` WHERE ( `ng`.`goods_name` LIKE '%广东塑木厂,广州恒温游泳馆推荐,江门电梯厂家,广州白云化妆品厂,广东检测设备公司等欢迎访问体育百科官方网站:www.ty.gs%' OR `ng`.`keywords` LIKE '%广东塑木厂,广州恒温游泳馆推荐,江门电梯厂家,广州白云化妆品厂,广东检测设备公司等欢迎访问体育百科官方网站:www.ty.gs%' ) AND `ng`.`state` = 1 AND `ng`.`is_search` = 1 LIMIT 1 [ RunTime:0.000559s ]
[ SQL ] SELECT `category_id`,`category_name`,`short_name`,`pid`,`category_pic`,`category_pic_url`,`category_pic_one`,`category_pic_one_url`,`category_url`,`category_list_img`,`category_list_url` FROM `ns_goods_category` WHERE `level` = 1 AND `is_visible` = 1 ORDER BY `sort` ASC [ RunTime:0.000474s ]
[ SQL ] SELECT `category_id`,`category_name`,`short_name`,`pid`,`category_pic`,`category_url`,`category_list_img`,`category_list_url` FROM `ns_goods_category` WHERE `level` = 2 AND `is_visible` = 1 AND `pid` = 1 ORDER BY `sort` ASC [ RunTime:0.000390s ]
[ SQL ] SELECT `category_id`,`category_name`,`short_name`,`pid`,`category_pic`,`category_url`,`category_list_img`,`category_list_url` FROM `ns_goods_category` WHERE `level` = 3 AND `is_visible` = 1 AND `pid` = 133 ORDER BY `sort` ASC [ RunTime:0.000380s ]
[ SQL ] SELECT `ng`.`goods_id`,`ng`.`goods_name`,`ng_sap`.`pic_cover_mid`,`ng`.`promotion_price`,`ng`.`market_price`,`ng`.`goods_type`,`ng`.`stock`,`ng_sap`.`pic_id`,`ng`.`max_buy`,`ng`.`state`,`ng`.`is_hot`,`ng`.`is_recommend`,`ng`.`is_new`,`ng`.`sales`,`ng_sap`.`pic_cover_small`,`ng`.`group_id_array`,`ng`.`shipping_fee`,`ng`.`point_exchange_type`,`ng`.`point_exchange`,`ng`.`is_open_presell`,`ng`.`img_id_array`,`ng`.`introduction` FROM `ns_goods` `ng` LEFT JOIN `sys_album_picture` `ng_sap` ON `ng_sap`.`pic_id`=`ng`.`picture` WHERE `ng`.`extend_category_id` = 133 AND `state` = 1 ORDER BY `ng`.`sort` ASC,`ng`.`goods_id` ASC LIMIT 0,50 [ RunTime:0.000585s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ns_goods` `ng` WHERE `ng`.`extend_category_id` = 133 AND `state` = 1 LIMIT 1 [ RunTime:0.000422s ]
[ SQL ] SELECT `category_id`,`category_name`,`short_name`,`pid`,`category_pic`,`category_url`,`category_list_img`,`category_list_url` FROM `ns_goods_category` WHERE `level` = 3 AND `is_visible` = 1 AND `pid` = 124 ORDER BY `sort` ASC [ RunTime:0.000344s ]
[ SQL ] SELECT `ng`.`goods_id`,`ng`.`goods_name`,`ng_sap`.`pic_cover_mid`,`ng`.`promotion_price`,`ng`.`market_price`,`ng`.`goods_type`,`ng`.`stock`,`ng_sap`.`pic_id`,`ng`.`max_buy`,`ng`.`state`,`ng`.`is_hot`,`ng`.`is_recommend`,`ng`.`is_new`,`ng`.`sales`,`ng_sap`.`pic_cover_small`,`ng`.`group_id_array`,`ng`.`shipping_fee`,`ng`.`point_exchange_type`,`ng`.`point_exchange`,`ng`.`is_open_presell`,`ng`.`img_id_array`,`ng`.`introduction` FROM `ns_goods` `ng` LEFT JOIN `sys_album_picture` `ng_sap` ON `ng_sap`.`pic_id`=`ng`.`picture` WHERE `ng`.`extend_category_id` = 124 AND `state` = 1 ORDER BY `ng`.`sort` ASC,`ng`.`goods_id` ASC LIMIT 0,50 [ RunTime:0.000543s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ns_goods` `ng` WHERE `ng`.`extend_category_id` = 124 AND `state` = 1 LIMIT 1 [ RunTime:0.000436s ]
[ SQL ] SELECT `category_id`,`category_name`,`short_name`,`pid`,`category_pic`,`category_url`,`category_list_img`,`category_list_url` FROM `ns_goods_category` WHERE `level` = 3 AND `is_visible` = 1 AND `pid` = 6 ORDER BY `sort` ASC [ RunTime:0.000350s ]
[ SQL ] SELECT `ng`.`goods_id`,`ng`.`goods_name`,`ng_sap`.`pic_cover_mid`,`ng`.`promotion_price`,`ng`.`market_price`,`ng`.`goods_type`,`ng`.`stock`,`ng_sap`.`pic_id`,`ng`.`max_buy`,`ng`.`state`,`ng`.`is_hot`,`ng`.`is_recommend`,`ng`.`is_new`,`ng`.`sales`,`ng_sap`.`pic_cover_small`,`ng`.`group_id_array`,`ng`.`shipping_fee`,`ng`.`point_exchange_type`,`ng`.`point_exchange`,`ng`.`is_open_presell`,`ng`.`img_id_array`,`ng`.`introduction` FROM `ns_goods` `ng` LEFT JOIN `sys_album_picture` `ng_sap` ON `ng_sap`.`pic_id`=`ng`.`picture` WHERE `ng`.`extend_category_id` = 6 AND `state` = 1 ORDER BY `ng`.`sort` ASC,`ng`.`goods_id` ASC LIMIT 0,50 [ RunTime:0.000578s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ns_goods` `ng` WHERE `ng`.`extend_category_id` = 6 AND `state` = 1 LIMIT 1 [ RunTime:0.001132s ]
[ SQL ] SHOW COLUMNS FROM `sys_album_picture` [ RunTime:0.000816s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 706 [ RunTime:0.000508s ]
[ SQL ] SELECT `category_id`,`category_name`,`short_name`,`pid`,`category_pic`,`category_url`,`category_list_img`,`category_list_url` FROM `ns_goods_category` WHERE `level` = 3 AND `is_visible` = 1 AND `pid` = 70 ORDER BY `sort` ASC [ RunTime:0.000556s ]
[ SQL ] SELECT `ng`.`goods_id`,`ng`.`goods_name`,`ng_sap`.`pic_cover_mid`,`ng`.`promotion_price`,`ng`.`market_price`,`ng`.`goods_type`,`ng`.`stock`,`ng_sap`.`pic_id`,`ng`.`max_buy`,`ng`.`state`,`ng`.`is_hot`,`ng`.`is_recommend`,`ng`.`is_new`,`ng`.`sales`,`ng_sap`.`pic_cover_small`,`ng`.`group_id_array`,`ng`.`shipping_fee`,`ng`.`point_exchange_type`,`ng`.`point_exchange`,`ng`.`is_open_presell`,`ng`.`img_id_array`,`ng`.`introduction` FROM `ns_goods` `ng` LEFT JOIN `sys_album_picture` `ng_sap` ON `ng_sap`.`pic_id`=`ng`.`picture` WHERE `ng`.`extend_category_id` = 70 AND `state` = 1 ORDER BY `ng`.`sort` ASC,`ng`.`goods_id` ASC LIMIT 0,50 [ RunTime:0.000947s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ns_goods` `ng` WHERE `ng`.`extend_category_id` = 70 AND `state` = 1 LIMIT 1 [ RunTime:0.004659s ]
[ SQL ] SELECT `category_id`,`category_name`,`short_name`,`pid`,`category_pic`,`category_url`,`category_list_img`,`category_list_url` FROM `ns_goods_category` WHERE `level` = 3 AND `is_visible` = 1 AND `pid` = 7 ORDER BY `sort` ASC [ RunTime:0.000538s ]
[ SQL ] SELECT `ng`.`goods_id`,`ng`.`goods_name`,`ng_sap`.`pic_cover_mid`,`ng`.`promotion_price`,`ng`.`market_price`,`ng`.`goods_type`,`ng`.`stock`,`ng_sap`.`pic_id`,`ng`.`max_buy`,`ng`.`state`,`ng`.`is_hot`,`ng`.`is_recommend`,`ng`.`is_new`,`ng`.`sales`,`ng_sap`.`pic_cover_small`,`ng`.`group_id_array`,`ng`.`shipping_fee`,`ng`.`point_exchange_type`,`ng`.`point_exchange`,`ng`.`is_open_presell`,`ng`.`img_id_array`,`ng`.`introduction` FROM `ns_goods` `ng` LEFT JOIN `sys_album_picture` `ng_sap` ON `ng_sap`.`pic_id`=`ng`.`picture` WHERE `ng`.`extend_category_id` = 7 AND `state` = 1 ORDER BY `ng`.`sort` ASC,`ng`.`goods_id` ASC LIMIT 0,50 [ RunTime:0.000993s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ns_goods` `ng` WHERE `ng`.`extend_category_id` = 7 AND `state` = 1 LIMIT 1 [ RunTime:0.000738s ]
[ SQL ] SELECT `category_id`,`category_name`,`short_name`,`pid`,`category_pic`,`category_url`,`category_list_img`,`category_list_url` FROM `ns_goods_category` WHERE `level` = 3 AND `is_visible` = 1 AND `pid` = 2 ORDER BY `sort` ASC [ RunTime:0.001352s ]
[ SQL ] SELECT `ng`.`goods_id`,`ng`.`goods_name`,`ng_sap`.`pic_cover_mid`,`ng`.`promotion_price`,`ng`.`market_price`,`ng`.`goods_type`,`ng`.`stock`,`ng_sap`.`pic_id`,`ng`.`max_buy`,`ng`.`state`,`ng`.`is_hot`,`ng`.`is_recommend`,`ng`.`is_new`,`ng`.`sales`,`ng_sap`.`pic_cover_small`,`ng`.`group_id_array`,`ng`.`shipping_fee`,`ng`.`point_exchange_type`,`ng`.`point_exchange`,`ng`.`is_open_presell`,`ng`.`img_id_array`,`ng`.`introduction` FROM `ns_goods` `ng` LEFT JOIN `sys_album_picture` `ng_sap` ON `ng_sap`.`pic_id`=`ng`.`picture` WHERE `ng`.`extend_category_id` = 2 AND `state` = 1 ORDER BY `ng`.`sort` ASC,`ng`.`goods_id` ASC LIMIT 0,50 [ RunTime:0.000839s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ns_goods` `ng` WHERE `ng`.`extend_category_id` = 2 AND `state` = 1 LIMIT 1 [ RunTime:0.000745s ]
[ SQL ] SELECT `category_id`,`category_name`,`short_name`,`pid`,`category_pic`,`category_url`,`category_list_img`,`category_list_url` FROM `ns_goods_category` WHERE `level` = 2 AND `is_visible` = 1 AND `pid` = 58 ORDER BY `sort` ASC [ RunTime:0.000594s ]
[ SQL ] SELECT `category_id`,`category_name`,`short_name`,`pid`,`category_pic`,`category_url`,`category_list_img`,`category_list_url` FROM `ns_goods_category` WHERE `level` = 3 AND `is_visible` = 1 AND `pid` = 150 ORDER BY `sort` ASC [ RunTime:0.001147s ]
[ SQL ] SELECT `ng`.`goods_id`,`ng`.`goods_name`,`ng_sap`.`pic_cover_mid`,`ng`.`promotion_price`,`ng`.`market_price`,`ng`.`goods_type`,`ng`.`stock`,`ng_sap`.`pic_id`,`ng`.`max_buy`,`ng`.`state`,`ng`.`is_hot`,`ng`.`is_recommend`,`ng`.`is_new`,`ng`.`sales`,`ng_sap`.`pic_cover_small`,`ng`.`group_id_array`,`ng`.`shipping_fee`,`ng`.`point_exchange_type`,`ng`.`point_exchange`,`ng`.`is_open_presell`,`ng`.`img_id_array`,`ng`.`introduction` FROM `ns_goods` `ng` LEFT JOIN `sys_album_picture` `ng_sap` ON `ng_sap`.`pic_id`=`ng`.`picture` WHERE `ng`.`extend_category_id` = 150 AND `state` = 1 ORDER BY `ng`.`sort` ASC,`ng`.`goods_id` ASC LIMIT 0,50 [ RunTime:0.000630s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ns_goods` `ng` WHERE `ng`.`extend_category_id` = 150 AND `state` = 1 LIMIT 1 [ RunTime:0.000442s ]
[ SQL ] SELECT `category_id`,`category_name`,`short_name`,`pid`,`category_pic`,`category_url`,`category_list_img`,`category_list_url` FROM `ns_goods_category` WHERE `level` = 3 AND `is_visible` = 1 AND `pid` = 153 ORDER BY `sort` ASC [ RunTime:0.000377s ]
[ SQL ] SELECT `ng`.`goods_id`,`ng`.`goods_name`,`ng_sap`.`pic_cover_mid`,`ng`.`promotion_price`,`ng`.`market_price`,`ng`.`goods_type`,`ng`.`stock`,`ng_sap`.`pic_id`,`ng`.`max_buy`,`ng`.`state`,`ng`.`is_hot`,`ng`.`is_recommend`,`ng`.`is_new`,`ng`.`sales`,`ng_sap`.`pic_cover_small`,`ng`.`group_id_array`,`ng`.`shipping_fee`,`ng`.`point_exchange_type`,`ng`.`point_exchange`,`ng`.`is_open_presell`,`ng`.`img_id_array`,`ng`.`introduction` FROM `ns_goods` `ng` LEFT JOIN `sys_album_picture` `ng_sap` ON `ng_sap`.`pic_id`=`ng`.`picture` WHERE `ng`.`extend_category_id` = 153 AND `state` = 1 ORDER BY `ng`.`sort` ASC,`ng`.`goods_id` ASC LIMIT 0,50 [ RunTime:0.000523s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ns_goods` `ng` WHERE `ng`.`extend_category_id` = 153 AND `state` = 1 LIMIT 1 [ RunTime:0.000429s ]
[ SQL ] SELECT `category_id`,`category_name`,`short_name`,`pid`,`category_pic`,`category_url`,`category_list_img`,`category_list_url` FROM `ns_goods_category` WHERE `level` = 3 AND `is_visible` = 1 AND `pid` = 166 ORDER BY `sort` ASC [ RunTime:0.000332s ]
[ SQL ] SELECT `ng`.`goods_id`,`ng`.`goods_name`,`ng_sap`.`pic_cover_mid`,`ng`.`promotion_price`,`ng`.`market_price`,`ng`.`goods_type`,`ng`.`stock`,`ng_sap`.`pic_id`,`ng`.`max_buy`,`ng`.`state`,`ng`.`is_hot`,`ng`.`is_recommend`,`ng`.`is_new`,`ng`.`sales`,`ng_sap`.`pic_cover_small`,`ng`.`group_id_array`,`ng`.`shipping_fee`,`ng`.`point_exchange_type`,`ng`.`point_exchange`,`ng`.`is_open_presell`,`ng`.`img_id_array`,`ng`.`introduction` FROM `ns_goods` `ng` LEFT JOIN `sys_album_picture` `ng_sap` ON `ng_sap`.`pic_id`=`ng`.`picture` WHERE `ng`.`extend_category_id` = 166 AND `state` = 1 ORDER BY `ng`.`sort` ASC,`ng`.`goods_id` ASC LIMIT 0,50 [ RunTime:0.000545s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ns_goods` `ng` WHERE `ng`.`extend_category_id` = 166 AND `state` = 1 LIMIT 1 [ RunTime:0.000432s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2727 [ RunTime:0.000286s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2728 [ RunTime:0.000273s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2726 [ RunTime:0.000265s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2729 [ RunTime:0.000275s ]
[ SQL ] SHOW COLUMNS FROM `ns_goods_group` [ RunTime:0.000461s ]
[ SQL ] SELECT `group_name` FROM `ns_goods_group` WHERE `group_id` = 3 LIMIT 1 [ RunTime:0.000323s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2727 [ RunTime:0.000290s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2728 [ RunTime:0.000272s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2726 [ RunTime:0.000269s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2729 [ RunTime:0.000299s ]
[ SQL ] SELECT `group_name` FROM `ns_goods_group` WHERE `group_id` = 3 LIMIT 1 [ RunTime:0.000285s ]
[ SQL ] SELECT `category_id`,`category_name`,`short_name`,`pid`,`category_pic`,`category_url`,`category_list_img`,`category_list_url` FROM `ns_goods_category` WHERE `level` = 3 AND `is_visible` = 1 AND `pid` = 61 ORDER BY `sort` ASC [ RunTime:0.000381s ]
[ SQL ] SELECT `ng`.`goods_id`,`ng`.`goods_name`,`ng_sap`.`pic_cover_mid`,`ng`.`promotion_price`,`ng`.`market_price`,`ng`.`goods_type`,`ng`.`stock`,`ng_sap`.`pic_id`,`ng`.`max_buy`,`ng`.`state`,`ng`.`is_hot`,`ng`.`is_recommend`,`ng`.`is_new`,`ng`.`sales`,`ng_sap`.`pic_cover_small`,`ng`.`group_id_array`,`ng`.`shipping_fee`,`ng`.`point_exchange_type`,`ng`.`point_exchange`,`ng`.`is_open_presell`,`ng`.`img_id_array`,`ng`.`introduction` FROM `ns_goods` `ng` LEFT JOIN `sys_album_picture` `ng_sap` ON `ng_sap`.`pic_id`=`ng`.`picture` WHERE `ng`.`extend_category_id` = 61 AND `state` = 1 ORDER BY `ng`.`sort` ASC,`ng`.`goods_id` ASC LIMIT 0,50 [ RunTime:0.000578s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ns_goods` `ng` WHERE `ng`.`extend_category_id` = 61 AND `state` = 1 LIMIT 1 [ RunTime:0.000452s ]
[ SQL ] SELECT `category_id`,`category_name`,`short_name`,`pid`,`category_pic`,`category_url`,`category_list_img`,`category_list_url` FROM `ns_goods_category` WHERE `level` = 3 AND `is_visible` = 1 AND `pid` = 62 ORDER BY `sort` ASC [ RunTime:0.000404s ]
[ SQL ] SELECT `ng`.`goods_id`,`ng`.`goods_name`,`ng_sap`.`pic_cover_mid`,`ng`.`promotion_price`,`ng`.`market_price`,`ng`.`goods_type`,`ng`.`stock`,`ng_sap`.`pic_id`,`ng`.`max_buy`,`ng`.`state`,`ng`.`is_hot`,`ng`.`is_recommend`,`ng`.`is_new`,`ng`.`sales`,`ng_sap`.`pic_cover_small`,`ng`.`group_id_array`,`ng`.`shipping_fee`,`ng`.`point_exchange_type`,`ng`.`point_exchange`,`ng`.`is_open_presell`,`ng`.`img_id_array`,`ng`.`introduction` FROM `ns_goods` `ng` LEFT JOIN `sys_album_picture` `ng_sap` ON `ng_sap`.`pic_id`=`ng`.`picture` WHERE `ng`.`extend_category_id` = 62 AND `state` = 1 ORDER BY `ng`.`sort` ASC,`ng`.`goods_id` ASC LIMIT 0,50 [ RunTime:0.000550s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ns_goods` `ng` WHERE `ng`.`extend_category_id` = 62 AND `state` = 1 LIMIT 1 [ RunTime:0.000430s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 1466 [ RunTime:0.000302s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 1468 [ RunTime:0.000311s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 1467 [ RunTime:0.000285s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 1465 [ RunTime:0.000285s ]
[ SQL ] SELECT `group_name` FROM `ns_goods_group` WHERE `group_id` = 3 LIMIT 1 [ RunTime:0.000280s ]
[ SQL ] SELECT `category_id`,`category_name`,`short_name`,`pid`,`category_pic`,`category_url`,`category_list_img`,`category_list_url` FROM `ns_goods_category` WHERE `level` = 2 AND `is_visible` = 1 AND `pid` = 4 ORDER BY `sort` ASC [ RunTime:0.000384s ]
[ SQL ] SELECT `category_id`,`category_name`,`short_name`,`pid`,`category_pic`,`category_url`,`category_list_img`,`category_list_url` FROM `ns_goods_category` WHERE `level` = 3 AND `is_visible` = 1 AND `pid` = 74 ORDER BY `sort` ASC [ RunTime:0.000336s ]
[ SQL ] SELECT `ng`.`goods_id`,`ng`.`goods_name`,`ng_sap`.`pic_cover_mid`,`ng`.`promotion_price`,`ng`.`market_price`,`ng`.`goods_type`,`ng`.`stock`,`ng_sap`.`pic_id`,`ng`.`max_buy`,`ng`.`state`,`ng`.`is_hot`,`ng`.`is_recommend`,`ng`.`is_new`,`ng`.`sales`,`ng_sap`.`pic_cover_small`,`ng`.`group_id_array`,`ng`.`shipping_fee`,`ng`.`point_exchange_type`,`ng`.`point_exchange`,`ng`.`is_open_presell`,`ng`.`img_id_array`,`ng`.`introduction` FROM `ns_goods` `ng` LEFT JOIN `sys_album_picture` `ng_sap` ON `ng_sap`.`pic_id`=`ng`.`picture` WHERE `ng`.`extend_category_id` = 74 AND `state` = 1 ORDER BY `ng`.`sort` ASC,`ng`.`goods_id` ASC LIMIT 0,50 [ RunTime:0.000537s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ns_goods` `ng` WHERE `ng`.`extend_category_id` = 74 AND `state` = 1 LIMIT 1 [ RunTime:0.000447s ]
[ SQL ] SELECT `category_id`,`category_name`,`short_name`,`pid`,`category_pic`,`category_url`,`category_list_img`,`category_list_url` FROM `ns_goods_category` WHERE `level` = 3 AND `is_visible` = 1 AND `pid` = 162 ORDER BY `sort` ASC [ RunTime:0.000354s ]
[ SQL ] SELECT `ng`.`goods_id`,`ng`.`goods_name`,`ng_sap`.`pic_cover_mid`,`ng`.`promotion_price`,`ng`.`market_price`,`ng`.`goods_type`,`ng`.`stock`,`ng_sap`.`pic_id`,`ng`.`max_buy`,`ng`.`state`,`ng`.`is_hot`,`ng`.`is_recommend`,`ng`.`is_new`,`ng`.`sales`,`ng_sap`.`pic_cover_small`,`ng`.`group_id_array`,`ng`.`shipping_fee`,`ng`.`point_exchange_type`,`ng`.`point_exchange`,`ng`.`is_open_presell`,`ng`.`img_id_array`,`ng`.`introduction` FROM `ns_goods` `ng` LEFT JOIN `sys_album_picture` `ng_sap` ON `ng_sap`.`pic_id`=`ng`.`picture` WHERE `ng`.`extend_category_id` = 162 AND `state` = 1 ORDER BY `ng`.`sort` ASC,`ng`.`goods_id` ASC LIMIT 0,50 [ RunTime:0.000564s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ns_goods` `ng` WHERE `ng`.`extend_category_id` = 162 AND `state` = 1 LIMIT 1 [ RunTime:0.000435s ]
[ SQL ] SELECT `category_id`,`category_name`,`short_name`,`pid`,`category_pic`,`category_url`,`category_list_img`,`category_list_url` FROM `ns_goods_category` WHERE `level` = 3 AND `is_visible` = 1 AND `pid` = 8 ORDER BY `sort` ASC [ RunTime:0.000372s ]
[ SQL ] SELECT `ng`.`goods_id`,`ng`.`goods_name`,`ng_sap`.`pic_cover_mid`,`ng`.`promotion_price`,`ng`.`market_price`,`ng`.`goods_type`,`ng`.`stock`,`ng_sap`.`pic_id`,`ng`.`max_buy`,`ng`.`state`,`ng`.`is_hot`,`ng`.`is_recommend`,`ng`.`is_new`,`ng`.`sales`,`ng_sap`.`pic_cover_small`,`ng`.`group_id_array`,`ng`.`shipping_fee`,`ng`.`point_exchange_type`,`ng`.`point_exchange`,`ng`.`is_open_presell`,`ng`.`img_id_array`,`ng`.`introduction` FROM `ns_goods` `ng` LEFT JOIN `sys_album_picture` `ng_sap` ON `ng_sap`.`pic_id`=`ng`.`picture` WHERE `ng`.`extend_category_id` = 8 AND `state` = 1 ORDER BY `ng`.`sort` ASC,`ng`.`goods_id` ASC LIMIT 0,50 [ RunTime:0.000533s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ns_goods` `ng` WHERE `ng`.`extend_category_id` = 8 AND `state` = 1 LIMIT 1 [ RunTime:0.000417s ]
[ SQL ] SELECT `category_id`,`category_name`,`short_name`,`pid`,`category_pic`,`category_url`,`category_list_img`,`category_list_url` FROM `ns_goods_category` WHERE `level` = 3 AND `is_visible` = 1 AND `pid` = 9 ORDER BY `sort` ASC [ RunTime:0.000340s ]
[ SQL ] SELECT `ng`.`goods_id`,`ng`.`goods_name`,`ng_sap`.`pic_cover_mid`,`ng`.`promotion_price`,`ng`.`market_price`,`ng`.`goods_type`,`ng`.`stock`,`ng_sap`.`pic_id`,`ng`.`max_buy`,`ng`.`state`,`ng`.`is_hot`,`ng`.`is_recommend`,`ng`.`is_new`,`ng`.`sales`,`ng_sap`.`pic_cover_small`,`ng`.`group_id_array`,`ng`.`shipping_fee`,`ng`.`point_exchange_type`,`ng`.`point_exchange`,`ng`.`is_open_presell`,`ng`.`img_id_array`,`ng`.`introduction` FROM `ns_goods` `ng` LEFT JOIN `sys_album_picture` `ng_sap` ON `ng_sap`.`pic_id`=`ng`.`picture` WHERE `ng`.`extend_category_id` = 9 AND `state` = 1 ORDER BY `ng`.`sort` ASC,`ng`.`goods_id` ASC LIMIT 0,50 [ RunTime:0.000540s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ns_goods` `ng` WHERE `ng`.`extend_category_id` = 9 AND `state` = 1 LIMIT 1 [ RunTime:0.000410s ]
[ SQL ] SELECT `category_id`,`category_name`,`short_name`,`pid`,`category_pic`,`category_url`,`category_list_img`,`category_list_url` FROM `ns_goods_category` WHERE `level` = 2 AND `is_visible` = 1 AND `pid` = 67 ORDER BY `sort` ASC [ RunTime:0.000335s ]
[ SQL ] SELECT `category_id`,`category_name`,`short_name`,`pid`,`category_pic`,`category_url`,`category_list_img`,`category_list_url` FROM `ns_goods_category` WHERE `level` = 3 AND `is_visible` = 1 AND `pid` = 68 ORDER BY `sort` ASC [ RunTime:0.000339s ]
[ SQL ] SELECT `ng`.`goods_id`,`ng`.`goods_name`,`ng_sap`.`pic_cover_mid`,`ng`.`promotion_price`,`ng`.`market_price`,`ng`.`goods_type`,`ng`.`stock`,`ng_sap`.`pic_id`,`ng`.`max_buy`,`ng`.`state`,`ng`.`is_hot`,`ng`.`is_recommend`,`ng`.`is_new`,`ng`.`sales`,`ng_sap`.`pic_cover_small`,`ng`.`group_id_array`,`ng`.`shipping_fee`,`ng`.`point_exchange_type`,`ng`.`point_exchange`,`ng`.`is_open_presell`,`ng`.`img_id_array`,`ng`.`introduction` FROM `ns_goods` `ng` LEFT JOIN `sys_album_picture` `ng_sap` ON `ng_sap`.`pic_id`=`ng`.`picture` WHERE `ng`.`extend_category_id` = 68 AND `state` = 1 ORDER BY `ng`.`sort` ASC,`ng`.`goods_id` ASC LIMIT 0,50 [ RunTime:0.000634s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ns_goods` `ng` WHERE `ng`.`extend_category_id` = 68 AND `state` = 1 LIMIT 1 [ RunTime:0.000458s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 1832 [ RunTime:0.000324s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 1833 [ RunTime:0.000325s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 1835 [ RunTime:0.000306s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 1834 [ RunTime:0.000282s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 1826 [ RunTime:0.000292s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 1831 [ RunTime:0.000320s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 1824 [ RunTime:0.000296s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 1821 [ RunTime:0.000302s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 1823 [ RunTime:0.000296s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 1822 [ RunTime:0.000284s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 1827 [ RunTime:0.000278s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 1825 [ RunTime:0.000296s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 1829 [ RunTime:0.000288s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 1828 [ RunTime:0.000299s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 1830 [ RunTime:0.000285s ]
[ SQL ] SELECT `group_name` FROM `ns_goods_group` WHERE `group_id` = 3 LIMIT 1 [ RunTime:0.000321s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2461 [ RunTime:0.000302s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2460 [ RunTime:0.000279s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2459 [ RunTime:0.000287s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2462 [ RunTime:0.000281s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2469 [ RunTime:0.000271s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2472 [ RunTime:0.000287s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2470 [ RunTime:0.000267s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2471 [ RunTime:0.000291s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2473 [ RunTime:0.000270s ]
[ SQL ] SELECT `group_name` FROM `ns_goods_group` WHERE `group_id` = 1 LIMIT 1 [ RunTime:0.000296s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2477 [ RunTime:0.000294s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2474 [ RunTime:0.000285s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2478 [ RunTime:0.000318s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2476 [ RunTime:0.000328s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2475 [ RunTime:0.000309s ]
[ SQL ] SELECT `group_name` FROM `ns_goods_group` WHERE `group_id` = 1 LIMIT 1 [ RunTime:0.000297s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2479 [ RunTime:0.000296s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2483 [ RunTime:0.000322s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2481 [ RunTime:0.000322s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2482 [ RunTime:0.000329s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2480 [ RunTime:0.000310s ]
[ SQL ] SELECT `group_name` FROM `ns_goods_group` WHERE `group_id` = 1 LIMIT 1 [ RunTime:0.000311s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2488 [ RunTime:0.000323s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2485 [ RunTime:0.000320s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2484 [ RunTime:0.000324s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2486 [ RunTime:0.000323s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2487 [ RunTime:0.000316s ]
[ SQL ] SELECT `group_name` FROM `ns_goods_group` WHERE `group_id` = 1 LIMIT 1 [ RunTime:0.000325s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2492 [ RunTime:0.000318s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2490 [ RunTime:0.000315s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2493 [ RunTime:0.000318s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2491 [ RunTime:0.000326s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2489 [ RunTime:0.000339s ]
[ SQL ] SELECT `group_name` FROM `ns_goods_group` WHERE `group_id` = 1 LIMIT 1 [ RunTime:0.000311s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2502 [ RunTime:0.000321s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2501 [ RunTime:0.000326s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2503 [ RunTime:0.000307s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2499 [ RunTime:0.000328s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2500 [ RunTime:0.000329s ]
[ SQL ] SELECT `group_name` FROM `ns_goods_group` WHERE `group_id` = 1 LIMIT 1 [ RunTime:0.000305s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2508 [ RunTime:0.000295s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2507 [ RunTime:0.000317s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2506 [ RunTime:0.000319s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2504 [ RunTime:0.000323s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2505 [ RunTime:0.000326s ]
[ SQL ] SELECT `group_name` FROM `ns_goods_group` WHERE `group_id` = 1 LIMIT 1 [ RunTime:0.000316s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2509 [ RunTime:0.000324s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2511 [ RunTime:0.000314s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2513 [ RunTime:0.000302s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2510 [ RunTime:0.000315s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2512 [ RunTime:0.000328s ]
[ SQL ] SELECT `group_name` FROM `ns_goods_group` WHERE `group_id` = 1 LIMIT 1 [ RunTime:0.000328s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2514 [ RunTime:0.000303s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2516 [ RunTime:0.000295s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2518 [ RunTime:0.000315s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2517 [ RunTime:0.000314s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2515 [ RunTime:0.000312s ]
[ SQL ] SELECT `group_name` FROM `ns_goods_group` WHERE `group_id` = 1 LIMIT 1 [ RunTime:0.000308s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2521 [ RunTime:0.000298s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2519 [ RunTime:0.000330s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2522 [ RunTime:0.000308s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2520 [ RunTime:0.000314s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2523 [ RunTime:0.000292s ]
[ SQL ] SELECT `group_name` FROM `ns_goods_group` WHERE `group_id` = 1 LIMIT 1 [ RunTime:0.000306s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2524 [ RunTime:0.000316s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2527 [ RunTime:0.000328s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2528 [ RunTime:0.000315s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2526 [ RunTime:0.000309s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2525 [ RunTime:0.000302s ]
[ SQL ] SELECT `group_name` FROM `ns_goods_group` WHERE `group_id` = 1 LIMIT 1 [ RunTime:0.000324s ]
[ SQL ] SELECT `category_id`,`category_name`,`short_name`,`pid`,`category_pic`,`category_url`,`category_list_img`,`category_list_url` FROM `ns_goods_category` WHERE `level` = 2 AND `is_visible` = 1 AND `pid` = 113 ORDER BY `sort` ASC [ RunTime:0.000406s ]
[ SQL ] SELECT `category_id`,`category_name`,`short_name`,`pid`,`category_pic`,`category_url`,`category_list_img`,`category_list_url` FROM `ns_goods_category` WHERE `level` = 3 AND `is_visible` = 1 AND `pid` = 114 ORDER BY `sort` ASC [ RunTime:0.000387s ]
[ SQL ] SELECT `ng`.`goods_id`,`ng`.`goods_name`,`ng_sap`.`pic_cover_mid`,`ng`.`promotion_price`,`ng`.`market_price`,`ng`.`goods_type`,`ng`.`stock`,`ng_sap`.`pic_id`,`ng`.`max_buy`,`ng`.`state`,`ng`.`is_hot`,`ng`.`is_recommend`,`ng`.`is_new`,`ng`.`sales`,`ng_sap`.`pic_cover_small`,`ng`.`group_id_array`,`ng`.`shipping_fee`,`ng`.`point_exchange_type`,`ng`.`point_exchange`,`ng`.`is_open_presell`,`ng`.`img_id_array`,`ng`.`introduction` FROM `ns_goods` `ng` LEFT JOIN `sys_album_picture` `ng_sap` ON `ng_sap`.`pic_id`=`ng`.`picture` WHERE `ng`.`extend_category_id` = 114 AND `state` = 1 ORDER BY `ng`.`sort` ASC,`ng`.`goods_id` ASC LIMIT 0,50 [ RunTime:0.000598s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ns_goods` `ng` WHERE `ng`.`extend_category_id` = 114 AND `state` = 1 LIMIT 1 [ RunTime:0.000476s ]
[ SQL ] SELECT `category_id`,`category_name`,`short_name`,`pid`,`category_pic`,`category_url`,`category_list_img`,`category_list_url` FROM `ns_goods_category` WHERE `level` = 3 AND `is_visible` = 1 AND `pid` = 115 ORDER BY `sort` ASC [ RunTime:0.000394s ]
[ SQL ] SELECT `ng`.`goods_id`,`ng`.`goods_name`,`ng_sap`.`pic_cover_mid`,`ng`.`promotion_price`,`ng`.`market_price`,`ng`.`goods_type`,`ng`.`stock`,`ng_sap`.`pic_id`,`ng`.`max_buy`,`ng`.`state`,`ng`.`is_hot`,`ng`.`is_recommend`,`ng`.`is_new`,`ng`.`sales`,`ng_sap`.`pic_cover_small`,`ng`.`group_id_array`,`ng`.`shipping_fee`,`ng`.`point_exchange_type`,`ng`.`point_exchange`,`ng`.`is_open_presell`,`ng`.`img_id_array`,`ng`.`introduction` FROM `ns_goods` `ng` LEFT JOIN `sys_album_picture` `ng_sap` ON `ng_sap`.`pic_id`=`ng`.`picture` WHERE `ng`.`extend_category_id` = 115 AND `state` = 1 ORDER BY `ng`.`sort` ASC,`ng`.`goods_id` ASC LIMIT 0,50 [ RunTime:0.000570s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ns_goods` `ng` WHERE `ng`.`extend_category_id` = 115 AND `state` = 1 LIMIT 1 [ RunTime:0.000460s ]
[ SQL ] SELECT `category_id`,`category_name`,`short_name`,`pid`,`category_pic`,`category_url`,`category_list_img`,`category_list_url` FROM `ns_goods_category` WHERE `level` = 3 AND `is_visible` = 1 AND `pid` = 128 ORDER BY `sort` ASC [ RunTime:0.000387s ]
[ SQL ] SELECT `ng`.`goods_id`,`ng`.`goods_name`,`ng_sap`.`pic_cover_mid`,`ng`.`promotion_price`,`ng`.`market_price`,`ng`.`goods_type`,`ng`.`stock`,`ng_sap`.`pic_id`,`ng`.`max_buy`,`ng`.`state`,`ng`.`is_hot`,`ng`.`is_recommend`,`ng`.`is_new`,`ng`.`sales`,`ng_sap`.`pic_cover_small`,`ng`.`group_id_array`,`ng`.`shipping_fee`,`ng`.`point_exchange_type`,`ng`.`point_exchange`,`ng`.`is_open_presell`,`ng`.`img_id_array`,`ng`.`introduction` FROM `ns_goods` `ng` LEFT JOIN `sys_album_picture` `ng_sap` ON `ng_sap`.`pic_id`=`ng`.`picture` WHERE `ng`.`extend_category_id` = 128 AND `state` = 1 ORDER BY `ng`.`sort` ASC,`ng`.`goods_id` ASC LIMIT 0,50 [ RunTime:0.000569s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ns_goods` `ng` WHERE `ng`.`extend_category_id` = 128 AND `state` = 1 LIMIT 1 [ RunTime:0.000489s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 1169 [ RunTime:0.000326s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 1166 [ RunTime:0.000306s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 1164 [ RunTime:0.000311s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 1165 [ RunTime:0.000295s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 1168 [ RunTime:0.000323s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 1167 [ RunTime:0.000304s ]
[ SQL ] SELECT `group_name` FROM `ns_goods_group` WHERE `group_id` = 3 LIMIT 1 [ RunTime:0.000301s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 1159 [ RunTime:0.000292s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 1158 [ RunTime:0.000299s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 1163 [ RunTime:0.000283s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 1161 [ RunTime:0.000304s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 1160 [ RunTime:0.000281s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 1162 [ RunTime:0.000303s ]
[ SQL ] SELECT `group_name` FROM `ns_goods_group` WHERE `group_id` = 3 LIMIT 1 [ RunTime:0.000275s ]
[ SQL ] SELECT `category_id`,`category_name`,`short_name`,`pid`,`category_pic`,`category_url`,`category_list_img`,`category_list_url` FROM `ns_goods_category` WHERE `level` = 3 AND `is_visible` = 1 AND `pid` = 141 ORDER BY `sort` ASC [ RunTime:0.000387s ]
[ SQL ] SELECT `ng`.`goods_id`,`ng`.`goods_name`,`ng_sap`.`pic_cover_mid`,`ng`.`promotion_price`,`ng`.`market_price`,`ng`.`goods_type`,`ng`.`stock`,`ng_sap`.`pic_id`,`ng`.`max_buy`,`ng`.`state`,`ng`.`is_hot`,`ng`.`is_recommend`,`ng`.`is_new`,`ng`.`sales`,`ng_sap`.`pic_cover_small`,`ng`.`group_id_array`,`ng`.`shipping_fee`,`ng`.`point_exchange_type`,`ng`.`point_exchange`,`ng`.`is_open_presell`,`ng`.`img_id_array`,`ng`.`introduction` FROM `ns_goods` `ng` LEFT JOIN `sys_album_picture` `ng_sap` ON `ng_sap`.`pic_id`=`ng`.`picture` WHERE `ng`.`extend_category_id` = 141 AND `state` = 1 ORDER BY `ng`.`sort` ASC,`ng`.`goods_id` ASC LIMIT 0,50 [ RunTime:0.000583s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ns_goods` `ng` WHERE `ng`.`extend_category_id` = 141 AND `state` = 1 LIMIT 1 [ RunTime:0.000471s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 1366 [ RunTime:0.000314s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 1363 [ RunTime:0.000278s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 1367 [ RunTime:0.000300s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 1365 [ RunTime:0.000285s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 1368 [ RunTime:0.000278s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 1369 [ RunTime:0.000301s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 1371 [ RunTime:0.000290s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 1374 [ RunTime:0.000277s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 1372 [ RunTime:0.000290s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 1375 [ RunTime:0.000267s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 1373 [ RunTime:0.000299s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 1370 [ RunTime:0.000278s ]
[ SQL ] SELECT `group_name` FROM `ns_goods_group` WHERE `group_id` = 2 LIMIT 1 [ RunTime:0.000301s ]
[ SQL ] SELECT `category_id`,`category_name`,`short_name`,`pid`,`category_pic`,`category_url`,`category_list_img`,`category_list_url` FROM `ns_goods_category` WHERE `level` = 2 AND `is_visible` = 1 AND `pid` = 5 ORDER BY `sort` ASC [ RunTime:0.000372s ]
[ SQL ] SELECT `category_id`,`category_name`,`short_name`,`pid`,`category_pic`,`category_url`,`category_list_img`,`category_list_url` FROM `ns_goods_category` WHERE `level` = 3 AND `is_visible` = 1 AND `pid` = 11 ORDER BY `sort` ASC [ RunTime:0.000411s ]
[ SQL ] SELECT `ng`.`goods_id`,`ng`.`goods_name`,`ng_sap`.`pic_cover_mid`,`ng`.`promotion_price`,`ng`.`market_price`,`ng`.`goods_type`,`ng`.`stock`,`ng_sap`.`pic_id`,`ng`.`max_buy`,`ng`.`state`,`ng`.`is_hot`,`ng`.`is_recommend`,`ng`.`is_new`,`ng`.`sales`,`ng_sap`.`pic_cover_small`,`ng`.`group_id_array`,`ng`.`shipping_fee`,`ng`.`point_exchange_type`,`ng`.`point_exchange`,`ng`.`is_open_presell`,`ng`.`img_id_array`,`ng`.`introduction` FROM `ns_goods` `ng` LEFT JOIN `sys_album_picture` `ng_sap` ON `ng_sap`.`pic_id`=`ng`.`picture` WHERE `ng`.`extend_category_id` = 11 AND `state` = 1 ORDER BY `ng`.`sort` ASC,`ng`.`goods_id` ASC LIMIT 0,50 [ RunTime:0.000606s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ns_goods` `ng` WHERE `ng`.`extend_category_id` = 11 AND `state` = 1 LIMIT 1 [ RunTime:0.000474s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 951 [ RunTime:0.000307s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 947 [ RunTime:0.000269s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 949 [ RunTime:0.000278s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 950 [ RunTime:0.000287s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 948 [ RunTime:0.000269s ]
[ SQL ] SELECT `category_id`,`category_name`,`short_name`,`pid`,`category_pic`,`category_url`,`category_list_img`,`category_list_url` FROM `ns_goods_category` WHERE `level` = 3 AND `is_visible` = 1 AND `pid` = 12 ORDER BY `sort` ASC [ RunTime:0.000392s ]
[ SQL ] SELECT `ng`.`goods_id`,`ng`.`goods_name`,`ng_sap`.`pic_cover_mid`,`ng`.`promotion_price`,`ng`.`market_price`,`ng`.`goods_type`,`ng`.`stock`,`ng_sap`.`pic_id`,`ng`.`max_buy`,`ng`.`state`,`ng`.`is_hot`,`ng`.`is_recommend`,`ng`.`is_new`,`ng`.`sales`,`ng_sap`.`pic_cover_small`,`ng`.`group_id_array`,`ng`.`shipping_fee`,`ng`.`point_exchange_type`,`ng`.`point_exchange`,`ng`.`is_open_presell`,`ng`.`img_id_array`,`ng`.`introduction` FROM `ns_goods` `ng` LEFT JOIN `sys_album_picture` `ng_sap` ON `ng_sap`.`pic_id`=`ng`.`picture` WHERE `ng`.`extend_category_id` = 12 AND `state` = 1 ORDER BY `ng`.`sort` ASC,`ng`.`goods_id` ASC LIMIT 0,50 [ RunTime:0.000551s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ns_goods` `ng` WHERE `ng`.`extend_category_id` = 12 AND `state` = 1 LIMIT 1 [ RunTime:0.000434s ]
[ SQL ] SELECT `category_id`,`category_name`,`short_name`,`pid`,`category_pic`,`category_url`,`category_list_img`,`category_list_url` FROM `ns_goods_category` WHERE `level` = 3 AND `is_visible` = 1 AND `pid` = 109 ORDER BY `sort` ASC [ RunTime:0.000386s ]
[ SQL ] SELECT `ng`.`goods_id`,`ng`.`goods_name`,`ng_sap`.`pic_cover_mid`,`ng`.`promotion_price`,`ng`.`market_price`,`ng`.`goods_type`,`ng`.`stock`,`ng_sap`.`pic_id`,`ng`.`max_buy`,`ng`.`state`,`ng`.`is_hot`,`ng`.`is_recommend`,`ng`.`is_new`,`ng`.`sales`,`ng_sap`.`pic_cover_small`,`ng`.`group_id_array`,`ng`.`shipping_fee`,`ng`.`point_exchange_type`,`ng`.`point_exchange`,`ng`.`is_open_presell`,`ng`.`img_id_array`,`ng`.`introduction` FROM `ns_goods` `ng` LEFT JOIN `sys_album_picture` `ng_sap` ON `ng_sap`.`pic_id`=`ng`.`picture` WHERE `ng`.`extend_category_id` = 109 AND `state` = 1 ORDER BY `ng`.`sort` ASC,`ng`.`goods_id` ASC LIMIT 0,50 [ RunTime:0.000551s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ns_goods` `ng` WHERE `ng`.`extend_category_id` = 109 AND `state` = 1 LIMIT 1 [ RunTime:0.000504s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2666 [ RunTime:0.000342s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2669 [ RunTime:0.000288s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2670 [ RunTime:0.000298s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2668 [ RunTime:0.000284s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2667 [ RunTime:0.000278s ]
[ SQL ] SELECT `category_id`,`category_name`,`short_name`,`pid`,`category_pic`,`category_url`,`category_list_img`,`category_list_url` FROM `ns_goods_category` WHERE `level` = 3 AND `is_visible` = 1 AND `pid` = 13 ORDER BY `sort` ASC [ RunTime:0.000367s ]
[ SQL ] SELECT `ng`.`goods_id`,`ng`.`goods_name`,`ng_sap`.`pic_cover_mid`,`ng`.`promotion_price`,`ng`.`market_price`,`ng`.`goods_type`,`ng`.`stock`,`ng_sap`.`pic_id`,`ng`.`max_buy`,`ng`.`state`,`ng`.`is_hot`,`ng`.`is_recommend`,`ng`.`is_new`,`ng`.`sales`,`ng_sap`.`pic_cover_small`,`ng`.`group_id_array`,`ng`.`shipping_fee`,`ng`.`point_exchange_type`,`ng`.`point_exchange`,`ng`.`is_open_presell`,`ng`.`img_id_array`,`ng`.`introduction` FROM `ns_goods` `ng` LEFT JOIN `sys_album_picture` `ng_sap` ON `ng_sap`.`pic_id`=`ng`.`picture` WHERE `ng`.`extend_category_id` = 13 AND `state` = 1 ORDER BY `ng`.`sort` ASC,`ng`.`goods_id` ASC LIMIT 0,50 [ RunTime:0.000554s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ns_goods` `ng` WHERE `ng`.`extend_category_id` = 13 AND `state` = 1 LIMIT 1 [ RunTime:0.000451s ]
[ SQL ] SELECT `category_id`,`category_name`,`short_name`,`pid`,`category_pic`,`category_url`,`category_list_img`,`category_list_url` FROM `ns_goods_category` WHERE `level` = 3 AND `is_visible` = 1 AND `pid` = 14 ORDER BY `sort` ASC [ RunTime:0.000361s ]
[ SQL ] SELECT `ng`.`goods_id`,`ng`.`goods_name`,`ng_sap`.`pic_cover_mid`,`ng`.`promotion_price`,`ng`.`market_price`,`ng`.`goods_type`,`ng`.`stock`,`ng_sap`.`pic_id`,`ng`.`max_buy`,`ng`.`state`,`ng`.`is_hot`,`ng`.`is_recommend`,`ng`.`is_new`,`ng`.`sales`,`ng_sap`.`pic_cover_small`,`ng`.`group_id_array`,`ng`.`shipping_fee`,`ng`.`point_exchange_type`,`ng`.`point_exchange`,`ng`.`is_open_presell`,`ng`.`img_id_array`,`ng`.`introduction` FROM `ns_goods` `ng` LEFT JOIN `sys_album_picture` `ng_sap` ON `ng_sap`.`pic_id`=`ng`.`picture` WHERE `ng`.`extend_category_id` = 14 AND `state` = 1 ORDER BY `ng`.`sort` ASC,`ng`.`goods_id` ASC LIMIT 0,50 [ RunTime:0.000530s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ns_goods` `ng` WHERE `ng`.`extend_category_id` = 14 AND `state` = 1 LIMIT 1 [ RunTime:0.000416s ]
[ SQL ] SELECT `category_id`,`category_name`,`short_name`,`pid`,`category_pic`,`category_url`,`category_list_img`,`category_list_url` FROM `ns_goods_category` WHERE `level` = 3 AND `is_visible` = 1 AND `pid` = 15 ORDER BY `sort` ASC [ RunTime:0.000368s ]
[ SQL ] SELECT `ng`.`goods_id`,`ng`.`goods_name`,`ng_sap`.`pic_cover_mid`,`ng`.`promotion_price`,`ng`.`market_price`,`ng`.`goods_type`,`ng`.`stock`,`ng_sap`.`pic_id`,`ng`.`max_buy`,`ng`.`state`,`ng`.`is_hot`,`ng`.`is_recommend`,`ng`.`is_new`,`ng`.`sales`,`ng_sap`.`pic_cover_small`,`ng`.`group_id_array`,`ng`.`shipping_fee`,`ng`.`point_exchange_type`,`ng`.`point_exchange`,`ng`.`is_open_presell`,`ng`.`img_id_array`,`ng`.`introduction` FROM `ns_goods` `ng` LEFT JOIN `sys_album_picture` `ng_sap` ON `ng_sap`.`pic_id`=`ng`.`picture` WHERE `ng`.`extend_category_id` = 15 AND `state` = 1 ORDER BY `ng`.`sort` ASC,`ng`.`goods_id` ASC LIMIT 0,50 [ RunTime:0.000549s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ns_goods` `ng` WHERE `ng`.`extend_category_id` = 15 AND `state` = 1 LIMIT 1 [ RunTime:0.000503s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 936 [ RunTime:0.000341s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 937 [ RunTime:0.000280s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 938 [ RunTime:0.000301s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 939 [ RunTime:0.000283s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 940 [ RunTime:0.000304s ]
[ SQL ] SELECT `category_id`,`category_name`,`short_name`,`pid`,`category_pic`,`category_url`,`category_list_img`,`category_list_url` FROM `ns_goods_category` WHERE `level` = 2 AND `is_visible` = 1 AND `pid` = 57 ORDER BY `sort` ASC [ RunTime:0.000384s ]
[ SQL ] SELECT `category_id`,`category_name`,`short_name`,`pid`,`category_pic`,`category_url`,`category_list_img`,`category_list_url` FROM `ns_goods_category` WHERE `level` = 3 AND `is_visible` = 1 AND `pid` = 59 ORDER BY `sort` ASC [ RunTime:0.000367s ]
[ SQL ] SELECT `ng`.`goods_id`,`ng`.`goods_name`,`ng_sap`.`pic_cover_mid`,`ng`.`promotion_price`,`ng`.`market_price`,`ng`.`goods_type`,`ng`.`stock`,`ng_sap`.`pic_id`,`ng`.`max_buy`,`ng`.`state`,`ng`.`is_hot`,`ng`.`is_recommend`,`ng`.`is_new`,`ng`.`sales`,`ng_sap`.`pic_cover_small`,`ng`.`group_id_array`,`ng`.`shipping_fee`,`ng`.`point_exchange_type`,`ng`.`point_exchange`,`ng`.`is_open_presell`,`ng`.`img_id_array`,`ng`.`introduction` FROM `ns_goods` `ng` LEFT JOIN `sys_album_picture` `ng_sap` ON `ng_sap`.`pic_id`=`ng`.`picture` WHERE `ng`.`extend_category_id` = 59 AND `state` = 1 ORDER BY `ng`.`sort` ASC,`ng`.`goods_id` ASC LIMIT 0,50 [ RunTime:0.000589s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ns_goods` `ng` WHERE `ng`.`extend_category_id` = 59 AND `state` = 1 LIMIT 1 [ RunTime:0.000445s ]
[ SQL ] SELECT `category_id`,`category_name`,`short_name`,`pid`,`category_pic`,`category_url`,`category_list_img`,`category_list_url` FROM `ns_goods_category` WHERE `level` = 3 AND `is_visible` = 1 AND `pid` = 60 ORDER BY `sort` ASC [ RunTime:0.000379s ]
[ SQL ] SELECT `ng`.`goods_id`,`ng`.`goods_name`,`ng_sap`.`pic_cover_mid`,`ng`.`promotion_price`,`ng`.`market_price`,`ng`.`goods_type`,`ng`.`stock`,`ng_sap`.`pic_id`,`ng`.`max_buy`,`ng`.`state`,`ng`.`is_hot`,`ng`.`is_recommend`,`ng`.`is_new`,`ng`.`sales`,`ng_sap`.`pic_cover_small`,`ng`.`group_id_array`,`ng`.`shipping_fee`,`ng`.`point_exchange_type`,`ng`.`point_exchange`,`ng`.`is_open_presell`,`ng`.`img_id_array`,`ng`.`introduction` FROM `ns_goods` `ng` LEFT JOIN `sys_album_picture` `ng_sap` ON `ng_sap`.`pic_id`=`ng`.`picture` WHERE `ng`.`extend_category_id` = 60 AND `state` = 1 ORDER BY `ng`.`sort` ASC,`ng`.`goods_id` ASC LIMIT 0,50 [ RunTime:0.000537s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ns_goods` `ng` WHERE `ng`.`extend_category_id` = 60 AND `state` = 1 LIMIT 1 [ RunTime:0.000440s ]
[ SQL ] SELECT `category_id`,`category_name`,`short_name`,`pid`,`category_pic`,`category_url`,`category_list_img`,`category_list_url` FROM `ns_goods_category` WHERE `level` = 3 AND `is_visible` = 1 AND `pid` = 77 ORDER BY `sort` ASC [ RunTime:0.000361s ]
[ SQL ] SELECT `ng`.`goods_id`,`ng`.`goods_name`,`ng_sap`.`pic_cover_mid`,`ng`.`promotion_price`,`ng`.`market_price`,`ng`.`goods_type`,`ng`.`stock`,`ng_sap`.`pic_id`,`ng`.`max_buy`,`ng`.`state`,`ng`.`is_hot`,`ng`.`is_recommend`,`ng`.`is_new`,`ng`.`sales`,`ng_sap`.`pic_cover_small`,`ng`.`group_id_array`,`ng`.`shipping_fee`,`ng`.`point_exchange_type`,`ng`.`point_exchange`,`ng`.`is_open_presell`,`ng`.`img_id_array`,`ng`.`introduction` FROM `ns_goods` `ng` LEFT JOIN `sys_album_picture` `ng_sap` ON `ng_sap`.`pic_id`=`ng`.`picture` WHERE `ng`.`extend_category_id` = 77 AND `state` = 1 ORDER BY `ng`.`sort` ASC,`ng`.`goods_id` ASC LIMIT 0,50 [ RunTime:0.000525s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ns_goods` `ng` WHERE `ng`.`extend_category_id` = 77 AND `state` = 1 LIMIT 1 [ RunTime:0.000398s ]
[ SQL ] SELECT `category_id`,`category_name`,`short_name`,`pid`,`category_pic`,`category_url`,`category_list_img`,`category_list_url` FROM `ns_goods_category` WHERE `level` = 3 AND `is_visible` = 1 AND `pid` = 78 ORDER BY `sort` ASC [ RunTime:0.000362s ]
[ SQL ] SELECT `ng`.`goods_id`,`ng`.`goods_name`,`ng_sap`.`pic_cover_mid`,`ng`.`promotion_price`,`ng`.`market_price`,`ng`.`goods_type`,`ng`.`stock`,`ng_sap`.`pic_id`,`ng`.`max_buy`,`ng`.`state`,`ng`.`is_hot`,`ng`.`is_recommend`,`ng`.`is_new`,`ng`.`sales`,`ng_sap`.`pic_cover_small`,`ng`.`group_id_array`,`ng`.`shipping_fee`,`ng`.`point_exchange_type`,`ng`.`point_exchange`,`ng`.`is_open_presell`,`ng`.`img_id_array`,`ng`.`introduction` FROM `ns_goods` `ng` LEFT JOIN `sys_album_picture` `ng_sap` ON `ng_sap`.`pic_id`=`ng`.`picture` WHERE `ng`.`extend_category_id` = 78 AND `state` = 1 ORDER BY `ng`.`sort` ASC,`ng`.`goods_id` ASC LIMIT 0,50 [ RunTime:0.000511s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ns_goods` `ng` WHERE `ng`.`extend_category_id` = 78 AND `state` = 1 LIMIT 1 [ RunTime:0.000571s ]
[ SQL ] SELECT `category_id`,`category_name`,`short_name`,`pid`,`category_pic`,`category_url`,`category_list_img`,`category_list_url` FROM `ns_goods_category` WHERE `level` = 2 AND `is_visible` = 1 AND `pid` = 98 ORDER BY `sort` ASC [ RunTime:0.000413s ]
[ SQL ] SELECT `category_id`,`category_name`,`short_name`,`pid`,`category_pic`,`category_url`,`category_list_img`,`category_list_url` FROM `ns_goods_category` WHERE `level` = 3 AND `is_visible` = 1 AND `pid` = 99 ORDER BY `sort` ASC [ RunTime:0.000362s ]
[ SQL ] SELECT `ng`.`goods_id`,`ng`.`goods_name`,`ng_sap`.`pic_cover_mid`,`ng`.`promotion_price`,`ng`.`market_price`,`ng`.`goods_type`,`ng`.`stock`,`ng_sap`.`pic_id`,`ng`.`max_buy`,`ng`.`state`,`ng`.`is_hot`,`ng`.`is_recommend`,`ng`.`is_new`,`ng`.`sales`,`ng_sap`.`pic_cover_small`,`ng`.`group_id_array`,`ng`.`shipping_fee`,`ng`.`point_exchange_type`,`ng`.`point_exchange`,`ng`.`is_open_presell`,`ng`.`img_id_array`,`ng`.`introduction` FROM `ns_goods` `ng` LEFT JOIN `sys_album_picture` `ng_sap` ON `ng_sap`.`pic_id`=`ng`.`picture` WHERE `ng`.`extend_category_id` = 99 AND `state` = 1 ORDER BY `ng`.`sort` ASC,`ng`.`goods_id` ASC LIMIT 0,50 [ RunTime:0.000706s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ns_goods` `ng` WHERE `ng`.`extend_category_id` = 99 AND `state` = 1 LIMIT 1 [ RunTime:0.000545s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 717 [ RunTime:0.000357s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 718 [ RunTime:0.000331s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 719 [ RunTime:0.000302s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 720 [ RunTime:0.000320s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 828 [ RunTime:0.000286s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 827 [ RunTime:0.000277s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 826 [ RunTime:0.000280s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 973 [ RunTime:0.000281s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 972 [ RunTime:0.000276s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 970 [ RunTime:0.000297s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 969 [ RunTime:0.000282s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 976 [ RunTime:0.000271s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 974 [ RunTime:0.000279s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 975 [ RunTime:0.000279s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 971 [ RunTime:0.000275s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 697 [ RunTime:0.000279s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 700 [ RunTime:0.000278s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 698 [ RunTime:0.000281s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 699 [ RunTime:0.000286s ]
[ SQL ] SELECT `category_id`,`category_name`,`short_name`,`pid`,`category_pic`,`category_url`,`category_list_img`,`category_list_url` FROM `ns_goods_category` WHERE `level` = 3 AND `is_visible` = 1 AND `pid` = 100 ORDER BY `sort` ASC [ RunTime:0.000397s ]
[ SQL ] SELECT `ng`.`goods_id`,`ng`.`goods_name`,`ng_sap`.`pic_cover_mid`,`ng`.`promotion_price`,`ng`.`market_price`,`ng`.`goods_type`,`ng`.`stock`,`ng_sap`.`pic_id`,`ng`.`max_buy`,`ng`.`state`,`ng`.`is_hot`,`ng`.`is_recommend`,`ng`.`is_new`,`ng`.`sales`,`ng_sap`.`pic_cover_small`,`ng`.`group_id_array`,`ng`.`shipping_fee`,`ng`.`point_exchange_type`,`ng`.`point_exchange`,`ng`.`is_open_presell`,`ng`.`img_id_array`,`ng`.`introduction` FROM `ns_goods` `ng` LEFT JOIN `sys_album_picture` `ng_sap` ON `ng_sap`.`pic_id`=`ng`.`picture` WHERE `ng`.`extend_category_id` = 100 AND `state` = 1 ORDER BY `ng`.`sort` ASC,`ng`.`goods_id` ASC LIMIT 0,50 [ RunTime:0.000611s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ns_goods` `ng` WHERE `ng`.`extend_category_id` = 100 AND `state` = 1 LIMIT 1 [ RunTime:0.000418s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 1521 [ RunTime:0.000316s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 1521 [ RunTime:0.000270s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 704 [ RunTime:0.000281s ]
[ SQL ] SELECT `pic_cover_big`,`pic_cover_mid`,`pic_cover_small` FROM `sys_album_picture` WHERE `pic_id` = 2604 [ RunTime:0.000307s ]
[ SQL ] SELECT `category_id`,`category_name`,`short_name`,`pid`,`category_pic`,`category_url`,`category_list_img`,`category_list_url` FROM `ns_goods_category` WHERE `level` = 2 AND `is_visible` = 1 AND `pid` = 138 ORDER BY `sort` ASC [ RunTime:0.000359s ]
[ SQL ] SHOW COLUMNS FROM `ns_platform_adv_position` [ RunTime:0.000722s ]
[ SQL ] SELECT * FROM `ns_platform_adv_position` WHERE `ap_keyword` = 'PC_INDEX_TOP' AND `is_use` = 1 LIMIT 1 [ RunTime:0.000627s ]
[ SQL ] SELECT `ng`.`goods_id`,`ng`.`goods_name`,`ng`.`introduction`,`ng_sap`.`pic_cover_mid`,`ng`.`promotion_price`,`ng`.`stock`,`ng`.`sales` FROM `ns_goods` `ng` LEFT JOIN `sys_album_picture` `ng_sap` ON `ng_sap`.`pic_id`=`ng`.`picture` LEFT JOIN `ns_promotion_pack` `ns_pa` ON `ns_pa`.`id`=`ng`.`goodsgift` WHERE `ng`.`state` = 1 ORDER BY `ng`.`sales` DESC LIMIT 0,3 [ RunTime:0.000640s ]
[ SQL ] SELECT `ng`.`goods_id`,`ng`.`goods_name`,`ng`.`introduction`,`ng_sap`.`pic_cover_mid`,`ng`.`promotion_price`,`ng`.`stock`,`ng`.`sales`,`ng`.`point_exchange`,`ng`.`point_exchange_type`,`ng`.`shipping_fee` FROM `ns_goods` `ng` LEFT JOIN `sys_album_picture` `ng_sap` ON `ng_sap`.`pic_id`=`ng`.`picture` LEFT JOIN `ns_promotion_pack` `ns_pa` ON `ns_pa`.`id`=`ng`.`goodsgift` WHERE `ng`.`state` = 1 AND `ng`.`is_new` = 1 ORDER BY `ng`.`sort` DESC,`ng`.`goods_id` DESC LIMIT 0,3 [ RunTime:0.000554s ]
