SHOW FULL COLUMNS FROM `sp_sys_setting` [ RunTime:0.000949s ]
SELECT * FROM `sp_sys_setting` WHERE `type` = 'base' [ RunTime:0.000687s ]
SHOW FULL COLUMNS FROM `sp_website_adv` [ RunTime:0.000792s ]
SELECT * FROM `sp_website_adv` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000499s ]
SELECT * FROM `sp_website_adv` WHERE `position` = 2 ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000507s ]
SHOW FULL COLUMNS FROM `sp_hot_search` [ RunTime:0.000653s ]
SELECT `id`,`word`,`url` FROM `sp_hot_search` ORDER BY `sort` DESC LIMIT 8 [ RunTime:0.000374s ]
SHOW FULL COLUMNS FROM `sp_website_links` [ RunTime:0.000659s ]
SELECT * FROM `sp_website_links` WHERE `status` = 1 [ RunTime:0.000385s ]
SHOW FULL COLUMNS FROM `sp_customer` [ RunTime:0.000673s ]
SELECT * FROM `sp_customer` ORDER BY `ord1` DESC [ RunTime:0.000436s ]
SHOW FULL COLUMNS FROM `sp_goods_cate` [ RunTime:0.000766s ]
SELECT `id`,`pid`,`name`,`icon`,`amount` FROM `sp_goods_cate` WHERE ( `status` = 1 ) ORDER BY `amount` DESC LIMIT 500 [ RunTime:0.001108s ]
SHOW FULL COLUMNS FROM `sp_article_cate` [ RunTime:0.000710s ]
SELECT * FROM `sp_article_cate` WHERE `isc` = 2 AND `id` <> 1 AND `status` = 1 [ RunTime:0.000469s ]
SHOW FULL COLUMNS FROM `sp_article` [ RunTime:0.000767s ]
SELECT * FROM `sp_article` WHERE `cate_id` = 3 [ RunTime:0.000521s ]
SELECT * FROM `sp_article` WHERE `cate_id` = 4 [ RunTime:0.000463s ]
SELECT * FROM `sp_article` WHERE `cate_id` = 5 [ RunTime:0.000491s ]
SELECT * FROM `sp_article` WHERE `cate_id` = 6 [ RunTime:0.000505s ]
SELECT * FROM `sp_sys_setting` WHERE `type` = 'base' [ RunTime:0.000550s ]
SELECT `id`,`name`,`level` FROM `sp_goods_cate` WHERE `status` = 1 AND `pid` = 0 ORDER BY `id` DESC LIMIT 500 [ RunTime:0.000668s ]
SELECT `id`,`name`,`pid`,`level`,`seo_title`,`seo_desc`,`seo_keywords`,`amount` FROM `sp_goods_cate` WHERE `id` = 21 LIMIT 1 [ RunTime:0.000423s ]
SHOW FULL COLUMNS FROM `sp_goods_cate_relation` [ RunTime:0.000738s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 21 LIMIT 1 [ RunTime:0.002665s ]
SHOW FULL COLUMNS FROM `sp_goods_rule_tpl` [ RunTime:0.000790s ]
SELECT * FROM `sp_goods_rule_tpl` WHERE `cid` = 21 LIMIT 1 [ RunTime:0.000576s ]
SELECT `pid` FROM `sp_goods_cate` WHERE `id` = 21 LIMIT 1 [ RunTime:0.000497s ]
SHOW FULL COLUMNS FROM `sp_goods_brands` [ RunTime:0.000880s ]
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.004273s ]
SELECT `goods_id` FROM `sp_goods_cate_relation` WHERE `cate_id` = 21 [ RunTime:0.002863s ]
SHOW FULL COLUMNS FROM `sp_goods` [ RunTime:0.001212s ]
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.003196s ]
SELECT `id`,`name` FROM `sp_goods_cate` WHERE `status` = 1 AND `pid` = 21 ORDER BY `sort` ASC LIMIT 500 [ RunTime:0.000700s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 48 LIMIT 1 [ RunTime:0.002703s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 49 LIMIT 1 [ RunTime:0.002614s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 130 LIMIT 1 [ RunTime:0.002689s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 103 LIMIT 1 [ RunTime:0.002681s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 122 LIMIT 1 [ RunTime:0.002640s ]
SELECT * FROM `sp_goods_cate_relation` WHERE `cate_id` = 21 ORDER BY `id` DESC LIMIT 500 [ RunTime:0.004361s ]
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.002520s ]
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.002186s ]
SHOW FULL COLUMNS FROM `sp_goods_attr` [ RunTime:0.000808s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000513s ]
SHOW FULL COLUMNS FROM `sp_seller` [ RunTime:0.001144s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000451s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000414s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000337s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000401s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000393s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000479s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000371s ]
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.000302s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000354s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000277s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000333s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000264s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000319s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000286s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000329s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000260s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000317s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000286s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000326s ]
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.000311s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000277s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000521s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000321s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000469s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000429s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000565s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000444s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000457s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000382s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000407s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000411s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000565s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000494s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000522s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000391s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000508s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000306s ]
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.001217s ]
SELECT `id`,`name`,`slider_image`,`price`,`sales`,`sku`,`stock` FROM `sp_goods` WHERE `is_del` = 2 ORDER BY `sales` DESC LIMIT 10 [ RunTime:0.004966s ]
SHOW FULL COLUMNS FROM `sp_purchase` [ RunTime:0.000834s ]
SELECT `id`,`title` FROM `sp_purchase` WHERE `cate_id` LIKE '%|21|%' LIMIT 10 [ RunTime:0.000541s ]
SHOW FULL COLUMNS FROM `sp_supply` [ RunTime:0.000882s ]
SELECT `id`,`title` FROM `sp_supply` WHERE `cate_id` = '21' LIMIT 10 [ RunTime:0.000516s ]