SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.000444s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 969 LIMIT 1 [ RunTime:0.000203s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 958 ORDER BY `sort_order` DESC LIMIT 1 [ RunTime:0.000215s ]
SELECT `id`,`parent_id` FROM `tp_goods_category` [ RunTime:0.000503s ]
SELECT `id` FROM `tp_goods_category` WHERE `parent_id` = 969 [ RunTime:0.000206s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.000644s ]
SELECT `goods_id` FROM `tp_goods` WHERE `is_on_sale` = 1 AND `exchange_integral` = 0 AND `cat_id` = 969 [ RunTime:0.001094s ]
SELECT `zs_price` FROM `tp_goods` WHERE `goods_id` IN (32750,32752,32771,32774,32777,32779,32780,32783,32785,32788,32791,32793,32795,32804,32807,32812,32815,32816,32818,32819,32822,32823,32824,32825,32827,32829,32830,32832,32835,32838,32839,32841,32844,32848,32856,32865,32867,32870,32872,32873,32884,32886,32888,32892,32893,32896,32899,32901,32902,32904,32905,32906,34119,34120,34121,34122,34123,34124,34125,34128,34129,34130,34131,34132,35125,35128,35140,35141,35144,35205,36075,36213,36303,36304,36305,36472,36473,36474,36488,36489,36600,36601,36613,36615,36616,36652,36692,36963,37344,37345,37364,37432,37602,37671,37806,37808,38054,38091,38156,38379,38665,38775,38849,38860,38862,38866,38922,38983,39033,39039,39040,39133,39452,39453,39467,39567,39586,39587,39977,39979,39982,40045,40078,40079,40080,40157,40189,40306,40387,40686,40736,40958,40959,40961,40963,41050,41051,41052,41078,41097,41279,41280,41584,41638,41757,41777,42092,42649,42650,42837,43130,43308,43363,43567,43588,43597,43639,43675,43882,43883,43890,44031,44113,44116,44229,44278,44304,44341,44576,44577,44735,45217,45222,45287,45294,45407,45429,45498,45500,45522,45656,45657,45670,45671,46076,46537,46553,46634,46815,46835,46836,46843,46905,46969,47038,47039,47251,47309,47390,47391,47423,47548,47604,47612,47630,47633,47690,47693,47766,47840,47909,47916,48167,48210,48222,48362,48363,48668,48869,48870,48880,48890,49119,49242,49270,49452,49473,49476,49477,49819,49854,50457,51062,51086,51126,51127,51466,51484,51485,51660,51668,52025,52026,52031,52513,52598,52708,52776,53071,53207,53219,53427,53451,53841,53857,53942,54216,54256,54397,54398,54447,54531,54721,54826,54840,55067,55068,55070,55560,55804,55805,55962,55963,55964,56027,56065,56066,56139,56222,56350,56358,56428,56550,56745,56747,57089,57118,57599,57638,57663,57705,57804,57812,57817,57818,57819,57888,57891,57957,57999,58013,58108,58283,58284,58285,58298,58299,58302,58424,58435,58631,58787,58855,59232,59276,59343,59418,59748,59820,59825,59885,59929,60054,60196,60228,60509,60547,60765,60766,61522,61525,61989,62010,62015,62016,62018,62019,62115,62134,62154,62239,62354,62421,62544,62618,62731,62732,62779,63108,63126,63127,63128,63129,63130,63264,63265,63266,63297,63310,63517,63820,63912,64097,64261,64342,64445,64609,64649,64654,64712,64824,65106,65110,65111,65531,65637,65830,65870,65980,66144,66145,66179,66259,66395,66399,66400,66764,67110,67358,67431,67485,67769,68022,68269,68344,68592,68623,68727,68732,68901,68902,68903,69083,69506,69507,69611) [ RunTime:0.002551s ]
SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` IN (32750,32752,32771,32774,32777,32779,32780,32783,32785,32788,32791,32793,32795,32804,32807,32812,32815,32816,32818,32819,32822,32823,32824,32825,32827,32829,32830,32832,32835,32838,32839,32841,32844,32848,32856,32865,32867,32870,32872,32873,32884,32886,32888,32892,32893,32896,32899,32901,32902,32904,32905,32906,34119,34120,34121,34122,34123,34124,34125,34128,34129,34130,34131,34132,35125,35128,35140,35141,35144,35205,36075,36213,36303,36304,36305,36472,36473,36474,36488,36489,36600,36601,36613,36615,36616,36652,36692,36963,37344,37345,37364,37432,37602,37671,37806,37808,38054,38091,38156,38379,38665,38775,38849,38860,38862,38866,38922,38983,39033,39039,39040,39133,39452,39453,39467,39567,39586,39587,39977,39979,39982,40045,40078,40079,40080,40157,40189,40306,40387,40686,40736,40958,40959,40961,40963,41050,41051,41052,41078,41097,41279,41280,41584,41638,41757,41777,42092,42649,42650,42837,43130,43308,43363,43567,43588,43597,43639,43675,43882,43883,43890,44031,44113,44116,44229,44278,44304,44341,44576,44577,44735,45217,45222,45287,45294,45407,45429,45498,45500,45522,45656,45657,45670,45671,46076,46537,46553,46634,46815,46835,46836,46843,46905,46969,47038,47039,47251,47309,47390,47391,47423,47548,47604,47612,47630,47633,47690,47693,47766,47840,47909,47916,48167,48210,48222,48362,48363,48668,48869,48870,48880,48890,49119,49242,49270,49452,49473,49476,49477,49819,49854,50457,51062,51086,51126,51127,51466,51484,51485,51660,51668,52025,52026,52031,52513,52598,52708,52776,53071,53207,53219,53427,53451,53841,53857,53942,54216,54256,54397,54398,54447,54531,54721,54826,54840,55067,55068,55070,55560,55804,55805,55962,55963,55964,56027,56065,56066,56139,56222,56350,56358,56428,56550,56745,56747,57089,57118,57599,57638,57663,57705,57804,57812,57817,57818,57819,57888,57891,57957,57999,58013,58108,58283,58284,58285,58298,58299,58302,58424,58435,58631,58787,58855,59232,59276,59343,59418,59748,59820,59825,59885,59929,60054,60196,60228,60509,60547,60765,60766,61522,61525,61989,62010,62015,62016,62018,62019,62115,62134,62154,62239,62354,62421,62544,62618,62731,62732,62779,63108,63126,63127,63128,63129,63130,63264,63265,63266,63297,63310,63517,63820,63912,64097,64261,64342,64445,64609,64649,64654,64712,64824,65106,65110,65111,65531,65637,65830,65870,65980,66144,66145,66179,66259,66395,66399,66400,66764,67110,67358,67431,67485,67769,68022,68269,68344,68592,68623,68727,68732,68901,68902,68903,69083,69506,69507,69611) AND `brand_id` > 0 [ RunTime:0.002560s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.000484s ]
SELECT * FROM `tp_brand` WHERE `id` IN (4541,4517,4536,4840,4534,4532,5029,4435,4479,5033,4535,5602,5763,4911,6807,6699,6634,7737,6661,5057,7139,6274,7860,6054) GROUP BY `name` LIMIT 30 [ RunTime:0.000941s ]
select group_concat(`key` separator '_') as `key` from tp_spec_goods_price where goods_id in(32750,32752,32771,32774,32777,32779,32780,32783,32785,32788,32791,32793,32795,32804,32807,32812,32815,32816,32818,32819,32822,32823,32824,32825,32827,32829,32830,32832,32835,32838,32839,32841,32844,32848,32856,32865,32867,32870,32872,32873,32884,32886,32888,32892,32893,32896,32899,32901,32902,32904,32905,32906,34119,34120,34121,34122,34123,34124,34125,34128,34129,34130,34131,34132,35125,35128,35140,35141,35144,35205,36075,36213,36303,36304,36305,36472,36473,36474,36488,36489,36600,36601,36613,36615,36616,36652,36692,36963,37344,37345,37364,37432,37602,37671,37806,37808,38054,38091,38156,38379,38665,38775,38849,38860,38862,38866,38922,38983,39033,39039,39040,39133,39452,39453,39467,39567,39586,39587,39977,39979,39982,40045,40078,40079,40080,40157,40189,40306,40387,40686,40736,40958,40959,40961,40963,41050,41051,41052,41078,41097,41279,41280,41584,41638,41757,41777,42092,42649,42650,42837,43130,43308,43363,43567,43588,43597,43639,43675,43882,43883,43890,44031,44113,44116,44229,44278,44304,44341,44576,44577,44735,45217,45222,45287,45294,45407,45429,45498,45500,45522,45656,45657,45670,45671,46076,46537,46553,46634,46815,46835,46836,46843,46905,46969,47038,47039,47251,47309,47390,47391,47423,47548,47604,47612,47630,47633,47690,47693,47766,47840,47909,47916,48167,48210,48222,48362,48363,48668,48869,48870,48880,48890,49119,49242,49270,49452,49473,49476,49477,49819,49854,50457,51062,51086,51126,51127,51466,51484,51485,51660,51668,52025,52026,52031,52513,52598,52708,52776,53071,53207,53219,53427,53451,53841,53857,53942,54216,54256,54397,54398,54447,54531,54721,54826,54840,55067,55068,55070,55560,55804,55805,55962,55963,55964,56027,56065,56066,56139,56222,56350,56358,56428,56550,56745,56747,57089,57118,57599,57638,57663,57705,57804,57812,57817,57818,57819,57888,57891,57957,57999,58013,58108,58283,58284,58285,58298,58299,58302,58424,58435,58631,58787,58855,59232,59276,59343,59418,59748,59820,59825,59885,59929,60054,60196,60228,60509,60547,60765,60766,61522,61525,61989,62010,62015,62016,62018,62019,62115,62134,62154,62239,62354,62421,62544,62618,62731,62732,62779,63108,63126,63127,63128,63129,63130,63264,63265,63266,63297,63310,63517,63820,63912,64097,64261,64342,64445,64609,64649,64654,64712,64824,65106,65110,65111,65531,65637,65830,65870,65980,66144,66145,66179,66259,66395,66399,66400,66764,67110,67358,67431,67485,67769,68022,68269,68344,68592,68623,68727,68732,68901,68902,68903,69083,69506,69507,69611) [ RunTime:0.000658s ]
SHOW FULL COLUMNS FROM `tp_goods_attr` [ RunTime:0.000408s ]
SELECT * FROM `tp_goods_attr` WHERE `goods_id` IN (32750,32752,32771,32774,32777,32779,32780,32783,32785,32788,32791,32793,32795,32804,32807,32812,32815,32816,32818,32819,32822,32823,32824,32825,32827,32829,32830,32832,32835,32838,32839,32841,32844,32848,32856,32865,32867,32870,32872,32873,32884,32886,32888,32892,32893,32896,32899,32901,32902,32904,32905,32906,34119,34120,34121,34122,34123,34124,34125,34128,34129,34130,34131,34132,35125,35128,35140,35141,35144,35205,36075,36213,36303,36304,36305,36472,36473,36474,36488,36489,36600,36601,36613,36615,36616,36652,36692,36963,37344,37345,37364,37432,37602,37671,37806,37808,38054,38091,38156,38379,38665,38775,38849,38860,38862,38866,38922,38983,39033,39039,39040,39133,39452,39453,39467,39567,39586,39587,39977,39979,39982,40045,40078,40079,40080,40157,40189,40306,40387,40686,40736,40958,40959,40961,40963,41050,41051,41052,41078,41097,41279,41280,41584,41638,41757,41777,42092,42649,42650,42837,43130,43308,43363,43567,43588,43597,43639,43675,43882,43883,43890,44031,44113,44116,44229,44278,44304,44341,44576,44577,44735,45217,45222,45287,45294,45407,45429,45498,45500,45522,45656,45657,45670,45671,46076,46537,46553,46634,46815,46835,46836,46843,46905,46969,47038,47039,47251,47309,47390,47391,47423,47548,47604,47612,47630,47633,47690,47693,47766,47840,47909,47916,48167,48210,48222,48362,48363,48668,48869,48870,48880,48890,49119,49242,49270,49452,49473,49476,49477,49819,49854,50457,51062,51086,51126,51127,51466,51484,51485,51660,51668,52025,52026,52031,52513,52598,52708,52776,53071,53207,53219,53427,53451,53841,53857,53942,54216,54256,54397,54398,54447,54531,54721,54826,54840,55067,55068,55070,55560,55804,55805,55962,55963,55964,56027,56065,56066,56139,56222,56350,56358,56428,56550,56745,56747,57089,57118,57599,57638,57663,57705,57804,57812,57817,57818,57819,57888,57891,57957,57999,58013,58108,58283,58284,58285,58298,58299,58302,58424,58435,58631,58787,58855,59232,59276,59343,59418,59748,59820,59825,59885,59929,60054,60196,60228,60509,60547,60765,60766,61522,61525,61989,62010,62015,62016,62018,62019,62115,62134,62154,62239,62354,62421,62544,62618,62731,62732,62779,63108,63126,63127,63128,63129,63130,63264,63265,63266,63297,63310,63517,63820,63912,64097,64261,64342,64445,64609,64649,64654,64712,64824,65106,65110,65111,65531,65637,65830,65870,65980,66144,66145,66179,66259,66395,66399,66400,66764,67110,67358,67431,67485,67769,68022,68269,68344,68592,68623,68727,68732,68901,68902,68903,69083,69506,69507,69611) AND `attr_value` <> '' [ RunTime:0.004287s ]
SHOW FULL COLUMNS FROM `tp_goods_attribute` [ RunTime:0.000449s ]
SELECT `attr_id`,`attr_id`,`attr_name`,`attr_index` FROM `tp_goods_attribute` WHERE ( attr_index = 1 ) [ RunTime:0.000177s ]
SELECT * FROM `tp_goods` WHERE `goods_id` IN (32750,32752,32771,32774,32777,32779,32780,32783,32785,32788,32791,32793,32795,32804,32807,32812,32815,32816,32818,32819,32822,32823,32824,32825,32827,32829,32830,32832,32835,32838,32839,32841,32844,32848,32856,32865,32867,32870,32872,32873,32884,32886,32888,32892,32893,32896,32899,32901,32902,32904,32905,32906,34119,34120,34121,34122,34123,34124,34125,34128,34129,34130,34131,34132,35125,35128,35140,35141,35144,35205,36075,36213,36303,36304,36305,36472,36473,36474,36488,36489,36600,36601,36613,36615,36616,36652,36692,36963,37344,37345,37364,37432,37602,37671,37806,37808,38054,38091,38156,38379,38665,38775,38849,38860,38862,38866,38922,38983,39033,39039,39040,39133,39452,39453,39467,39567,39586,39587,39977,39979,39982,40045,40078,40079,40080,40157,40189,40306,40387,40686,40736,40958,40959,40961,40963,41050,41051,41052,41078,41097,41279,41280,41584,41638,41757,41777,42092,42649,42650,42837,43130,43308,43363,43567,43588,43597,43639,43675,43882,43883,43890,44031,44113,44116,44229,44278,44304,44341,44576,44577,44735,45217,45222,45287,45294,45407,45429,45498,45500,45522,45656,45657,45670,45671,46076,46537,46553,46634,46815,46835,46836,46843,46905,46969,47038,47039,47251,47309,47390,47391,47423,47548,47604,47612,47630,47633,47690,47693,47766,47840,47909,47916,48167,48210,48222,48362,48363,48668,48869,48870,48880,48890,49119,49242,49270,49452,49473,49476,49477,49819,49854,50457,51062,51086,51126,51127,51466,51484,51485,51660,51668,52025,52026,52031,52513,52598,52708,52776,53071,53207,53219,53427,53451,53841,53857,53942,54216,54256,54397,54398,54447,54531,54721,54826,54840,55067,55068,55070,55560,55804,55805,55962,55963,55964,56027,56065,56066,56139,56222,56350,56358,56428,56550,56745,56747,57089,57118,57599,57638,57663,57705,57804,57812,57817,57818,57819,57888,57891,57957,57999,58013,58108,58283,58284,58285,58298,58299,58302,58424,58435,58631,58787,58855,59232,59276,59343,59418,59748,59820,59825,59885,59929,60054,60196,60228,60509,60547,60765,60766,61522,61525,61989,62010,62015,62016,62018,62019,62115,62134,62154,62239,62354,62421,62544,62618,62731,62732,62779,63108,63126,63127,63128,63129,63130,63264,63265,63266,63297,63310,63517,63820,63912,64097,64261,64342,64445,64609,64649,64654,64712,64824,65106,65110,65111,65531,65637,65830,65870,65980,66144,66145,66179,66259,66395,66399,66400,66764,67110,67358,67431,67485,67769,68022,68269,68344,68592,68623,68727,68732,68901,68902,68903,69083,69506,69507,69611) ORDER BY `sort` ASC LIMIT 0,10 [ RunTime:0.005292s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.000437s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (32750,32752,32771,32774,32777,32779,32780,32783,32785,32788) [ RunTime:0.000529s ]
SHOW FULL COLUMNS FROM `tp_goods_label` [ RunTime:0.000402s ]
SELECT `label_id`,`label_name` FROM `tp_goods_label` [ RunTime:0.000134s ]
SELECT `id`,`id`,`name`,`parent_id`,`level` FROM `tp_goods_category` WHERE ( is_show=1 ) [ RunTime:0.000235s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32750 LIMIT 1 [ RunTime:0.000242s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32752 LIMIT 1 [ RunTime:0.000244s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32771 LIMIT 1 [ RunTime:0.000281s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32774 LIMIT 1 [ RunTime:0.000628s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32777 LIMIT 1 [ RunTime:0.000253s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32779 LIMIT 1 [ RunTime:0.000205s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32780 LIMIT 1 [ RunTime:0.000212s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32783 LIMIT 1 [ RunTime:0.000220s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32785 LIMIT 1 [ RunTime:0.000212s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32788 LIMIT 1 [ RunTime:0.000224s ]
