SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.008150s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 963 LIMIT 1 [ RunTime:0.007282s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 957 ORDER BY `sort_order` DESC LIMIT 1 [ RunTime:0.006153s ]
SELECT `id`,`parent_id` FROM `tp_goods_category` [ RunTime:0.007435s ]
SELECT `id` FROM `tp_goods_category` WHERE `parent_id` = 963 [ RunTime:0.008871s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.009338s ]
SELECT `goods_id` FROM `tp_goods` WHERE `is_on_sale` = 1 AND `exchange_integral` = 0 AND `cat_id` = 963 [ RunTime:0.006094s ]
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) [ RunTime:0.006489s ]
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) AND `brand_id` > 0 [ RunTime:0.008606s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.003444s ]
SELECT * FROM `tp_brand` WHERE `id` IN (4435,4434,4439,4484,5111,4436,5166,4449,4440,5281,5380,4944,4482,5932,5751,4617,4809,5621,5098,6629,4443,7139,7215,5489,6750,6987,4572,4751,4568,7766,4517,5651,4619,5458) GROUP BY `name` LIMIT 30 [ RunTime:0.006275s ]
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) [ RunTime:0.003744s ]
SHOW FULL COLUMNS FROM `tp_goods_attr` [ RunTime:0.004982s ]
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) AND `attr_value` <> '' [ RunTime:0.011280s ]
SHOW FULL COLUMNS FROM `tp_goods_attribute` [ RunTime:0.009329s ]
SELECT `attr_id`,`attr_id`,`attr_name`,`attr_index` FROM `tp_goods_attribute` WHERE ( attr_index = 1 ) [ RunTime:0.004483s ]
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) ORDER BY `sort` ASC LIMIT 0,10 [ RunTime:0.010979s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.008803s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (30959,30960,30961,30985,30992,30993,30994,30995,30996,30997) [ RunTime:0.009664s ]
SHOW FULL COLUMNS FROM `tp_goods_label` [ RunTime:0.005647s ]
SELECT `label_id`,`label_name` FROM `tp_goods_label` [ RunTime:0.005601s ]
SELECT `id`,`id`,`name`,`parent_id`,`level` FROM `tp_goods_category` WHERE ( is_show=1 ) [ RunTime:0.003775s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30959 LIMIT 1 [ RunTime:0.006197s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30960 LIMIT 1 [ RunTime:0.008794s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30961 LIMIT 1 [ RunTime:0.002312s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30985 LIMIT 1 [ RunTime:0.006668s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30992 LIMIT 1 [ RunTime:0.007750s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30993 LIMIT 1 [ RunTime:0.005257s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30994 LIMIT 1 [ RunTime:0.005542s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30995 LIMIT 1 [ RunTime:0.004761s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30996 LIMIT 1 [ RunTime:0.004235s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30997 LIMIT 1 [ RunTime:0.005659s ]
