SHOW FULL COLUMNS FROM `sp_sys_setting` [ RunTime:0.000802s ]
SELECT * FROM `sp_sys_setting` WHERE `type` = 'base' [ RunTime:0.000701s ]
SHOW FULL COLUMNS FROM `sp_website_adv` [ RunTime:0.000862s ]
SELECT * FROM `sp_website_adv` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000534s ]
SELECT * FROM `sp_website_adv` WHERE `position` = 2 ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000646s ]
SHOW FULL COLUMNS FROM `sp_hot_search` [ RunTime:0.000749s ]
SELECT `id`,`word`,`url` FROM `sp_hot_search` ORDER BY `sort` DESC LIMIT 8 [ RunTime:0.000628s ]
SHOW FULL COLUMNS FROM `sp_website_links` [ RunTime:0.000862s ]
SELECT * FROM `sp_website_links` WHERE `status` = 1 [ RunTime:0.000596s ]
SHOW FULL COLUMNS FROM `sp_customer` [ RunTime:0.000735s ]
SELECT * FROM `sp_customer` ORDER BY `ord1` DESC [ RunTime:0.000467s ]
SHOW FULL COLUMNS FROM `sp_goods_cate` [ RunTime:0.000813s ]
SELECT `id`,`pid`,`name`,`icon`,`amount` FROM `sp_goods_cate` WHERE ( `status` = 1 ) ORDER BY `amount` DESC LIMIT 500 [ RunTime:0.001083s ]
SHOW FULL COLUMNS FROM `sp_article_cate` [ RunTime:0.000804s ]
SELECT * FROM `sp_article_cate` WHERE `isc` = 2 AND `id` <> 1 AND `status` = 1 [ RunTime:0.000610s ]
SHOW FULL COLUMNS FROM `sp_article` [ RunTime:0.000823s ]
SELECT * FROM `sp_article` WHERE `cate_id` = 3 [ RunTime:0.000651s ]
SELECT * FROM `sp_article` WHERE `cate_id` = 4 [ RunTime:0.000511s ]
SELECT * FROM `sp_article` WHERE `cate_id` = 5 [ RunTime:0.000517s ]
SELECT * FROM `sp_article` WHERE `cate_id` = 6 [ RunTime:0.000539s ]
SELECT * FROM `sp_sys_setting` WHERE `type` = 'base' [ RunTime:0.000469s ]
SELECT `id`,`name`,`level` FROM `sp_goods_cate` WHERE `status` = 1 AND `pid` = 0 ORDER BY `id` DESC LIMIT 500 [ RunTime:0.000585s ]
SELECT `id`,`name`,`pid`,`level`,`seo_title`,`seo_desc`,`seo_keywords`,`amount` FROM `sp_goods_cate` WHERE `id` = 21 LIMIT 1 [ RunTime:0.000433s ]
SHOW FULL COLUMNS FROM `sp_goods_cate_relation` [ RunTime:0.000700s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 21 LIMIT 1 [ RunTime:0.002927s ]
SHOW FULL COLUMNS FROM `sp_goods_rule_tpl` [ RunTime:0.000735s ]
SELECT * FROM `sp_goods_rule_tpl` WHERE `cid` = 21 LIMIT 1 [ RunTime:0.000501s ]
SELECT `pid` FROM `sp_goods_cate` WHERE `id` = 21 LIMIT 1 [ RunTime:0.000508s ]
SHOW FULL COLUMNS FROM `sp_goods_brands` [ RunTime:0.000783s ]
SELECT `brand`.`id`,`brand`.`name`,`brand`.`enname` FROM `sp_goods_brands` `brand` INNER JOIN `sp_goods` `goods` ON `brand`.`id`=`goods`.`brand_id` INNER JOIN `sp_goods_cate_relation` `cate` ON `cate`.`cate_id`=21 and cate.goods_id = goods.id WHERE `brand`.`status` = '1' GROUP BY `brand`.`id` [ RunTime:0.004132s ]
SELECT `goods_id` FROM `sp_goods_cate_relation` WHERE `cate_id` = 21 [ RunTime:0.002861s ]
SHOW FULL COLUMNS FROM `sp_goods` [ RunTime:0.001263s ]
SELECT `shudi` FROM `sp_goods` WHERE `id` IN (2909,2910,2911,2912,2913,2914,2915,2916,2923,2924,2925,2926,2927,2928,2929,2930,2931,2932,2933,2934,2935,2936,2939,2940,2941,2942,2943,2944,2945,2946,2947,2950,2951,2952,2953,2955,2957,2960,2961,2962,2995,3338,3429,3430,3431,3433,3440,3548,3631,3720,3721,3722,3735,3799,3825,3826,3846,3862,3881,3971,4119,4130,4135,4138,4139,4147,4148,4149,4162,4163,4166,4172,4181,4186,4220,4279,4368,4391,4398,4411,4413,4472,4506,4551,4578,4579,4633,4634,4665,4671,4712,4713,4714,4740,4755,4765,4766,4780,4826,4841,4868,4882,4894,4972,5050,5068,5069,5087,5108,5162,5170,5195,5199,5340,5368,5397,5417,5468,5471,5495,5510,5518,5564,5666,5776,5798,5810,5821,5838,5848,5857,5955,6045,6063,6071,6133,6168,6171,6177,6185,6187,6191,6192,6201,6202,6203,6204,6205,6208,6209,6210,6227,6254,6332,6366,6383,6409,6412,6485,6512,6526,6575,6625,6649,6679,6701,6713,6733,6738,6740,6741,6753,6763,6770,6771,6776,6833,6834,6876,7055,7073,7074,7194,7195,7253,7281,8901,8902,6207,8948,8949,9150,9155,9190,9207,9210,9211,9212,9213,9214,9216,9217,9218,9219,9238,9239,9240,9241) AND `shudi` > 0 GROUP BY `shudi` [ RunTime:0.002328s ]
SELECT `id`,`name` FROM `sp_goods_cate` WHERE `status` = 1 AND `pid` = 21 ORDER BY `sort` ASC LIMIT 500 [ RunTime:0.000604s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 48 LIMIT 1 [ RunTime:0.002659s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 49 LIMIT 1 [ RunTime:0.002670s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 130 LIMIT 1 [ RunTime:0.002607s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 103 LIMIT 1 [ RunTime:0.002613s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 122 LIMIT 1 [ RunTime:0.002603s ]
SELECT * FROM `sp_goods_cate_relation` WHERE `cate_id` = 21 ORDER BY `id` DESC LIMIT 500 [ RunTime:0.004370s ]
SELECT COUNT(*) AS think_count FROM `sp_goods` WHERE `id` IN (9241,9240,9239,9238,9219,9218,9217,9216,9214,9213,9212,9211,9210,9207,9190,9155,9150,8949,8948,6207,8902,8901,7281,7253,7195,7194,7074,7073,7055,6876,6834,6833,6776,6771,6770,6763,6753,6741,6740,6738,6733,6713,6701,6679,6649,6625,6575,6526,6512,6485,6412,6409,6383,6366,6332,6254,6227,6210,6209,6208,6205,6204,6203,6202,6201,6192,6191,6187,6185,6177,6171,6168,6133,6071,6063,6045,5955,5857,5848,5838,5821,5810,5798,5776,5666,5564,5518,5510,5495,5471,5468,5417,5397,5368,5340,5199,5195,5170,5162,5108,5087,5069,5068,5050,4972,4894,4882,4868,4841,4826,4780,4766,4765,4755,4740,4714,4713,4712,4671,4665,4634,4633,4579,4578,4551,4506,4472,4413,4411,4398,4391,4368,4279,4220,4186,4181,4172,4166,4163,4162,4149,4148,4147,4139,4138,4135,4130,4119,3971,3881,3862,3846,3826,3825,3799,3735,3722,3721,3720,3631,3548,3440,3433,3431,3430,3429,3338,2995,2962,2961,2960,2957,2955,2953,2952,2951,2950,2947,2946,2945,2944,2943,2942,2941,2940,2939,2936,2935,2934,2933,2932,2931,2930,2929,2928,2927,2926,2925,2924,2923,2916,2915,2914,2913,2912,2911,2910,2909) AND `is_del` = 2 AND `is_show` = 1 AND `is_open` = 0 LIMIT 1 [ RunTime:0.002398s ]
SELECT `id`,`name`,`slider_image`,`sales`,`collects`,`price`,`sku`,`sub_name`,`moq`,`bzs`,`bzdw` FROM `sp_goods` WHERE `id` IN (9241,9240,9239,9238,9219,9218,9217,9216,9214,9213,9212,9211,9210,9207,9190,9155,9150,8949,8948,6207,8902,8901,7281,7253,7195,7194,7074,7073,7055,6876,6834,6833,6776,6771,6770,6763,6753,6741,6740,6738,6733,6713,6701,6679,6649,6625,6575,6526,6512,6485,6412,6409,6383,6366,6332,6254,6227,6210,6209,6208,6205,6204,6203,6202,6201,6192,6191,6187,6185,6177,6171,6168,6133,6071,6063,6045,5955,5857,5848,5838,5821,5810,5798,5776,5666,5564,5518,5510,5495,5471,5468,5417,5397,5368,5340,5199,5195,5170,5162,5108,5087,5069,5068,5050,4972,4894,4882,4868,4841,4826,4780,4766,4765,4755,4740,4714,4713,4712,4671,4665,4634,4633,4579,4578,4551,4506,4472,4413,4411,4398,4391,4368,4279,4220,4186,4181,4172,4166,4163,4162,4149,4148,4147,4139,4138,4135,4130,4119,3971,3881,3862,3846,3826,3825,3799,3735,3722,3721,3720,3631,3548,3440,3433,3431,3430,3429,3338,2995,2962,2961,2960,2957,2955,2953,2952,2951,2950,2947,2946,2945,2944,2943,2942,2941,2940,2939,2936,2935,2934,2933,2932,2931,2930,2929,2928,2927,2926,2925,2924,2923,2916,2915,2914,2913,2912,2911,2910,2909) AND `is_del` = 2 AND `is_show` = 1 AND `is_open` = 0 ORDER BY `id` DESC LIMIT 0,20 [ RunTime:0.002073s ]
SHOW FULL COLUMNS FROM `sp_goods_attr` [ RunTime:0.000803s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000387s ]
SHOW FULL COLUMNS FROM `sp_seller` [ RunTime:0.001040s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000378s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000370s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000265s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000392s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000325s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000367s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000267s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000320s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000259s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000445s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000309s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000365s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000360s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000375s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000305s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000425s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000388s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000526s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000428s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000494s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000357s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000431s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000380s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000468s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000431s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000384s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000272s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000335s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000311s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000357s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000261s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000321s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000261s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000350s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000295s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000321s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000265s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000335s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000271s ]
SELECT * FROM `sp_goods` `goods` INNER JOIN `sp_goods_cate_relation` `cate` ON `cate`.`goods_id`=`goods`.`id` WHERE `cate`.`cate_id` = '21' AND `goods`.`is_recommend` = '1' LIMIT 10 [ RunTime:0.001055s ]
SELECT `id`,`name`,`slider_image`,`price`,`sales`,`sku`,`stock` FROM `sp_goods` WHERE `is_del` = 2 ORDER BY `sales` DESC LIMIT 10 [ RunTime:0.005105s ]
SHOW FULL COLUMNS FROM `sp_purchase` [ RunTime:0.000812s ]
SELECT `id`,`title` FROM `sp_purchase` WHERE `cate_id` LIKE '%|21|%' LIMIT 10 [ RunTime:0.000413s ]
SHOW FULL COLUMNS FROM `sp_supply` [ RunTime:0.000855s ]
SELECT `id`,`title` FROM `sp_supply` WHERE `cate_id` = '21' LIMIT 10 [ RunTime:0.000398s ]