SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.001084s ]
SELECT `goods_id` FROM `tp_goods` WHERE `is_on_sale` = 1 AND `goods_name` LIKE '%华为%' [ RunTime:0.051428s ]
SELECT `zs_price` FROM `tp_goods` WHERE `goods_id` IN (30959,30960,30961,30962,30963,30964,30965,30966,30967,30968,30972,30973,30974,30976,30978,30979,30980,30981,30982,30983,30984,30985,30986,30987,30988,30989,30990,30991,30992,30993,30994,30995,30996,30997,31271,31959,32039,32040,32079,32226,32389,32391,32393,32394,32427,32440,32442,32718,32830,32832,32856,32865,32867,32872,32873,32884,32886,32888,33209,33215,33592,33593,33594,33595,33596,33597,33614,33617,33620,33621,33628,33631,33632,33633,33634,33635,33636,33640,33645,33648,33650,33653,33659,33661,33668,33669,33670,33671,33672,33673,33674,33675,33676,33677,33678,33682,33683,33722,33723,33735,33742,33801,33802,33803,33861,33863,33864,33869,34119,34120,34121,34122,34123,34124,34125,34132,34216,34240,34242,34244,34246,34248,34249,34250,34251,34281,34282,34283,34288,34893,35072,35108,35142,35177,35187,35194,35195,35234,35248,35250,35251,35252,35253,35276,35280,35503,35511,35543,35550,35552,35553,35588,35691,35694,36154,36613,36782,36787,36867,36913,36963,37036,37186,37196,37228,37294,37295,37784,37785,37786,37787,38046,38054,38204,38205,38216,38261,38626,38657,38806,38860,39038,39122,39241,39269,39367,39371,39387,39406,39423,39463,39478,39566,39595,39729,39984,39987,40043,40044,40045,40058,40059,40063,40064,40065,40329,40365,40373,40374,40387,40478,40540,40680,40686,40698,40707,40715,40856,40958,40959,40961,40982,40984,40985,41035,41056,41092,41269,41270,41286,41511,41547,41548,41584,41718,41749,41896,42023,42025,42113,42197,42329,42489,42585,42586,42716,42812,42944,42954,42989,43007,43122,43283,43765,43766,43864,44046,44174,44182,44369,44378,44383,44394,44405,44407,44519,44742,44970,45212,45453,45463,45509,45591,45623,45710,46336,46376,46403,46405,46447,46528,46938,46946,46947,47047,47069,47071,47072,47073,47106,47107,47472,47835,47889,47916,47934,47952,48111,48188,48206,48417,48507,48650,48827,48901,48930,48964,49118,49168,49235,49288,49289,49290,49379,49382,49598,49608,49665,49666,49682,49749,49750,49774,50230,50429,50513,50514,50559,50750,50850,50898,51127,51131,51162,51182,51479,51480,51482,51515,51838,51906,51946,51948,51949,52031,52301,52509,52555,52670,53046,53341,53427,53428,53488,53573,53764,53942,53968,53978,54265,54393,54457,54514,54521,54536,54711,54781,54881,54883,54891,54962,55191,55200,55411,55498,55523,55549,55592,55685,55736,55962,55964,56164,56188,56203,56210,56215,56222,56298,56314,56455,56521,56656,56657,56658,56746,56747,56748,56835,56954,56989,56990,57133,57222,57564,57625,57663,57706,58052,58187,58243,58478,58695,58859,59012,59028,59128,59130,59131,59132,59176,59491,59719,59748,59797,60153,60366,60369,60445,60889,61206,61985,62381,62509,62618,62631,62731,62732,62733,63000,63093,63126,63127,63128,63129,63130,63413,63415,63416,63662,63743,63744,63745,63746,63747,63749,63792,63914,63942,64101,64132,64137,64164,64247,64824,65068,65221,65249,65267,65272,65275,65282,65374,65411,65850,65857,65859,65861,66007,66032,66186,66259,66330,66389,66712,66713,66895,66932,67032,67119,67317,67453,67937,67947,68120,68141,68269,68481,68525,68542,68671,68826,68891,68906,68935,69072,69085,69231) [ RunTime:0.004517s ]
SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` IN (30959,30960,30961,30962,30963,30964,30965,30966,30967,30968,30972,30973,30974,30976,30978,30979,30980,30981,30982,30983,30984,30985,30986,30987,30988,30989,30990,30991,30992,30993,30994,30995,30996,30997,31271,31959,32039,32040,32079,32226,32389,32391,32393,32394,32427,32440,32442,32718,32830,32832,32856,32865,32867,32872,32873,32884,32886,32888,33209,33215,33592,33593,33594,33595,33596,33597,33614,33617,33620,33621,33628,33631,33632,33633,33634,33635,33636,33640,33645,33648,33650,33653,33659,33661,33668,33669,33670,33671,33672,33673,33674,33675,33676,33677,33678,33682,33683,33722,33723,33735,33742,33801,33802,33803,33861,33863,33864,33869,34119,34120,34121,34122,34123,34124,34125,34132,34216,34240,34242,34244,34246,34248,34249,34250,34251,34281,34282,34283,34288,34893,35072,35108,35142,35177,35187,35194,35195,35234,35248,35250,35251,35252,35253,35276,35280,35503,35511,35543,35550,35552,35553,35588,35691,35694,36154,36613,36782,36787,36867,36913,36963,37036,37186,37196,37228,37294,37295,37784,37785,37786,37787,38046,38054,38204,38205,38216,38261,38626,38657,38806,38860,39038,39122,39241,39269,39367,39371,39387,39406,39423,39463,39478,39566,39595,39729,39984,39987,40043,40044,40045,40058,40059,40063,40064,40065,40329,40365,40373,40374,40387,40478,40540,40680,40686,40698,40707,40715,40856,40958,40959,40961,40982,40984,40985,41035,41056,41092,41269,41270,41286,41511,41547,41548,41584,41718,41749,41896,42023,42025,42113,42197,42329,42489,42585,42586,42716,42812,42944,42954,42989,43007,43122,43283,43765,43766,43864,44046,44174,44182,44369,44378,44383,44394,44405,44407,44519,44742,44970,45212,45453,45463,45509,45591,45623,45710,46336,46376,46403,46405,46447,46528,46938,46946,46947,47047,47069,47071,47072,47073,47106,47107,47472,47835,47889,47916,47934,47952,48111,48188,48206,48417,48507,48650,48827,48901,48930,48964,49118,49168,49235,49288,49289,49290,49379,49382,49598,49608,49665,49666,49682,49749,49750,49774,50230,50429,50513,50514,50559,50750,50850,50898,51127,51131,51162,51182,51479,51480,51482,51515,51838,51906,51946,51948,51949,52031,52301,52509,52555,52670,53046,53341,53427,53428,53488,53573,53764,53942,53968,53978,54265,54393,54457,54514,54521,54536,54711,54781,54881,54883,54891,54962,55191,55200,55411,55498,55523,55549,55592,55685,55736,55962,55964,56164,56188,56203,56210,56215,56222,56298,56314,56455,56521,56656,56657,56658,56746,56747,56748,56835,56954,56989,56990,57133,57222,57564,57625,57663,57706,58052,58187,58243,58478,58695,58859,59012,59028,59128,59130,59131,59132,59176,59491,59719,59748,59797,60153,60366,60369,60445,60889,61206,61985,62381,62509,62618,62631,62731,62732,62733,63000,63093,63126,63127,63128,63129,63130,63413,63415,63416,63662,63743,63744,63745,63746,63747,63749,63792,63914,63942,64101,64132,64137,64164,64247,64824,65068,65221,65249,65267,65272,65275,65282,65374,65411,65850,65857,65859,65861,66007,66032,66186,66259,66330,66389,66712,66713,66895,66932,67032,67119,67317,67453,67937,67947,68120,68141,68269,68481,68525,68542,68671,68826,68891,68906,68935,69072,69085,69231) AND `brand_id` > 0 [ RunTime:0.003410s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.000542s ]
SELECT * FROM `tp_brand` WHERE `id` IN (4435,4460,4502,4545,5035,4792,4455,4845,4847,4870,5029,4461,4976,5080,4454,5127,5107,5120,5025,4495,4894,4815,5580,6518,5416,6213,6218,4576,6750,4560,7139,4490,4478,4591,4513,4841,6732,7036,4788,4505,5660,4900,5057,4510,7213,7044,5455,5771,8054,7895,4787,7027) GROUP BY `name` LIMIT 30 [ RunTime:0.002584s ]
SELECT `goods_id`,`goods_name`,`sales_sum`,`virtual_sales_sum`,`shop_price`,`bespeak_template_id`,`label_id` FROM `tp_goods` WHERE `goods_id` IN (30959,30960,30961,30962,30963,30964,30965,30966,30967,30968,30972,30973,30974,30976,30978,30979,30980,30981,30982,30983,30984,30985,30986,30987,30988,30989,30990,30991,30992,30993,30994,30995,30996,30997,31271,31959,32039,32040,32079,32226,32389,32391,32393,32394,32427,32440,32442,32718,32830,32832,32856,32865,32867,32872,32873,32884,32886,32888,33209,33215,33592,33593,33594,33595,33596,33597,33614,33617,33620,33621,33628,33631,33632,33633,33634,33635,33636,33640,33645,33648,33650,33653,33659,33661,33668,33669,33670,33671,33672,33673,33674,33675,33676,33677,33678,33682,33683,33722,33723,33735,33742,33801,33802,33803,33861,33863,33864,33869,34119,34120,34121,34122,34123,34124,34125,34132,34216,34240,34242,34244,34246,34248,34249,34250,34251,34281,34282,34283,34288,34893,35072,35108,35142,35177,35187,35194,35195,35234,35248,35250,35251,35252,35253,35276,35280,35503,35511,35543,35550,35552,35553,35588,35691,35694,36154,36613,36782,36787,36867,36913,36963,37036,37186,37196,37228,37294,37295,37784,37785,37786,37787,38046,38054,38204,38205,38216,38261,38626,38657,38806,38860,39038,39122,39241,39269,39367,39371,39387,39406,39423,39463,39478,39566,39595,39729,39984,39987,40043,40044,40045,40058,40059,40063,40064,40065,40329,40365,40373,40374,40387,40478,40540,40680,40686,40698,40707,40715,40856,40958,40959,40961,40982,40984,40985,41035,41056,41092,41269,41270,41286,41511,41547,41548,41584,41718,41749,41896,42023,42025,42113,42197,42329,42489,42585,42586,42716,42812,42944,42954,42989,43007,43122,43283,43765,43766,43864,44046,44174,44182,44369,44378,44383,44394,44405,44407,44519,44742,44970,45212,45453,45463,45509,45591,45623,45710,46336,46376,46403,46405,46447,46528,46938,46946,46947,47047,47069,47071,47072,47073,47106,47107,47472,47835,47889,47916,47934,47952,48111,48188,48206,48417,48507,48650,48827,48901,48930,48964,49118,49168,49235,49288,49289,49290,49379,49382,49598,49608,49665,49666,49682,49749,49750,49774,50230,50429,50513,50514,50559,50750,50850,50898,51127,51131,51162,51182,51479,51480,51482,51515,51838,51906,51946,51948,51949,52031,52301,52509,52555,52670,53046,53341,53427,53428,53488,53573,53764,53942,53968,53978,54265,54393,54457,54514,54521,54536,54711,54781,54881,54883,54891,54962,55191,55200,55411,55498,55523,55549,55592,55685,55736,55962,55964,56164,56188,56203,56210,56215,56222,56298,56314,56455,56521,56656,56657,56658,56746,56747,56748,56835,56954,56989,56990,57133,57222,57564,57625,57663,57706,58052,58187,58243,58478,58695,58859,59012,59028,59128,59130,59131,59132,59176,59491,59719,59748,59797,60153,60366,60369,60445,60889,61206,61985,62381,62509,62618,62631,62731,62732,62733,63000,63093,63126,63127,63128,63129,63130,63413,63415,63416,63662,63743,63744,63745,63746,63747,63749,63792,63914,63942,64101,64132,64137,64164,64247,64824,65068,65221,65249,65267,65272,65275,65282,65374,65411,65850,65857,65859,65861,66007,66032,66186,66259,66330,66389,66712,66713,66895,66932,67032,67119,67317,67453,67937,67947,68120,68141,68269,68481,68525,68542,68671,68826,68891,68906,68935,69072,69085,69231) ORDER BY `sort` DESC LIMIT 0,12 [ RunTime:0.004492s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.000539s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (69231,69085,69072,68935,68906,68891,68826,68671,68542,68525,68481,68269) [ RunTime:0.007202s ]
SHOW FULL COLUMNS FROM `tp_goods_label` [ RunTime:0.000555s ]
SELECT `label_id`,`label_name` FROM `tp_goods_label` [ RunTime:0.000143s ]
SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.000456s ]
SELECT `id`,`id`,`name`,`parent_id`,`level` FROM `tp_goods_category` WHERE ( is_show=1 ) [ RunTime:0.000334s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 69231 LIMIT 1 [ RunTime:0.000254s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 69085 LIMIT 1 [ RunTime:0.000237s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 69072 LIMIT 1 [ RunTime:0.000250s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 68935 LIMIT 1 [ RunTime:0.001056s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 68906 LIMIT 1 [ RunTime:0.000336s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 68891 LIMIT 1 [ RunTime:0.000307s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 68826 LIMIT 1 [ RunTime:0.001469s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 68671 LIMIT 1 [ RunTime:0.000400s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 68542 LIMIT 1 [ RunTime:0.000225s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 68525 LIMIT 1 [ RunTime:0.000249s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 68481 LIMIT 1 [ RunTime:0.000214s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 68269 LIMIT 1 [ RunTime:0.000246s ]
