SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.012174s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 964 LIMIT 1 [ RunTime:0.005557s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 957 ORDER BY `sort_order` DESC LIMIT 1 [ RunTime:0.041078s ]
SELECT `id`,`parent_id` FROM `tp_goods_category` [ RunTime:0.009688s ]
SELECT `id` FROM `tp_goods_category` WHERE `parent_id` = 964 [ RunTime:0.003860s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.008272s ]
SELECT `goods_id` FROM `tp_goods` WHERE `is_on_sale` = 1 AND `exchange_integral` = 0 AND `cat_id` = 964 [ RunTime:0.008725s ]
SELECT `zs_price` FROM `tp_goods` WHERE `goods_id` IN (30958,30964,30965,30966,30967,30968,30979,30980,30984,30986,30987,30988,30989,30990,30991,31124,31125,31126,31127,31128,31129,31130,31131,31132,31133,31134,31135,31136,31137,31959,31990,32020,32021,32022,32151,32175,32197,32202,32211,34615,34616,34617,34618,34619,34620,34621,34622,34623,34624,34625,34626,34832,34893,35072,35083,35084,35108,35142,35291,35292,35293,35294,36221,36573,36663,36673,36709,36757,36787,36798,36862,36867,36910,36913,36953,36978,36987,37036,37192,37228,37272,37286,37304,37355,37541,37749,37787,38048,38072,38073,38208,38213,38216,38383,38430,38438,38475,38511,38512,38519,38570,38625,38657,38671,38774,38831,39106,39132,39266,39268,39269,39280,39332,39354,39367,39370,39406,39409,39477,39503,39504,39505,39508,39509,39762,39933,39934,40084,40098,40124,40151,40224,40303,40406,40419,40478,40565,40566,40618,40629,40654,40682,40700,40874,40900,40941,40951,40984,41012,41079,41081,41090,41092,41163,41245,41275,41276,41283,41284,41286,41311,41399,41494,41500,41510,41511,41512,41539,41581,41630,41631,41896,42023,42105,42329,42354,42357,42429,42480,42486,42570,42586,42587,42716,42738,42772,42811,42812,42845,42850,42944,43001,43004,43007,43008,43045,43344,43450,43494,43501,43502,43506,43510,43668,43863,43864,44045,44046,44184,44202,44237,44265,44317,44401,44808,45140,45221,45247,45256,45463,45594,45761,45904,45905,45906,45907,45908,45909,45998,46333,46557,46919,46947,47071,47285,47286,47472,47725,47817,47844,47871,47889,47935,47952,47995,48111,48155,48190,48191,48407,48578,48622,48650,48748,48964,49118,49235,49379,49666,49685,50107,50198,50499,51074,51239,51586,51838,51906,52464,52555,52712,53009,53210,53507,53930,54374,54445,54795,54883,55032,56202,56455,56535,56990,57133,57338,57482,57601,57625,57930,57946,58051,58363,58859,59245,59306,59324,59533,59710,59719,60094,60366,60370,60762,61366,61935,62008,62262,62381,63000,63276,63526,65282,65406,66186,66712,66932,67032,67494,68481,69009) [ RunTime:0.007609s ]
SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` IN (30958,30964,30965,30966,30967,30968,30979,30980,30984,30986,30987,30988,30989,30990,30991,31124,31125,31126,31127,31128,31129,31130,31131,31132,31133,31134,31135,31136,31137,31959,31990,32020,32021,32022,32151,32175,32197,32202,32211,34615,34616,34617,34618,34619,34620,34621,34622,34623,34624,34625,34626,34832,34893,35072,35083,35084,35108,35142,35291,35292,35293,35294,36221,36573,36663,36673,36709,36757,36787,36798,36862,36867,36910,36913,36953,36978,36987,37036,37192,37228,37272,37286,37304,37355,37541,37749,37787,38048,38072,38073,38208,38213,38216,38383,38430,38438,38475,38511,38512,38519,38570,38625,38657,38671,38774,38831,39106,39132,39266,39268,39269,39280,39332,39354,39367,39370,39406,39409,39477,39503,39504,39505,39508,39509,39762,39933,39934,40084,40098,40124,40151,40224,40303,40406,40419,40478,40565,40566,40618,40629,40654,40682,40700,40874,40900,40941,40951,40984,41012,41079,41081,41090,41092,41163,41245,41275,41276,41283,41284,41286,41311,41399,41494,41500,41510,41511,41512,41539,41581,41630,41631,41896,42023,42105,42329,42354,42357,42429,42480,42486,42570,42586,42587,42716,42738,42772,42811,42812,42845,42850,42944,43001,43004,43007,43008,43045,43344,43450,43494,43501,43502,43506,43510,43668,43863,43864,44045,44046,44184,44202,44237,44265,44317,44401,44808,45140,45221,45247,45256,45463,45594,45761,45904,45905,45906,45907,45908,45909,45998,46333,46557,46919,46947,47071,47285,47286,47472,47725,47817,47844,47871,47889,47935,47952,47995,48111,48155,48190,48191,48407,48578,48622,48650,48748,48964,49118,49235,49379,49666,49685,50107,50198,50499,51074,51239,51586,51838,51906,52464,52555,52712,53009,53210,53507,53930,54374,54445,54795,54883,55032,56202,56455,56535,56990,57133,57338,57482,57601,57625,57930,57946,58051,58363,58859,59245,59306,59324,59533,59710,59719,60094,60366,60370,60762,61366,61935,62008,62262,62381,63000,63276,63526,65282,65406,66186,66712,66932,67032,67494,68481,69009) AND `brand_id` > 0 [ RunTime:0.022182s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.008681s ]
SELECT * FROM `tp_brand` WHERE `id` IN (4434,4435,4448,4545,4444,4446,4436,4439,4440,4449,5650,4443,5932,4944,6266,4568,7215,4617,7139,6987,4472,5419) GROUP BY `name` LIMIT 30 [ RunTime:0.008475s ]
select group_concat(`key` separator '_') as `key` from tp_spec_goods_price where goods_id in(30958,30964,30965,30966,30967,30968,30979,30980,30984,30986,30987,30988,30989,30990,30991,31124,31125,31126,31127,31128,31129,31130,31131,31132,31133,31134,31135,31136,31137,31959,31990,32020,32021,32022,32151,32175,32197,32202,32211,34615,34616,34617,34618,34619,34620,34621,34622,34623,34624,34625,34626,34832,34893,35072,35083,35084,35108,35142,35291,35292,35293,35294,36221,36573,36663,36673,36709,36757,36787,36798,36862,36867,36910,36913,36953,36978,36987,37036,37192,37228,37272,37286,37304,37355,37541,37749,37787,38048,38072,38073,38208,38213,38216,38383,38430,38438,38475,38511,38512,38519,38570,38625,38657,38671,38774,38831,39106,39132,39266,39268,39269,39280,39332,39354,39367,39370,39406,39409,39477,39503,39504,39505,39508,39509,39762,39933,39934,40084,40098,40124,40151,40224,40303,40406,40419,40478,40565,40566,40618,40629,40654,40682,40700,40874,40900,40941,40951,40984,41012,41079,41081,41090,41092,41163,41245,41275,41276,41283,41284,41286,41311,41399,41494,41500,41510,41511,41512,41539,41581,41630,41631,41896,42023,42105,42329,42354,42357,42429,42480,42486,42570,42586,42587,42716,42738,42772,42811,42812,42845,42850,42944,43001,43004,43007,43008,43045,43344,43450,43494,43501,43502,43506,43510,43668,43863,43864,44045,44046,44184,44202,44237,44265,44317,44401,44808,45140,45221,45247,45256,45463,45594,45761,45904,45905,45906,45907,45908,45909,45998,46333,46557,46919,46947,47071,47285,47286,47472,47725,47817,47844,47871,47889,47935,47952,47995,48111,48155,48190,48191,48407,48578,48622,48650,48748,48964,49118,49235,49379,49666,49685,50107,50198,50499,51074,51239,51586,51838,51906,52464,52555,52712,53009,53210,53507,53930,54374,54445,54795,54883,55032,56202,56455,56535,56990,57133,57338,57482,57601,57625,57930,57946,58051,58363,58859,59245,59306,59324,59533,59710,59719,60094,60366,60370,60762,61366,61935,62008,62262,62381,63000,63276,63526,65282,65406,66186,66712,66932,67032,67494,68481,69009) [ RunTime:0.006677s ]
SHOW FULL COLUMNS FROM `tp_goods_attr` [ RunTime:0.005972s ]
SELECT * FROM `tp_goods_attr` WHERE `goods_id` IN (30958,30964,30965,30966,30967,30968,30979,30980,30984,30986,30987,30988,30989,30990,30991,31124,31125,31126,31127,31128,31129,31130,31131,31132,31133,31134,31135,31136,31137,31959,31990,32020,32021,32022,32151,32175,32197,32202,32211,34615,34616,34617,34618,34619,34620,34621,34622,34623,34624,34625,34626,34832,34893,35072,35083,35084,35108,35142,35291,35292,35293,35294,36221,36573,36663,36673,36709,36757,36787,36798,36862,36867,36910,36913,36953,36978,36987,37036,37192,37228,37272,37286,37304,37355,37541,37749,37787,38048,38072,38073,38208,38213,38216,38383,38430,38438,38475,38511,38512,38519,38570,38625,38657,38671,38774,38831,39106,39132,39266,39268,39269,39280,39332,39354,39367,39370,39406,39409,39477,39503,39504,39505,39508,39509,39762,39933,39934,40084,40098,40124,40151,40224,40303,40406,40419,40478,40565,40566,40618,40629,40654,40682,40700,40874,40900,40941,40951,40984,41012,41079,41081,41090,41092,41163,41245,41275,41276,41283,41284,41286,41311,41399,41494,41500,41510,41511,41512,41539,41581,41630,41631,41896,42023,42105,42329,42354,42357,42429,42480,42486,42570,42586,42587,42716,42738,42772,42811,42812,42845,42850,42944,43001,43004,43007,43008,43045,43344,43450,43494,43501,43502,43506,43510,43668,43863,43864,44045,44046,44184,44202,44237,44265,44317,44401,44808,45140,45221,45247,45256,45463,45594,45761,45904,45905,45906,45907,45908,45909,45998,46333,46557,46919,46947,47071,47285,47286,47472,47725,47817,47844,47871,47889,47935,47952,47995,48111,48155,48190,48191,48407,48578,48622,48650,48748,48964,49118,49235,49379,49666,49685,50107,50198,50499,51074,51239,51586,51838,51906,52464,52555,52712,53009,53210,53507,53930,54374,54445,54795,54883,55032,56202,56455,56535,56990,57133,57338,57482,57601,57625,57930,57946,58051,58363,58859,59245,59306,59324,59533,59710,59719,60094,60366,60370,60762,61366,61935,62008,62262,62381,63000,63276,63526,65282,65406,66186,66712,66932,67032,67494,68481,69009) AND `attr_value` <> '' [ RunTime:0.034327s ]
SHOW FULL COLUMNS FROM `tp_goods_attribute` [ RunTime:0.006933s ]
SELECT `attr_id`,`attr_id`,`attr_name`,`attr_index` FROM `tp_goods_attribute` WHERE ( attr_index = 1 ) [ RunTime:0.004523s ]
SELECT * FROM `tp_goods` WHERE `goods_id` IN (30958,30964,30965,30966,30967,30968,30979,30980,30984,30986,30987,30988,30989,30990,30991,31124,31125,31126,31127,31128,31129,31130,31131,31132,31133,31134,31135,31136,31137,31959,31990,32020,32021,32022,32151,32175,32197,32202,32211,34615,34616,34617,34618,34619,34620,34621,34622,34623,34624,34625,34626,34832,34893,35072,35083,35084,35108,35142,35291,35292,35293,35294,36221,36573,36663,36673,36709,36757,36787,36798,36862,36867,36910,36913,36953,36978,36987,37036,37192,37228,37272,37286,37304,37355,37541,37749,37787,38048,38072,38073,38208,38213,38216,38383,38430,38438,38475,38511,38512,38519,38570,38625,38657,38671,38774,38831,39106,39132,39266,39268,39269,39280,39332,39354,39367,39370,39406,39409,39477,39503,39504,39505,39508,39509,39762,39933,39934,40084,40098,40124,40151,40224,40303,40406,40419,40478,40565,40566,40618,40629,40654,40682,40700,40874,40900,40941,40951,40984,41012,41079,41081,41090,41092,41163,41245,41275,41276,41283,41284,41286,41311,41399,41494,41500,41510,41511,41512,41539,41581,41630,41631,41896,42023,42105,42329,42354,42357,42429,42480,42486,42570,42586,42587,42716,42738,42772,42811,42812,42845,42850,42944,43001,43004,43007,43008,43045,43344,43450,43494,43501,43502,43506,43510,43668,43863,43864,44045,44046,44184,44202,44237,44265,44317,44401,44808,45140,45221,45247,45256,45463,45594,45761,45904,45905,45906,45907,45908,45909,45998,46333,46557,46919,46947,47071,47285,47286,47472,47725,47817,47844,47871,47889,47935,47952,47995,48111,48155,48190,48191,48407,48578,48622,48650,48748,48964,49118,49235,49379,49666,49685,50107,50198,50499,51074,51239,51586,51838,51906,52464,52555,52712,53009,53210,53507,53930,54374,54445,54795,54883,55032,56202,56455,56535,56990,57133,57338,57482,57601,57625,57930,57946,58051,58363,58859,59245,59306,59324,59533,59710,59719,60094,60366,60370,60762,61366,61935,62008,62262,62381,63000,63276,63526,65282,65406,66186,66712,66932,67032,67494,68481,69009) ORDER BY `sort` ASC LIMIT 0,10 [ RunTime:0.007585s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.005343s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (30958,30964,30965,30966,30967,30968,30979,30980,30984,30986) [ RunTime:0.012843s ]
SHOW FULL COLUMNS FROM `tp_goods_label` [ RunTime:0.007836s ]
SELECT `label_id`,`label_name` FROM `tp_goods_label` [ RunTime:0.004650s ]
SELECT `id`,`id`,`name`,`parent_id`,`level` FROM `tp_goods_category` WHERE ( is_show=1 ) [ RunTime:0.005648s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30958 LIMIT 1 [ RunTime:0.004780s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30964 LIMIT 1 [ RunTime:0.009837s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30965 LIMIT 1 [ RunTime:0.009399s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30966 LIMIT 1 [ RunTime:0.006475s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30967 LIMIT 1 [ RunTime:0.007981s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30968 LIMIT 1 [ RunTime:0.009422s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30979 LIMIT 1 [ RunTime:0.005540s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30980 LIMIT 1 [ RunTime:0.007248s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30984 LIMIT 1 [ RunTime:0.009636s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30986 LIMIT 1 [ RunTime:0.005115s ]
