SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.001032s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 957 LIMIT 1 [ RunTime:0.000871s ]
SELECT `id`,`parent_id` FROM `tp_goods_category` [ RunTime:0.000609s ]
SELECT `id` FROM `tp_goods_category` WHERE `parent_id` = 957 [ RunTime:0.000263s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.001036s ]
SELECT `goods_id` FROM `tp_goods` WHERE `is_on_sale` = 1 AND `exchange_integral` = 0 AND `cat_id` IN (957,963,964,965,966,967) [ RunTime:0.003798s ]
SELECT `zs_price` FROM `tp_goods` WHERE `goods_id` IN (30959,30960,30961,30985,30992,30993,30994,30995,30996,30997,31939,31961,31989,33537,33540,33543,33560,33570,33588,34126,34127,34570,34571,34584,34608,34627,34628,34629,34630,34631,34632,34633,34634,34635,34637,34641,34642,34643,34644,34645,34646,34647,34648,34727,34728,34831,34866,34870,34889,34890,34891,34907,34908,34936,35079,35081,35082,35110,35236,35326,35611,36028,36066,36117,36148,36154,36284,36313,36666,36670,36674,36700,36758,36765,36788,36797,36844,36869,36912,36960,36983,37037,37060,37096,37135,37216,37219,37239,37270,37271,37293,37341,37410,37450,37453,37492,37531,37532,37533,37534,37535,37536,37538,37551,37554,37555,37572,37573,37575,37577,37579,37581,37604,37674,37676,37721,37748,37768,37776,37780,37786,37794,37831,38049,38126,38178,38202,38203,38204,38205,38206,38207,38217,38239,38240,38241,38243,38246,38294,38295,38334,38381,38389,38390,38404,38517,38616,38627,38631,38632,38770,38773,38788,38793,38796,38828,38896,38926,39048,39100,39101,39116,39153,39209,39245,39369,39371,39393,39426,39432,39438,39445,39483,39484,39550,39592,39594,39744,39771,39861,39993,40058,40091,40095,40099,40100,40101,40102,40108,40119,40120,40122,40165,40185,40222,40231,40234,40325,40353,40360,40373,40374,40391,40405,40407,40425,40426,40438,40525,40556,40597,40598,40635,40647,40655,40680,40701,40706,40707,40713,40716,40873,40892,40918,40979,40981,40994,41035,41062,41066,41099,41109,41162,41230,41231,41253,41254,41381,41502,41580,41600,41622,41623,41629,41776,42010,42032,42034,42214,42230,42258,42265,42307,42321,42325,42356,42370,42411,42422,42479,42485,42502,42546,42584,42585,42718,42766,42815,42932,42941,43010,43067,43074,43284,43331,43412,43573,43574,43581,43825,43954,44056,44114,44274,44314,44319,44338,44400,44689,44691,44720,44777,44792,44794,44807,45034,45045,45047,45133,45156,45157,45302,45362,45476,45477,45478,45595,45626,45649,45762,45772,45779,45910,45982,46078,46079,46228,46377,46447,46630,46668,46746,46747,47003,47053,47055,47107,47142,47166,47257,47273,47447,47504,47512,47553,47704,47843,47846,47890,47911,47915,47933,47934,47999,48007,48116,48150,48165,48176,48186,48188,48192,48226,48236,48243,48255,48258,48261,48278,48442,48527,48531,48620,48653,48700,48719,49067,49171,49231,49287,49470,49582,49608,49609,49610,49700,49749,49773,49789,49825,49835,49851,49852,49923,50498,50597,50748,50780,50787,50844,50861,50864,50928,50981,51054,51190,51585,51704,51930,52023,52135,52137,52144,52153,52159,52160,52417,52465,52556,52596,52637,52663,52706,52768,52992,53030,53031,53053,53089,53496,53506,53555,53556,53623,53931,54004,54063,54359,54361,54439,54891,55411,55557,55558,55674,55708,55709,55776,55889,55988,56006,56204,56403,56656,56657,56821,56832,56989,57056,57122,57481,57644,57854,57887,57928,57980,58039,58073,58074,58187,58275,58367,58749,59008,59128,59130,59131,59132,59329,59492,59786,59918,60015,60116,60362,60728,60805,61071,61136,61337,61573,61575,61709,61749,61827,61839,61957,62649,62790,62795,63099,63349,63415,63416,64106,64107,64108,64166,64392,64476,64483,64580,64895,64962,65069,65221,65770,66084,66292,66296,66600,66713,67326,67341,67578,67579,67736,67737,67755,68117,69010,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,30972,30973,30974,30976,30978,35234,37049,37196,37724,37725,38270,38626,39387,39595,39935,40982,42382,42489,42538,42773,43285,44174,44742,44778,45453,45509,45591,45710,46182,46403,46405,46946,47069,47072,47106,48930,49382,49665,49894,50375,50429,50750,50898,51131,51132,51162,53310,54194,54769,55041,55523,55549,56028,56164,56298,57564,58478,59012,59028,59491,60145,60153,60155,60156,60369,60751,60752,63914,64132,65242,65275,65850,65974,66007,66330,68102,68995,69072,69231,69232,69233) [ RunTime:0.010315s ]
SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` IN (30959,30960,30961,30985,30992,30993,30994,30995,30996,30997,31939,31961,31989,33537,33540,33543,33560,33570,33588,34126,34127,34570,34571,34584,34608,34627,34628,34629,34630,34631,34632,34633,34634,34635,34637,34641,34642,34643,34644,34645,34646,34647,34648,34727,34728,34831,34866,34870,34889,34890,34891,34907,34908,34936,35079,35081,35082,35110,35236,35326,35611,36028,36066,36117,36148,36154,36284,36313,36666,36670,36674,36700,36758,36765,36788,36797,36844,36869,36912,36960,36983,37037,37060,37096,37135,37216,37219,37239,37270,37271,37293,37341,37410,37450,37453,37492,37531,37532,37533,37534,37535,37536,37538,37551,37554,37555,37572,37573,37575,37577,37579,37581,37604,37674,37676,37721,37748,37768,37776,37780,37786,37794,37831,38049,38126,38178,38202,38203,38204,38205,38206,38207,38217,38239,38240,38241,38243,38246,38294,38295,38334,38381,38389,38390,38404,38517,38616,38627,38631,38632,38770,38773,38788,38793,38796,38828,38896,38926,39048,39100,39101,39116,39153,39209,39245,39369,39371,39393,39426,39432,39438,39445,39483,39484,39550,39592,39594,39744,39771,39861,39993,40058,40091,40095,40099,40100,40101,40102,40108,40119,40120,40122,40165,40185,40222,40231,40234,40325,40353,40360,40373,40374,40391,40405,40407,40425,40426,40438,40525,40556,40597,40598,40635,40647,40655,40680,40701,40706,40707,40713,40716,40873,40892,40918,40979,40981,40994,41035,41062,41066,41099,41109,41162,41230,41231,41253,41254,41381,41502,41580,41600,41622,41623,41629,41776,42010,42032,42034,42214,42230,42258,42265,42307,42321,42325,42356,42370,42411,42422,42479,42485,42502,42546,42584,42585,42718,42766,42815,42932,42941,43010,43067,43074,43284,43331,43412,43573,43574,43581,43825,43954,44056,44114,44274,44314,44319,44338,44400,44689,44691,44720,44777,44792,44794,44807,45034,45045,45047,45133,45156,45157,45302,45362,45476,45477,45478,45595,45626,45649,45762,45772,45779,45910,45982,46078,46079,46228,46377,46447,46630,46668,46746,46747,47003,47053,47055,47107,47142,47166,47257,47273,47447,47504,47512,47553,47704,47843,47846,47890,47911,47915,47933,47934,47999,48007,48116,48150,48165,48176,48186,48188,48192,48226,48236,48243,48255,48258,48261,48278,48442,48527,48531,48620,48653,48700,48719,49067,49171,49231,49287,49470,49582,49608,49609,49610,49700,49749,49773,49789,49825,49835,49851,49852,49923,50498,50597,50748,50780,50787,50844,50861,50864,50928,50981,51054,51190,51585,51704,51930,52023,52135,52137,52144,52153,52159,52160,52417,52465,52556,52596,52637,52663,52706,52768,52992,53030,53031,53053,53089,53496,53506,53555,53556,53623,53931,54004,54063,54359,54361,54439,54891,55411,55557,55558,55674,55708,55709,55776,55889,55988,56006,56204,56403,56656,56657,56821,56832,56989,57056,57122,57481,57644,57854,57887,57928,57980,58039,58073,58074,58187,58275,58367,58749,59008,59128,59130,59131,59132,59329,59492,59786,59918,60015,60116,60362,60728,60805,61071,61136,61337,61573,61575,61709,61749,61827,61839,61957,62649,62790,62795,63099,63349,63415,63416,64106,64107,64108,64166,64392,64476,64483,64580,64895,64962,65069,65221,65770,66084,66292,66296,66600,66713,67326,67341,67578,67579,67736,67737,67755,68117,69010,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,30972,30973,30974,30976,30978,35234,37049,37196,37724,37725,38270,38626,39387,39595,39935,40982,42382,42489,42538,42773,43285,44174,44742,44778,45453,45509,45591,45710,46182,46403,46405,46946,47069,47072,47106,48930,49382,49665,49894,50375,50429,50750,50898,51131,51132,51162,53310,54194,54769,55041,55523,55549,56028,56164,56298,57564,58478,59012,59028,59491,60145,60153,60155,60156,60369,60751,60752,63914,64132,65242,65275,65850,65974,66007,66330,68102,68995,69072,69231,69232,69233) AND `brand_id` > 0 [ RunTime:0.009740s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.000729s ]
SELECT * FROM `tp_brand` WHERE `id` IN (4434,4435,4448,4545,4439,4444,4446,4484,5111,4436,4440,4449,4495,5166,5281,5650,5380,4944,4443,4482,5932,5751,4617,4809,5621,5098,4515,6266,6629,7139,7215,5489,6750,6987,4572,4751,4568,7766,4517,4472,5651,6661,5931,5419,4619,5458) GROUP BY `name` LIMIT 30 [ RunTime:0.001241s ]
select group_concat(`key` separator '_') as `key` from tp_spec_goods_price where goods_id in(30959,30960,30961,30985,30992,30993,30994,30995,30996,30997,31939,31961,31989,33537,33540,33543,33560,33570,33588,34126,34127,34570,34571,34584,34608,34627,34628,34629,34630,34631,34632,34633,34634,34635,34637,34641,34642,34643,34644,34645,34646,34647,34648,34727,34728,34831,34866,34870,34889,34890,34891,34907,34908,34936,35079,35081,35082,35110,35236,35326,35611,36028,36066,36117,36148,36154,36284,36313,36666,36670,36674,36700,36758,36765,36788,36797,36844,36869,36912,36960,36983,37037,37060,37096,37135,37216,37219,37239,37270,37271,37293,37341,37410,37450,37453,37492,37531,37532,37533,37534,37535,37536,37538,37551,37554,37555,37572,37573,37575,37577,37579,37581,37604,37674,37676,37721,37748,37768,37776,37780,37786,37794,37831,38049,38126,38178,38202,38203,38204,38205,38206,38207,38217,38239,38240,38241,38243,38246,38294,38295,38334,38381,38389,38390,38404,38517,38616,38627,38631,38632,38770,38773,38788,38793,38796,38828,38896,38926,39048,39100,39101,39116,39153,39209,39245,39369,39371,39393,39426,39432,39438,39445,39483,39484,39550,39592,39594,39744,39771,39861,39993,40058,40091,40095,40099,40100,40101,40102,40108,40119,40120,40122,40165,40185,40222,40231,40234,40325,40353,40360,40373,40374,40391,40405,40407,40425,40426,40438,40525,40556,40597,40598,40635,40647,40655,40680,40701,40706,40707,40713,40716,40873,40892,40918,40979,40981,40994,41035,41062,41066,41099,41109,41162,41230,41231,41253,41254,41381,41502,41580,41600,41622,41623,41629,41776,42010,42032,42034,42214,42230,42258,42265,42307,42321,42325,42356,42370,42411,42422,42479,42485,42502,42546,42584,42585,42718,42766,42815,42932,42941,43010,43067,43074,43284,43331,43412,43573,43574,43581,43825,43954,44056,44114,44274,44314,44319,44338,44400,44689,44691,44720,44777,44792,44794,44807,45034,45045,45047,45133,45156,45157,45302,45362,45476,45477,45478,45595,45626,45649,45762,45772,45779,45910,45982,46078,46079,46228,46377,46447,46630,46668,46746,46747,47003,47053,47055,47107,47142,47166,47257,47273,47447,47504,47512,47553,47704,47843,47846,47890,47911,47915,47933,47934,47999,48007,48116,48150,48165,48176,48186,48188,48192,48226,48236,48243,48255,48258,48261,48278,48442,48527,48531,48620,48653,48700,48719,49067,49171,49231,49287,49470,49582,49608,49609,49610,49700,49749,49773,49789,49825,49835,49851,49852,49923,50498,50597,50748,50780,50787,50844,50861,50864,50928,50981,51054,51190,51585,51704,51930,52023,52135,52137,52144,52153,52159,52160,52417,52465,52556,52596,52637,52663,52706,52768,52992,53030,53031,53053,53089,53496,53506,53555,53556,53623,53931,54004,54063,54359,54361,54439,54891,55411,55557,55558,55674,55708,55709,55776,55889,55988,56006,56204,56403,56656,56657,56821,56832,56989,57056,57122,57481,57644,57854,57887,57928,57980,58039,58073,58074,58187,58275,58367,58749,59008,59128,59130,59131,59132,59329,59492,59786,59918,60015,60116,60362,60728,60805,61071,61136,61337,61573,61575,61709,61749,61827,61839,61957,62649,62790,62795,63099,63349,63415,63416,64106,64107,64108,64166,64392,64476,64483,64580,64895,64962,65069,65221,65770,66084,66292,66296,66600,66713,67326,67341,67578,67579,67736,67737,67755,68117,69010,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,30972,30973,30974,30976,30978,35234,37049,37196,37724,37725,38270,38626,39387,39595,39935,40982,42382,42489,42538,42773,43285,44174,44742,44778,45453,45509,45591,45710,46182,46403,46405,46946,47069,47072,47106,48930,49382,49665,49894,50375,50429,50750,50898,51131,51132,51162,53310,54194,54769,55041,55523,55549,56028,56164,56298,57564,58478,59012,59028,59491,60145,60153,60155,60156,60369,60751,60752,63914,64132,65242,65275,65850,65974,66007,66330,68102,68995,69072,69231,69232,69233) [ RunTime:0.001721s ]
SHOW FULL COLUMNS FROM `tp_goods_attr` [ RunTime:0.000597s ]
SELECT * FROM `tp_goods_attr` WHERE `goods_id` IN (30959,30960,30961,30985,30992,30993,30994,30995,30996,30997,31939,31961,31989,33537,33540,33543,33560,33570,33588,34126,34127,34570,34571,34584,34608,34627,34628,34629,34630,34631,34632,34633,34634,34635,34637,34641,34642,34643,34644,34645,34646,34647,34648,34727,34728,34831,34866,34870,34889,34890,34891,34907,34908,34936,35079,35081,35082,35110,35236,35326,35611,36028,36066,36117,36148,36154,36284,36313,36666,36670,36674,36700,36758,36765,36788,36797,36844,36869,36912,36960,36983,37037,37060,37096,37135,37216,37219,37239,37270,37271,37293,37341,37410,37450,37453,37492,37531,37532,37533,37534,37535,37536,37538,37551,37554,37555,37572,37573,37575,37577,37579,37581,37604,37674,37676,37721,37748,37768,37776,37780,37786,37794,37831,38049,38126,38178,38202,38203,38204,38205,38206,38207,38217,38239,38240,38241,38243,38246,38294,38295,38334,38381,38389,38390,38404,38517,38616,38627,38631,38632,38770,38773,38788,38793,38796,38828,38896,38926,39048,39100,39101,39116,39153,39209,39245,39369,39371,39393,39426,39432,39438,39445,39483,39484,39550,39592,39594,39744,39771,39861,39993,40058,40091,40095,40099,40100,40101,40102,40108,40119,40120,40122,40165,40185,40222,40231,40234,40325,40353,40360,40373,40374,40391,40405,40407,40425,40426,40438,40525,40556,40597,40598,40635,40647,40655,40680,40701,40706,40707,40713,40716,40873,40892,40918,40979,40981,40994,41035,41062,41066,41099,41109,41162,41230,41231,41253,41254,41381,41502,41580,41600,41622,41623,41629,41776,42010,42032,42034,42214,42230,42258,42265,42307,42321,42325,42356,42370,42411,42422,42479,42485,42502,42546,42584,42585,42718,42766,42815,42932,42941,43010,43067,43074,43284,43331,43412,43573,43574,43581,43825,43954,44056,44114,44274,44314,44319,44338,44400,44689,44691,44720,44777,44792,44794,44807,45034,45045,45047,45133,45156,45157,45302,45362,45476,45477,45478,45595,45626,45649,45762,45772,45779,45910,45982,46078,46079,46228,46377,46447,46630,46668,46746,46747,47003,47053,47055,47107,47142,47166,47257,47273,47447,47504,47512,47553,47704,47843,47846,47890,47911,47915,47933,47934,47999,48007,48116,48150,48165,48176,48186,48188,48192,48226,48236,48243,48255,48258,48261,48278,48442,48527,48531,48620,48653,48700,48719,49067,49171,49231,49287,49470,49582,49608,49609,49610,49700,49749,49773,49789,49825,49835,49851,49852,49923,50498,50597,50748,50780,50787,50844,50861,50864,50928,50981,51054,51190,51585,51704,51930,52023,52135,52137,52144,52153,52159,52160,52417,52465,52556,52596,52637,52663,52706,52768,52992,53030,53031,53053,53089,53496,53506,53555,53556,53623,53931,54004,54063,54359,54361,54439,54891,55411,55557,55558,55674,55708,55709,55776,55889,55988,56006,56204,56403,56656,56657,56821,56832,56989,57056,57122,57481,57644,57854,57887,57928,57980,58039,58073,58074,58187,58275,58367,58749,59008,59128,59130,59131,59132,59329,59492,59786,59918,60015,60116,60362,60728,60805,61071,61136,61337,61573,61575,61709,61749,61827,61839,61957,62649,62790,62795,63099,63349,63415,63416,64106,64107,64108,64166,64392,64476,64483,64580,64895,64962,65069,65221,65770,66084,66292,66296,66600,66713,67326,67341,67578,67579,67736,67737,67755,68117,69010,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,30972,30973,30974,30976,30978,35234,37049,37196,37724,37725,38270,38626,39387,39595,39935,40982,42382,42489,42538,42773,43285,44174,44742,44778,45453,45509,45591,45710,46182,46403,46405,46946,47069,47072,47106,48930,49382,49665,49894,50375,50429,50750,50898,51131,51132,51162,53310,54194,54769,55041,55523,55549,56028,56164,56298,57564,58478,59012,59028,59491,60145,60153,60155,60156,60369,60751,60752,63914,64132,65242,65275,65850,65974,66007,66330,68102,68995,69072,69231,69232,69233) AND `attr_value` <> '' [ RunTime:0.012566s ]
SHOW FULL COLUMNS FROM `tp_goods_attribute` [ RunTime:0.000570s ]
SELECT `attr_id`,`attr_id`,`attr_name`,`attr_index` FROM `tp_goods_attribute` WHERE ( attr_index = 1 ) [ RunTime:0.000162s ]
SELECT * FROM `tp_goods` WHERE `goods_id` IN (30959,30960,30961,30985,30992,30993,30994,30995,30996,30997,31939,31961,31989,33537,33540,33543,33560,33570,33588,34126,34127,34570,34571,34584,34608,34627,34628,34629,34630,34631,34632,34633,34634,34635,34637,34641,34642,34643,34644,34645,34646,34647,34648,34727,34728,34831,34866,34870,34889,34890,34891,34907,34908,34936,35079,35081,35082,35110,35236,35326,35611,36028,36066,36117,36148,36154,36284,36313,36666,36670,36674,36700,36758,36765,36788,36797,36844,36869,36912,36960,36983,37037,37060,37096,37135,37216,37219,37239,37270,37271,37293,37341,37410,37450,37453,37492,37531,37532,37533,37534,37535,37536,37538,37551,37554,37555,37572,37573,37575,37577,37579,37581,37604,37674,37676,37721,37748,37768,37776,37780,37786,37794,37831,38049,38126,38178,38202,38203,38204,38205,38206,38207,38217,38239,38240,38241,38243,38246,38294,38295,38334,38381,38389,38390,38404,38517,38616,38627,38631,38632,38770,38773,38788,38793,38796,38828,38896,38926,39048,39100,39101,39116,39153,39209,39245,39369,39371,39393,39426,39432,39438,39445,39483,39484,39550,39592,39594,39744,39771,39861,39993,40058,40091,40095,40099,40100,40101,40102,40108,40119,40120,40122,40165,40185,40222,40231,40234,40325,40353,40360,40373,40374,40391,40405,40407,40425,40426,40438,40525,40556,40597,40598,40635,40647,40655,40680,40701,40706,40707,40713,40716,40873,40892,40918,40979,40981,40994,41035,41062,41066,41099,41109,41162,41230,41231,41253,41254,41381,41502,41580,41600,41622,41623,41629,41776,42010,42032,42034,42214,42230,42258,42265,42307,42321,42325,42356,42370,42411,42422,42479,42485,42502,42546,42584,42585,42718,42766,42815,42932,42941,43010,43067,43074,43284,43331,43412,43573,43574,43581,43825,43954,44056,44114,44274,44314,44319,44338,44400,44689,44691,44720,44777,44792,44794,44807,45034,45045,45047,45133,45156,45157,45302,45362,45476,45477,45478,45595,45626,45649,45762,45772,45779,45910,45982,46078,46079,46228,46377,46447,46630,46668,46746,46747,47003,47053,47055,47107,47142,47166,47257,47273,47447,47504,47512,47553,47704,47843,47846,47890,47911,47915,47933,47934,47999,48007,48116,48150,48165,48176,48186,48188,48192,48226,48236,48243,48255,48258,48261,48278,48442,48527,48531,48620,48653,48700,48719,49067,49171,49231,49287,49470,49582,49608,49609,49610,49700,49749,49773,49789,49825,49835,49851,49852,49923,50498,50597,50748,50780,50787,50844,50861,50864,50928,50981,51054,51190,51585,51704,51930,52023,52135,52137,52144,52153,52159,52160,52417,52465,52556,52596,52637,52663,52706,52768,52992,53030,53031,53053,53089,53496,53506,53555,53556,53623,53931,54004,54063,54359,54361,54439,54891,55411,55557,55558,55674,55708,55709,55776,55889,55988,56006,56204,56403,56656,56657,56821,56832,56989,57056,57122,57481,57644,57854,57887,57928,57980,58039,58073,58074,58187,58275,58367,58749,59008,59128,59130,59131,59132,59329,59492,59786,59918,60015,60116,60362,60728,60805,61071,61136,61337,61573,61575,61709,61749,61827,61839,61957,62649,62790,62795,63099,63349,63415,63416,64106,64107,64108,64166,64392,64476,64483,64580,64895,64962,65069,65221,65770,66084,66292,66296,66600,66713,67326,67341,67578,67579,67736,67737,67755,68117,69010,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,30972,30973,30974,30976,30978,35234,37049,37196,37724,37725,38270,38626,39387,39595,39935,40982,42382,42489,42538,42773,43285,44174,44742,44778,45453,45509,45591,45710,46182,46403,46405,46946,47069,47072,47106,48930,49382,49665,49894,50375,50429,50750,50898,51131,51132,51162,53310,54194,54769,55041,55523,55549,56028,56164,56298,57564,58478,59012,59028,59491,60145,60153,60155,60156,60369,60751,60752,63914,64132,65242,65275,65850,65974,66007,66330,68102,68995,69072,69231,69232,69233) ORDER BY `sort` ASC LIMIT 0,10 [ RunTime:0.004780s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.000553s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (30958,30959,30960,30961,30964,30965,30966,30967,30968,30972) [ RunTime:0.000492s ]
SHOW FULL COLUMNS FROM `tp_goods_label` [ RunTime:0.000392s ]
SELECT `label_id`,`label_name` FROM `tp_goods_label` [ RunTime:0.000138s ]
SELECT `id`,`id`,`name`,`parent_id`,`level` FROM `tp_goods_category` WHERE ( is_show=1 ) [ RunTime:0.000208s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30958 LIMIT 1 [ RunTime:0.000190s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30959 LIMIT 1 [ RunTime:0.000157s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30960 LIMIT 1 [ RunTime:0.000168s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30961 LIMIT 1 [ RunTime:0.000224s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30964 LIMIT 1 [ RunTime:0.000261s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30965 LIMIT 1 [ RunTime:0.000244s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30966 LIMIT 1 [ RunTime:0.000430s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30967 LIMIT 1 [ RunTime:0.000234s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30968 LIMIT 1 [ RunTime:0.000201s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30972 LIMIT 1 [ RunTime:0.000237s ]
