SHOW FULL COLUMNS FROM `sp_sys_setting` [ RunTime:0.001639s ]
SELECT * FROM `sp_sys_setting` WHERE `type` = 'base' [ RunTime:0.001320s ]
SHOW FULL COLUMNS FROM `sp_website_adv` [ RunTime:0.001720s ]
SELECT * FROM `sp_website_adv` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000967s ]
SELECT * FROM `sp_website_adv` WHERE `position` = 2 ORDER BY `id` ASC LIMIT 500 [ RunTime:0.001017s ]
SHOW FULL COLUMNS FROM `sp_hot_search` [ RunTime:0.001411s ]
SELECT `id`,`word`,`url` FROM `sp_hot_search` ORDER BY `sort` DESC LIMIT 8 [ RunTime:0.000878s ]
SHOW FULL COLUMNS FROM `sp_website_links` [ RunTime:0.001660s ]
SELECT * FROM `sp_website_links` WHERE `status` = 1 [ RunTime:0.000972s ]
SHOW FULL COLUMNS FROM `sp_customer` [ RunTime:0.001507s ]
SELECT * FROM `sp_customer` ORDER BY `ord1` DESC [ RunTime:0.000944s ]
SHOW FULL COLUMNS FROM `sp_goods_cate` [ RunTime:0.001665s ]
SELECT `id`,`pid`,`name`,`icon`,`amount` FROM `sp_goods_cate` WHERE ( `status` = 1 ) ORDER BY `amount` DESC LIMIT 500 [ RunTime:0.002265s ]
SHOW FULL COLUMNS FROM `sp_article_cate` [ RunTime:0.001482s ]
SELECT * FROM `sp_article_cate` WHERE `isc` = 2 AND `id` <> 1 AND `status` = 1 [ RunTime:0.001093s ]
SHOW FULL COLUMNS FROM `sp_article` [ RunTime:0.001589s ]
SELECT * FROM `sp_article` WHERE `cate_id` = 3 [ RunTime:0.001179s ]
SELECT * FROM `sp_article` WHERE `cate_id` = 4 [ RunTime:0.001210s ]
SELECT * FROM `sp_article` WHERE `cate_id` = 5 [ RunTime:0.001203s ]
SELECT * FROM `sp_article` WHERE `cate_id` = 6 [ RunTime:0.001188s ]
SELECT * FROM `sp_sys_setting` WHERE `type` = 'base' [ RunTime:0.001105s ]
SELECT `id`,`name`,`level` FROM `sp_goods_cate` WHERE `status` = 1 AND `pid` = 0 ORDER BY `id` DESC LIMIT 500 [ RunTime:0.000986s ]
SELECT `id`,`name`,`pid`,`level`,`seo_title`,`seo_desc`,`seo_keywords`,`amount` FROM `sp_goods_cate` WHERE `id` = 59 LIMIT 1 [ RunTime:0.000635s ]
SHOW FULL COLUMNS FROM `sp_goods_cate_relation` [ RunTime:0.000914s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 59 LIMIT 1 [ RunTime:0.003586s ]
SHOW FULL COLUMNS FROM `sp_goods_rule_tpl` [ RunTime:0.000935s ]
SELECT * FROM `sp_goods_rule_tpl` WHERE `cid` = 59 LIMIT 1 [ RunTime:0.000719s ]
SHOW FULL COLUMNS FROM `sp_goods_rule_items` [ RunTime:0.000940s ]
SELECT * FROM `sp_goods_rule_items` WHERE `rule_tpl_id` = 5 ORDER BY `sort_order` ASC,`id` ASC [ RunTime:0.000686s ]
SHOW FULL COLUMNS FROM `sp_goods_rule_values` [ RunTime:0.000841s ]
SELECT * FROM `sp_goods_rule_values` WHERE `rule_item_id` IN (77,78,79,80) ORDER BY `sort_order` ASC,`id` ASC,`sort_order` ASC,`id` ASC [ RunTime:0.000889s ]
SHOW FULL COLUMNS FROM `sp_goods_brands` [ RunTime:0.000967s ]
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`=59 and cate.goods_id = goods.id WHERE `brand`.`status` = '1' GROUP BY `brand`.`id` [ RunTime:0.005471s ]
SELECT `goods_id` FROM `sp_goods_cate_relation` WHERE `cate_id` = 59 [ RunTime:0.003377s ]
SHOW FULL COLUMNS FROM `sp_goods` [ RunTime:0.001511s ]
SELECT `shudi` FROM `sp_goods` WHERE `id` IN (3712,3729,3955,4007,4008,4009,4012,4015,4016,4019,4021,4023,4024,4025,4026,4027,4028,4031,4115,4278,4281,4283,4284,4285,4286,4287,4288,4289,4290,4343,4344,4358,4427,4458,4461,4622,4631,4638,4650,4697,4724,4757,4758,4760,4782,4788,4789,4810,4817,4819,4820,4821,4857,4925,4927,4939,4940,4941,4946,4952,4954,4955,4967,4977,4980,4981,4990,4991,5023,5057,5073,5074,5077,5106,5110,5111,5116,5136,5137,5138,5187,5353,5354,5355,5356,5357,5360,5369,5375,5378,5395,5396,5399,5400,5422,5427,5444,5445,5448,5457,5492,5519,5523,5532,5533,5538,5539,5541,5632,5637,5654,5673,5690,5694,5724,5732,5740,5745,5747,5763,5772,5773,5780,5800,5804,5805,5806,5807,5808,5809,5820,5825,5826,5844,5847,5891,5909,5920,5938,5966,6011,6047,6068,6081,6082,6107,6108,6109,6112,6117,6166,6183,6194,6253,6255,6270,6272,6273,6274,6307,6308,6338,6339,6342,6358,6359,6424,6444,6447,6449,6484,6492,6499,6501,6505,6508,6521,6522,6527,6534,6535,6536,6537,6538,6539,6540,6541,6542,6543,6544,6545,6546,6547,6548,6549,6550,6553,6564,6576,6586,6588,6608,6630,6634,6636,6658,6667,6668,6672,6675,6676,6681,6687,6688,6689,6693,6695,6705,6714,6742,6743,6748,6754,6765,6775,6783,6804,6827,6836,6838,6839,6840,6841,6851,6852,6856,6857,6858,6859,6860,6861,6862,6865,6866,6867,6868,6870,6890,6897,6898,6899,6900,6901,6941,6944,6960,6962,6963,6971,6972,6973,6987,7028,7029,7031,7040,7048,7064,7080,7081,7084,7099,7108,7113,7115,7116,7118,7148,7150,7154,7164,7165,7180,7181,7193,7198,7199,7210,7225,7226,7227,7256,7260,7268,8917,8918,8919,8920,8921,8922,8923,8924,8925,8926,8927,8928,8964,8966,8967,8968,8969,8970,8971,8973,8974,8975,8976,9001,9002,9003,8932,9004,9005,9016,9017,9019,9020,9021,9022,9023,9024,9025,9026,9027,9028,8929,9043,8965,8972,9152,9153,9160,9161,9162,9163,9164,9165,9166,9167,9168,9169,9170,9171,9174,9175,9176,9180,9189,9232,9248,9255,9258,9259,9260,9263,9267,9265,9268,4014,4017) AND `shudi` > 0 GROUP BY `shudi` [ RunTime:0.004753s ]
SELECT `id`,`name` FROM `sp_goods_cate` WHERE `status` = 1 AND `pid` = 59 ORDER BY `sort` ASC LIMIT 500 [ RunTime:0.000858s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 275 LIMIT 1 [ RunTime:0.003035s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 276 LIMIT 1 [ RunTime:0.002930s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 277 LIMIT 1 [ RunTime:0.002771s ]
SELECT COUNT(`id`) AS think_count FROM `sp_goods_cate_relation` WHERE `cate_id` = 256 LIMIT 1 [ RunTime:0.002769s ]
SELECT * FROM `sp_goods_cate_relation` WHERE `cate_id` = 59 ORDER BY `id` DESC LIMIT 500 [ RunTime:0.004082s ]
SELECT COUNT(*) AS think_count FROM `sp_goods` WHERE `id` IN (4017,4014,9268,9265,9267,9263,9260,9259,9258,9255,9248,9232,9189,9180,9176,9175,9174,9171,9170,9169,9168,9167,9166,9165,9164,9163,9162,9161,9160,9153,9152,8972,8965,9043,8929,9028,9027,9026,9025,9024,9023,9022,9021,9020,9019,9017,9016,9005,9004,8932,9003,9002,9001,8976,8975,8974,8973,8971,8970,8969,8968,8967,8966,8964,8928,8927,8926,8925,8924,8923,8922,8921,8920,8919,8918,8917,7268,7260,7256,7227,7226,7225,7210,7199,7198,7193,7181,7180,7165,7164,7154,7150,7148,7118,7116,7115,7113,7108,7099,7084,7081,7080,7064,7048,7040,7031,7029,7028,6987,6973,6972,6971,6963,6962,6960,6944,6941,6901,6900,6899,6898,6897,6890,6870,6868,6867,6866,6865,6862,6861,6860,6859,6858,6857,6856,6852,6851,6841,6840,6839,6838,6836,6827,6804,6783,6775,6765,6754,6748,6743,6742,6714,6705,6695,6693,6689,6688,6687,6681,6676,6675,6672,6668,6667,6658,6636,6634,6630,6608,6588,6586,6576,6564,6553,6550,6549,6548,6547,6546,6545,6544,6543,6542,6541,6540,6539,6538,6537,6536,6535,6534,6527,6522,6521,6508,6505,6501,6499,6492,6484,6449,6447,6444,6424,6359,6358,6342,6339,6338,6308,6307,6274,6273,6272,6270,6255,6253,6194,6183,6166,6117,6112,6109,6108,6107,6082,6081,6068,6047,6011,5966,5938,5920,5909,5891,5847,5844,5826,5825,5820,5809,5808,5807,5806,5805,5804,5800,5780,5773,5772,5763,5747,5745,5740,5732,5724,5694,5690,5673,5654,5637,5632,5541,5539,5538,5533,5532,5523,5519,5492,5457,5448,5445,5444,5427,5422,5400,5399,5396,5395,5378,5375,5369,5360,5357,5356,5355,5354,5353,5187,5138,5137,5136,5116,5111,5110,5106,5077,5074,5073,5057,5023,4991,4990,4981,4980,4977,4967,4955,4954,4952,4946,4941,4940,4939,4927,4925,4857,4821,4820,4819,4817,4810,4789,4788,4782,4760,4758,4757,4724,4697,4650,4638,4631,4622,4461,4458,4427,4358,4344,4343,4290,4289,4288,4287,4286,4285,4284,4283,4281,4278,4115,4031,4028,4027,4026,4025,4024,4023,4021,4019,4016,4015,4012,4009,4008,4007,3955,3729,3712) AND `is_del` = 2 AND `is_show` = 1 AND `is_open` = 0 LIMIT 1 [ RunTime:0.003792s ]
SELECT `id`,`name`,`slider_image`,`sales`,`collects`,`price`,`sku`,`sub_name`,`moq`,`bzs`,`bzdw` FROM `sp_goods` WHERE `id` IN (4017,4014,9268,9265,9267,9263,9260,9259,9258,9255,9248,9232,9189,9180,9176,9175,9174,9171,9170,9169,9168,9167,9166,9165,9164,9163,9162,9161,9160,9153,9152,8972,8965,9043,8929,9028,9027,9026,9025,9024,9023,9022,9021,9020,9019,9017,9016,9005,9004,8932,9003,9002,9001,8976,8975,8974,8973,8971,8970,8969,8968,8967,8966,8964,8928,8927,8926,8925,8924,8923,8922,8921,8920,8919,8918,8917,7268,7260,7256,7227,7226,7225,7210,7199,7198,7193,7181,7180,7165,7164,7154,7150,7148,7118,7116,7115,7113,7108,7099,7084,7081,7080,7064,7048,7040,7031,7029,7028,6987,6973,6972,6971,6963,6962,6960,6944,6941,6901,6900,6899,6898,6897,6890,6870,6868,6867,6866,6865,6862,6861,6860,6859,6858,6857,6856,6852,6851,6841,6840,6839,6838,6836,6827,6804,6783,6775,6765,6754,6748,6743,6742,6714,6705,6695,6693,6689,6688,6687,6681,6676,6675,6672,6668,6667,6658,6636,6634,6630,6608,6588,6586,6576,6564,6553,6550,6549,6548,6547,6546,6545,6544,6543,6542,6541,6540,6539,6538,6537,6536,6535,6534,6527,6522,6521,6508,6505,6501,6499,6492,6484,6449,6447,6444,6424,6359,6358,6342,6339,6338,6308,6307,6274,6273,6272,6270,6255,6253,6194,6183,6166,6117,6112,6109,6108,6107,6082,6081,6068,6047,6011,5966,5938,5920,5909,5891,5847,5844,5826,5825,5820,5809,5808,5807,5806,5805,5804,5800,5780,5773,5772,5763,5747,5745,5740,5732,5724,5694,5690,5673,5654,5637,5632,5541,5539,5538,5533,5532,5523,5519,5492,5457,5448,5445,5444,5427,5422,5400,5399,5396,5395,5378,5375,5369,5360,5357,5356,5355,5354,5353,5187,5138,5137,5136,5116,5111,5110,5106,5077,5074,5073,5057,5023,4991,4990,4981,4980,4977,4967,4955,4954,4952,4946,4941,4940,4939,4927,4925,4857,4821,4820,4819,4817,4810,4789,4788,4782,4760,4758,4757,4724,4697,4650,4638,4631,4622,4461,4458,4427,4358,4344,4343,4290,4289,4288,4287,4286,4285,4284,4283,4281,4278,4115,4031,4028,4027,4026,4025,4024,4023,4021,4019,4016,4015,4012,4009,4008,4007,3955,3729,3712) AND `is_del` = 2 AND `is_show` = 1 AND `is_open` = 0 ORDER BY `id` DESC LIMIT 0,20 [ RunTime:0.003167s ]
SHOW FULL COLUMNS FROM `sp_goods_attr` [ RunTime:0.000811s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000485s ]
SHOW FULL COLUMNS FROM `sp_seller` [ RunTime:0.000982s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000301s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000408s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000297s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000362s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000238s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000300s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000296s ]
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.000239s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000290s ]
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.000285s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000231s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000323s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000232s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000278s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000270s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000305s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000233s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000294s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000231s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000290s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000247s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000307s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000233s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000294s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000258s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000277s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000239s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000280s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000228s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000298s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000230s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000280s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000233s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000288s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000233s ]
SELECT `name`,`value` FROM `sp_goods_attr` WHERE `goods_id` IS NULL ORDER BY `id` ASC LIMIT 500 [ RunTime:0.000296s ]
SELECT `name` FROM `sp_seller` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000232s ]
SELECT * FROM `sp_goods` `goods` INNER JOIN `sp_goods_cate_relation` `cate` ON `cate`.`goods_id`=`goods`.`id` WHERE `cate`.`cate_id` = '59' AND `goods`.`is_recommend` = '1' LIMIT 10 [ RunTime:0.001502s ]
SELECT `id`,`name`,`slider_image`,`price`,`sales`,`sku`,`stock` FROM `sp_goods` WHERE `is_del` = 2 ORDER BY `sales` DESC LIMIT 10 [ RunTime:0.004756s ]
SHOW FULL COLUMNS FROM `sp_purchase` [ RunTime:0.000686s ]
SELECT `id`,`title` FROM `sp_purchase` WHERE `cate_id` LIKE '%|59|%' LIMIT 10 [ RunTime:0.000413s ]
SHOW FULL COLUMNS FROM `sp_supply` [ RunTime:0.000774s ]
SELECT `id`,`title` FROM `sp_supply` WHERE `cate_id` = '59' LIMIT 10 [ RunTime:0.000365s ]