SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.001084s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 998 LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`parent_id` FROM `tp_goods_category` [ RunTime:0.000743s ]
SELECT `id` FROM `tp_goods_category` WHERE `parent_id` = 998 [ RunTime:0.000337s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.001188s ]
SELECT `goods_id` FROM `tp_goods` WHERE `is_on_sale` = 1 AND `exchange_integral` = 0 AND `cat_id` IN (998,999,1000,1001,1002,1003,1004,1005,1006,1007,1008,1009,1010,1011,1012,1013,1014,1015,1016,1017,1018,1019,1020,1021,1022,1023,1024,1686) [ RunTime:0.005183s ]
SELECT `zs_price` FROM `tp_goods` WHERE `goods_id` IN (31139,31140,31141,31143,31145,31147,31148,31149,31151,31152,31153,31154,31155,31156,31158,31159,33996,33997,33998,33999,34000,34001,34002,34003,34004,34005,34006,34007,34008,34009,34010,34011,34012,34013,34014,34015,34016,34018,34019,34020,34021,34022,34023,34024,34025,34028,34029,34030,34031,34032,34033,34034,34035,34037,34038,34039,34040,34041,34042,34043,34044,34045,34049,34050,34052,34053,34054,34649,34658,34660,34661,34662,34664,34665,34666,34667,34668,34669,34670,34671,34672,34673,34674,34675,34676,34677,34678,36441,36560,36882,37098,37342,37788,38324,39045,39434,39703,40229,40400,40696,41125,41980,42993,43355,43356,43999,46343,46949,46984,47070,47103,47159,47676,47929,48105,48175,48929,49370,49380,51027,52157,52497,52498,52504,52508,52530,52531,52618,52619,52620,52623,52831,52832,52834,52843,53502,53828,54329,55285,55898,57340,57658,58844,59016,59064,60853,62510,63273,63274,63290,64913,65609,65851,67231,67331,67332,67340,36540,37148,37215,37220,37263,37264,37411,37772,38109,38609,39046,39201,39634,39715,39916,40225,40230,40401,41100,41126,41127,41128,41158,41468,43177,44386,44387,45089,45151,45775,46153,46344,46562,46694,48373,48735,48932,49019,50116,50134,50601,50775,51028,51881,51969,51970,51973,51975,51977,51980,51981,51982,51984,51986,51992,51994,51997,51999,52209,52210,52211,53504,53505,53762,54048,55911,56223,57146,57945,59011,62374,64472,64671,67333,67979,67986,68466,31163,31164,31167,31172,31173,31623,31653,31662,31667,31671,31673,31676,31678,31679,31686,31688,31689,31692,31696,31697,31712,31714,31715,31719,31725,31731,31993,31994,31995,34724,35396,35413,35415,35420,35422,35426,35429,36077,36079,36080,36081,36082,36083,36084,36085,36086,36146,36156,36667,37095,37279,37346,37688,37708,37714,37807,38210,38283,38284,38285,38287,38288,38323,38384,38635,38791,38792,38888,39120,39161,39257,39277,39538,39558,39764,40460,40506,40543,40600,40668,40859,40884,41258,41259,41368,41576,42293,42322,42366,42390,42416,42588,42597,42620,42857,43000,43143,43282,44117,44313,44886,44900,44901,44902,44903,44904,44905,44906,44907,44962,46334,46671,46974,47105,47284,47677,47721,47957,48006,48594,48859,49340,49684,50824,51177,51542,51636,52024,52276,52468,52769,53604,54689,54690,54691,54693,54694,54699,54700,55409,56039,56691,57161,57211,57289,57341,57588,57589,57590,57591,57592,57593,57832,57833,57953,58832,59305,60157,60763,60787,60858,61085,61115,61116,61237,61539,62014,62101,62880,63219,64831,64832,65723,66914,67499,68113,68307,68345,68572,34833,37666,38994,41076,41868,41973,42594,43425,43775,44092,45408,45986,46126,46304,46702,47420,48212,48213,49254,49255,50105,50488,51021,51105,51846,51879,51880,53333,53750,53765,54901,54960,55021,55170,55813,57793,58738,58873,60452,61351,61868,62422,64050,67266,68203,68918,69397,39765,43055,46942,49094,49095,51008,54604,55551,55552,56639,56838,56880,59930,59966,60932,61441,63391,63507,65072,66771,66840,68890,69061,56682,56683,35107,36873,36966,38175,38220,39064,39126,39160,39333,39842,40068,40393,40721,40798,40956,41004,41517,41797,42286,42315,42622,42629,43220,43685,43689,45073,46385,46387,46757,46901,48678,48747,48858,50667,51110,51111,51115,51119,51274,51275,51276,51277,51740,51741,51850,53059,53901,54458,55134,55978,55979,55993,57182,57183,57184,57185,57186,57187,57188,57189,57190,57396,57598,57630,57709,58340,58511,59330,59839,59846,60724,61533,62152,63017,63201,63202,63547,63635,64183,64188,65624,66080,66242,66323,67566,67824,68464,68752,68753,68770,68927,69630,31111,31112,31113,31114,31115,31116,31117,31118,31119,31120,31121,36668,37574,38183,39047,39073,39275,39345,39357,40689,41086,41403,41996,42256,42369,42547,42590,42805,42955,42956,43319,43763,44022,44191,44212,44239,44763,44768,45072,45380,45457,46197,46211,46316,46577,47034,48134,48830,50210,50390,50445,50635,51012,51013,51014,51015,51016,51017,51018,51023,51024,51076,51077,51078,51079,51080,51096,51097,51098,51099,51100,51108,51109,51410,52028,52358,52554,53033,53058,54478,54702,55319,55553,56098,57134,57162,57163,57164,57165,57166,57167,57168,57169,57170,57171,57172,57173,57174,57416,58711,59108,59212,59241,59482,59548,59993,59994,60136,60365,60734,60768,61077,61612,62483,62522,62642,62943,63304,63738,64934,65608,65710,65836,65918,66006,66042,66294,66328,66492,66744,67501,67820,68693,68776,68882,69062,69134,69362,69461,69476,69503,36516,39961,41220,41221,43132,43137,45781,46985,47901,48681,49793,49794,50927,51736,55045,55138,56029,56088,57175,57176,57177,57178,57179,57198,57642,58044,58827,58831,59221,60881,62153,62355,62356,63136,64250,66545,34511,34512,34513,34514,34515,34516,34530,34531,34532,34533,42904,44199,47117,47235,47477,49395,50068,50069,50070,50071,50072,50073,50074,50075,50076,50077,50078,50079,50080,50081,50082,50083,50084,50085,50086,50087,50088,50089,50090,50091,50092,50093,50094,55009,57180,57181,57191,57192,57193,57195,57646,58040,59195,60882,61043,61044,61110,61168,62423,63051,63586,63638,64756,65167,65763,66275,66276,66576,68956,69410,69475,31524,31525,31526,34924,37678,39760,41862,42759,43603,46462,46500,46677,50668,52277,52282,55194,56867,59388,61105,64190,65027,65028,65432,66116,66645,67122,53645,35036,35037,35038,35041,35042,35043,35044,35045,35046,35047,35048,35049,35050,35051,35052,35053,35054,35055,35303,35307,35312,35314,35315,35316,35317,35321,35324,36534,36541,36555,36567,36622,37027,37028,37031,37116,38147,38630,39543,40199,40339,40404,41101,41289,41751,42029,42074,42075,42077,42313,43576,43577,43901,44277,44644,44650,45091,45101,45154,45353,45404,46345,46346,46431,46681,46916,47005,47028,47029,47485,47531,47713,48151,48359,48878,49344,49357,49358,49562,49805,49827,49847,50137,50147,50148,50662,50663,51088,51530,51698,51905,52027,52029,52036,52037,52038,52065,52066,52068,52675,53133,53313,53401,53402,53540,53565,54173,54596,54666,54668,54671,54941,55023,55026,55080,55655,55690,55695,55696,55736,55992,56026,56118,56155,56169,56170,56184,56258,56294,56419,56640,56920,57759,57760,57761,57975,57976,58045,58071,58220,58445,58552,58573,58593,58626,58663,58664,58813,58814,58815,58816,58817,58936,59120,59236,59374,59375,59752,59755,59787,60214,60278,60656,60811,60822,60855,60885,61068,61408,61503,61568,61834,62093,62567,62697,63052,63601,63743,63744,63745,63746,63747,63748,63749,63763,63764,63765,63767,63768,64138,64411,64424,64446,64677,64956,64998,65058,65060,65257,65262,65294,65295,65296,65297,65298,65299,65300,65301,65302,65303,65304,65305,65306,65307,65308,65309,65647,65670,65848,65937,66039,66040,66268,66270,66271,66286,66551,66552,66563,66564,66646,66693,66694,66695,66703,66704,66705,66706,66748,66844,66905,66906,66931,67121,67282,67323,67348,67509,67757,67759,67903,67937,68079,68233,68425,68599,68934,69120,69504,69505,69582) [ RunTime:0.015901s ]
SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` IN (31139,31140,31141,31143,31145,31147,31148,31149,31151,31152,31153,31154,31155,31156,31158,31159,33996,33997,33998,33999,34000,34001,34002,34003,34004,34005,34006,34007,34008,34009,34010,34011,34012,34013,34014,34015,34016,34018,34019,34020,34021,34022,34023,34024,34025,34028,34029,34030,34031,34032,34033,34034,34035,34037,34038,34039,34040,34041,34042,34043,34044,34045,34049,34050,34052,34053,34054,34649,34658,34660,34661,34662,34664,34665,34666,34667,34668,34669,34670,34671,34672,34673,34674,34675,34676,34677,34678,36441,36560,36882,37098,37342,37788,38324,39045,39434,39703,40229,40400,40696,41125,41980,42993,43355,43356,43999,46343,46949,46984,47070,47103,47159,47676,47929,48105,48175,48929,49370,49380,51027,52157,52497,52498,52504,52508,52530,52531,52618,52619,52620,52623,52831,52832,52834,52843,53502,53828,54329,55285,55898,57340,57658,58844,59016,59064,60853,62510,63273,63274,63290,64913,65609,65851,67231,67331,67332,67340,36540,37148,37215,37220,37263,37264,37411,37772,38109,38609,39046,39201,39634,39715,39916,40225,40230,40401,41100,41126,41127,41128,41158,41468,43177,44386,44387,45089,45151,45775,46153,46344,46562,46694,48373,48735,48932,49019,50116,50134,50601,50775,51028,51881,51969,51970,51973,51975,51977,51980,51981,51982,51984,51986,51992,51994,51997,51999,52209,52210,52211,53504,53505,53762,54048,55911,56223,57146,57945,59011,62374,64472,64671,67333,67979,67986,68466,31163,31164,31167,31172,31173,31623,31653,31662,31667,31671,31673,31676,31678,31679,31686,31688,31689,31692,31696,31697,31712,31714,31715,31719,31725,31731,31993,31994,31995,34724,35396,35413,35415,35420,35422,35426,35429,36077,36079,36080,36081,36082,36083,36084,36085,36086,36146,36156,36667,37095,37279,37346,37688,37708,37714,37807,38210,38283,38284,38285,38287,38288,38323,38384,38635,38791,38792,38888,39120,39161,39257,39277,39538,39558,39764,40460,40506,40543,40600,40668,40859,40884,41258,41259,41368,41576,42293,42322,42366,42390,42416,42588,42597,42620,42857,43000,43143,43282,44117,44313,44886,44900,44901,44902,44903,44904,44905,44906,44907,44962,46334,46671,46974,47105,47284,47677,47721,47957,48006,48594,48859,49340,49684,50824,51177,51542,51636,52024,52276,52468,52769,53604,54689,54690,54691,54693,54694,54699,54700,55409,56039,56691,57161,57211,57289,57341,57588,57589,57590,57591,57592,57593,57832,57833,57953,58832,59305,60157,60763,60787,60858,61085,61115,61116,61237,61539,62014,62101,62880,63219,64831,64832,65723,66914,67499,68113,68307,68345,68572,34833,37666,38994,41076,41868,41973,42594,43425,43775,44092,45408,45986,46126,46304,46702,47420,48212,48213,49254,49255,50105,50488,51021,51105,51846,51879,51880,53333,53750,53765,54901,54960,55021,55170,55813,57793,58738,58873,60452,61351,61868,62422,64050,67266,68203,68918,69397,39765,43055,46942,49094,49095,51008,54604,55551,55552,56639,56838,56880,59930,59966,60932,61441,63391,63507,65072,66771,66840,68890,69061,56682,56683,35107,36873,36966,38175,38220,39064,39126,39160,39333,39842,40068,40393,40721,40798,40956,41004,41517,41797,42286,42315,42622,42629,43220,43685,43689,45073,46385,46387,46757,46901,48678,48747,48858,50667,51110,51111,51115,51119,51274,51275,51276,51277,51740,51741,51850,53059,53901,54458,55134,55978,55979,55993,57182,57183,57184,57185,57186,57187,57188,57189,57190,57396,57598,57630,57709,58340,58511,59330,59839,59846,60724,61533,62152,63017,63201,63202,63547,63635,64183,64188,65624,66080,66242,66323,67566,67824,68464,68752,68753,68770,68927,69630,31111,31112,31113,31114,31115,31116,31117,31118,31119,31120,31121,36668,37574,38183,39047,39073,39275,39345,39357,40689,41086,41403,41996,42256,42369,42547,42590,42805,42955,42956,43319,43763,44022,44191,44212,44239,44763,44768,45072,45380,45457,46197,46211,46316,46577,47034,48134,48830,50210,50390,50445,50635,51012,51013,51014,51015,51016,51017,51018,51023,51024,51076,51077,51078,51079,51080,51096,51097,51098,51099,51100,51108,51109,51410,52028,52358,52554,53033,53058,54478,54702,55319,55553,56098,57134,57162,57163,57164,57165,57166,57167,57168,57169,57170,57171,57172,57173,57174,57416,58711,59108,59212,59241,59482,59548,59993,59994,60136,60365,60734,60768,61077,61612,62483,62522,62642,62943,63304,63738,64934,65608,65710,65836,65918,66006,66042,66294,66328,66492,66744,67501,67820,68693,68776,68882,69062,69134,69362,69461,69476,69503,36516,39961,41220,41221,43132,43137,45781,46985,47901,48681,49793,49794,50927,51736,55045,55138,56029,56088,57175,57176,57177,57178,57179,57198,57642,58044,58827,58831,59221,60881,62153,62355,62356,63136,64250,66545,34511,34512,34513,34514,34515,34516,34530,34531,34532,34533,42904,44199,47117,47235,47477,49395,50068,50069,50070,50071,50072,50073,50074,50075,50076,50077,50078,50079,50080,50081,50082,50083,50084,50085,50086,50087,50088,50089,50090,50091,50092,50093,50094,55009,57180,57181,57191,57192,57193,57195,57646,58040,59195,60882,61043,61044,61110,61168,62423,63051,63586,63638,64756,65167,65763,66275,66276,66576,68956,69410,69475,31524,31525,31526,34924,37678,39760,41862,42759,43603,46462,46500,46677,50668,52277,52282,55194,56867,59388,61105,64190,65027,65028,65432,66116,66645,67122,53645,35036,35037,35038,35041,35042,35043,35044,35045,35046,35047,35048,35049,35050,35051,35052,35053,35054,35055,35303,35307,35312,35314,35315,35316,35317,35321,35324,36534,36541,36555,36567,36622,37027,37028,37031,37116,38147,38630,39543,40199,40339,40404,41101,41289,41751,42029,42074,42075,42077,42313,43576,43577,43901,44277,44644,44650,45091,45101,45154,45353,45404,46345,46346,46431,46681,46916,47005,47028,47029,47485,47531,47713,48151,48359,48878,49344,49357,49358,49562,49805,49827,49847,50137,50147,50148,50662,50663,51088,51530,51698,51905,52027,52029,52036,52037,52038,52065,52066,52068,52675,53133,53313,53401,53402,53540,53565,54173,54596,54666,54668,54671,54941,55023,55026,55080,55655,55690,55695,55696,55736,55992,56026,56118,56155,56169,56170,56184,56258,56294,56419,56640,56920,57759,57760,57761,57975,57976,58045,58071,58220,58445,58552,58573,58593,58626,58663,58664,58813,58814,58815,58816,58817,58936,59120,59236,59374,59375,59752,59755,59787,60214,60278,60656,60811,60822,60855,60885,61068,61408,61503,61568,61834,62093,62567,62697,63052,63601,63743,63744,63745,63746,63747,63748,63749,63763,63764,63765,63767,63768,64138,64411,64424,64446,64677,64956,64998,65058,65060,65257,65262,65294,65295,65296,65297,65298,65299,65300,65301,65302,65303,65304,65305,65306,65307,65308,65309,65647,65670,65848,65937,66039,66040,66268,66270,66271,66286,66551,66552,66563,66564,66646,66693,66694,66695,66703,66704,66705,66706,66748,66844,66905,66906,66931,67121,67282,67323,67348,67509,67757,67759,67903,67937,68079,68233,68425,68599,68934,69120,69504,69505,69582) AND `brand_id` > 0 [ RunTime:0.015234s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.001167s ]
SELECT * FROM `tp_brand` WHERE `id` IN (4560,4558,4588,4721,4637,4447,4483,4492,4481,4488,4625,4437,4548,4559,4765,4693,4499,4496,4643,4476,5113,4567,4570,4629,5178,4566,4565,4569,4519,4550,4564,4911,4972,4484,5094,4619,5143,5168,5210,4544,5271,5272,5279,4462,4438,4593,4543,5516,5586,5589,6515,5601,5617,4785,5649,5670,5694,5722,5747,5754,5755,4948,5848,4498,5872,5235,4561,6023,6039,6052,6266,4491,4517,4454,4439,6216,4725,6486,4555,4714,6671,4556,6681,6708,6748,4527,6821,7139,4505,5485,6875,5690,4524,7075,7480,6033,5170,6915,4450,5294,6952,4797,6383,7562,6969,4834,7178,4798,6762,7013,7016,4627,5002,4545,7718,6661,7738,7033,7754,6065,5214,5215,7073,4575,6057,5603,4482,4551,5439,7856,4840,7858,5041,6026,4557,4949,6392,7928,4592,4771,6169,7991,8010,7173,8018,6949,4807,4769,8033,8020,7386,8052,5556,6571,6187,4768,6954,4626,5400,8092,8093,8133,4744,5417) GROUP BY `name` LIMIT 30 [ RunTime:0.007090s ]
select group_concat(`key` separator '_') as `key` from tp_spec_goods_price where goods_id in(31139,31140,31141,31143,31145,31147,31148,31149,31151,31152,31153,31154,31155,31156,31158,31159,33996,33997,33998,33999,34000,34001,34002,34003,34004,34005,34006,34007,34008,34009,34010,34011,34012,34013,34014,34015,34016,34018,34019,34020,34021,34022,34023,34024,34025,34028,34029,34030,34031,34032,34033,34034,34035,34037,34038,34039,34040,34041,34042,34043,34044,34045,34049,34050,34052,34053,34054,34649,34658,34660,34661,34662,34664,34665,34666,34667,34668,34669,34670,34671,34672,34673,34674,34675,34676,34677,34678,36441,36560,36882,37098,37342,37788,38324,39045,39434,39703,40229,40400,40696,41125,41980,42993,43355,43356,43999,46343,46949,46984,47070,47103,47159,47676,47929,48105,48175,48929,49370,49380,51027,52157,52497,52498,52504,52508,52530,52531,52618,52619,52620,52623,52831,52832,52834,52843,53502,53828,54329,55285,55898,57340,57658,58844,59016,59064,60853,62510,63273,63274,63290,64913,65609,65851,67231,67331,67332,67340,36540,37148,37215,37220,37263,37264,37411,37772,38109,38609,39046,39201,39634,39715,39916,40225,40230,40401,41100,41126,41127,41128,41158,41468,43177,44386,44387,45089,45151,45775,46153,46344,46562,46694,48373,48735,48932,49019,50116,50134,50601,50775,51028,51881,51969,51970,51973,51975,51977,51980,51981,51982,51984,51986,51992,51994,51997,51999,52209,52210,52211,53504,53505,53762,54048,55911,56223,57146,57945,59011,62374,64472,64671,67333,67979,67986,68466,31163,31164,31167,31172,31173,31623,31653,31662,31667,31671,31673,31676,31678,31679,31686,31688,31689,31692,31696,31697,31712,31714,31715,31719,31725,31731,31993,31994,31995,34724,35396,35413,35415,35420,35422,35426,35429,36077,36079,36080,36081,36082,36083,36084,36085,36086,36146,36156,36667,37095,37279,37346,37688,37708,37714,37807,38210,38283,38284,38285,38287,38288,38323,38384,38635,38791,38792,38888,39120,39161,39257,39277,39538,39558,39764,40460,40506,40543,40600,40668,40859,40884,41258,41259,41368,41576,42293,42322,42366,42390,42416,42588,42597,42620,42857,43000,43143,43282,44117,44313,44886,44900,44901,44902,44903,44904,44905,44906,44907,44962,46334,46671,46974,47105,47284,47677,47721,47957,48006,48594,48859,49340,49684,50824,51177,51542,51636,52024,52276,52468,52769,53604,54689,54690,54691,54693,54694,54699,54700,55409,56039,56691,57161,57211,57289,57341,57588,57589,57590,57591,57592,57593,57832,57833,57953,58832,59305,60157,60763,60787,60858,61085,61115,61116,61237,61539,62014,62101,62880,63219,64831,64832,65723,66914,67499,68113,68307,68345,68572,34833,37666,38994,41076,41868,41973,42594,43425,43775,44092,45408,45986,46126,46304,46702,47420,48212,48213,49254,49255,50105,50488,51021,51105,51846,51879,51880,53333,53750,53765,54901,54960,55021,55170,55813,57793,58738,58873,60452,61351,61868,62422,64050,67266,68203,68918,69397,39765,43055,46942,49094,49095,51008,54604,55551,55552,56639,56838,56880,59930,59966,60932,61441,63391,63507,65072,66771,66840,68890,69061,56682,56683,35107,36873,36966,38175,38220,39064,39126,39160,39333,39842,40068,40393,40721,40798,40956,41004,41517,41797,42286,42315,42622,42629,43220,43685,43689,45073,46385,46387,46757,46901,48678,48747,48858,50667,51110,51111,51115,51119,51274,51275,51276,51277,51740,51741,51850,53059,53901,54458,55134,55978,55979,55993,57182,57183,57184,57185,57186,57187,57188,57189,57190,57396,57598,57630,57709,58340,58511,59330,59839,59846,60724,61533,62152,63017,63201,63202,63547,63635,64183,64188,65624,66080,66242,66323,67566,67824,68464,68752,68753,68770,68927,69630,31111,31112,31113,31114,31115,31116,31117,31118,31119,31120,31121,36668,37574,38183,39047,39073,39275,39345,39357,40689,41086,41403,41996,42256,42369,42547,42590,42805,42955,42956,43319,43763,44022,44191,44212,44239,44763,44768,45072,45380,45457,46197,46211,46316,46577,47034,48134,48830,50210,50390,50445,50635,51012,51013,51014,51015,51016,51017,51018,51023,51024,51076,51077,51078,51079,51080,51096,51097,51098,51099,51100,51108,51109,51410,52028,52358,52554,53033,53058,54478,54702,55319,55553,56098,57134,57162,57163,57164,57165,57166,57167,57168,57169,57170,57171,57172,57173,57174,57416,58711,59108,59212,59241,59482,59548,59993,59994,60136,60365,60734,60768,61077,61612,62483,62522,62642,62943,63304,63738,64934,65608,65710,65836,65918,66006,66042,66294,66328,66492,66744,67501,67820,68693,68776,68882,69062,69134,69362,69461,69476,69503,36516,39961,41220,41221,43132,43137,45781,46985,47901,48681,49793,49794,50927,51736,55045,55138,56029,56088,57175,57176,57177,57178,57179,57198,57642,58044,58827,58831,59221,60881,62153,62355,62356,63136,64250,66545,34511,34512,34513,34514,34515,34516,34530,34531,34532,34533,42904,44199,47117,47235,47477,49395,50068,50069,50070,50071,50072,50073,50074,50075,50076,50077,50078,50079,50080,50081,50082,50083,50084,50085,50086,50087,50088,50089,50090,50091,50092,50093,50094,55009,57180,57181,57191,57192,57193,57195,57646,58040,59195,60882,61043,61044,61110,61168,62423,63051,63586,63638,64756,65167,65763,66275,66276,66576,68956,69410,69475,31524,31525,31526,34924,37678,39760,41862,42759,43603,46462,46500,46677,50668,52277,52282,55194,56867,59388,61105,64190,65027,65028,65432,66116,66645,67122,53645,35036,35037,35038,35041,35042,35043,35044,35045,35046,35047,35048,35049,35050,35051,35052,35053,35054,35055,35303,35307,35312,35314,35315,35316,35317,35321,35324,36534,36541,36555,36567,36622,37027,37028,37031,37116,38147,38630,39543,40199,40339,40404,41101,41289,41751,42029,42074,42075,42077,42313,43576,43577,43901,44277,44644,44650,45091,45101,45154,45353,45404,46345,46346,46431,46681,46916,47005,47028,47029,47485,47531,47713,48151,48359,48878,49344,49357,49358,49562,49805,49827,49847,50137,50147,50148,50662,50663,51088,51530,51698,51905,52027,52029,52036,52037,52038,52065,52066,52068,52675,53133,53313,53401,53402,53540,53565,54173,54596,54666,54668,54671,54941,55023,55026,55080,55655,55690,55695,55696,55736,55992,56026,56118,56155,56169,56170,56184,56258,56294,56419,56640,56920,57759,57760,57761,57975,57976,58045,58071,58220,58445,58552,58573,58593,58626,58663,58664,58813,58814,58815,58816,58817,58936,59120,59236,59374,59375,59752,59755,59787,60214,60278,60656,60811,60822,60855,60885,61068,61408,61503,61568,61834,62093,62567,62697,63052,63601,63743,63744,63745,63746,63747,63748,63749,63763,63764,63765,63767,63768,64138,64411,64424,64446,64677,64956,64998,65058,65060,65257,65262,65294,65295,65296,65297,65298,65299,65300,65301,65302,65303,65304,65305,65306,65307,65308,65309,65647,65670,65848,65937,66039,66040,66268,66270,66271,66286,66551,66552,66563,66564,66646,66693,66694,66695,66703,66704,66705,66706,66748,66844,66905,66906,66931,67121,67282,67323,67348,67509,67757,67759,67903,67937,68079,68233,68425,68599,68934,69120,69504,69505,69582) [ RunTime:0.003767s ]
SHOW FULL COLUMNS FROM `tp_goods_attr` [ RunTime:0.005662s ]
SELECT * FROM `tp_goods_attr` WHERE `goods_id` IN (31139,31140,31141,31143,31145,31147,31148,31149,31151,31152,31153,31154,31155,31156,31158,31159,33996,33997,33998,33999,34000,34001,34002,34003,34004,34005,34006,34007,34008,34009,34010,34011,34012,34013,34014,34015,34016,34018,34019,34020,34021,34022,34023,34024,34025,34028,34029,34030,34031,34032,34033,34034,34035,34037,34038,34039,34040,34041,34042,34043,34044,34045,34049,34050,34052,34053,34054,34649,34658,34660,34661,34662,34664,34665,34666,34667,34668,34669,34670,34671,34672,34673,34674,34675,34676,34677,34678,36441,36560,36882,37098,37342,37788,38324,39045,39434,39703,40229,40400,40696,41125,41980,42993,43355,43356,43999,46343,46949,46984,47070,47103,47159,47676,47929,48105,48175,48929,49370,49380,51027,52157,52497,52498,52504,52508,52530,52531,52618,52619,52620,52623,52831,52832,52834,52843,53502,53828,54329,55285,55898,57340,57658,58844,59016,59064,60853,62510,63273,63274,63290,64913,65609,65851,67231,67331,67332,67340,36540,37148,37215,37220,37263,37264,37411,37772,38109,38609,39046,39201,39634,39715,39916,40225,40230,40401,41100,41126,41127,41128,41158,41468,43177,44386,44387,45089,45151,45775,46153,46344,46562,46694,48373,48735,48932,49019,50116,50134,50601,50775,51028,51881,51969,51970,51973,51975,51977,51980,51981,51982,51984,51986,51992,51994,51997,51999,52209,52210,52211,53504,53505,53762,54048,55911,56223,57146,57945,59011,62374,64472,64671,67333,67979,67986,68466,31163,31164,31167,31172,31173,31623,31653,31662,31667,31671,31673,31676,31678,31679,31686,31688,31689,31692,31696,31697,31712,31714,31715,31719,31725,31731,31993,31994,31995,34724,35396,35413,35415,35420,35422,35426,35429,36077,36079,36080,36081,36082,36083,36084,36085,36086,36146,36156,36667,37095,37279,37346,37688,37708,37714,37807,38210,38283,38284,38285,38287,38288,38323,38384,38635,38791,38792,38888,39120,39161,39257,39277,39538,39558,39764,40460,40506,40543,40600,40668,40859,40884,41258,41259,41368,41576,42293,42322,42366,42390,42416,42588,42597,42620,42857,43000,43143,43282,44117,44313,44886,44900,44901,44902,44903,44904,44905,44906,44907,44962,46334,46671,46974,47105,47284,47677,47721,47957,48006,48594,48859,49340,49684,50824,51177,51542,51636,52024,52276,52468,52769,53604,54689,54690,54691,54693,54694,54699,54700,55409,56039,56691,57161,57211,57289,57341,57588,57589,57590,57591,57592,57593,57832,57833,57953,58832,59305,60157,60763,60787,60858,61085,61115,61116,61237,61539,62014,62101,62880,63219,64831,64832,65723,66914,67499,68113,68307,68345,68572,34833,37666,38994,41076,41868,41973,42594,43425,43775,44092,45408,45986,46126,46304,46702,47420,48212,48213,49254,49255,50105,50488,51021,51105,51846,51879,51880,53333,53750,53765,54901,54960,55021,55170,55813,57793,58738,58873,60452,61351,61868,62422,64050,67266,68203,68918,69397,39765,43055,46942,49094,49095,51008,54604,55551,55552,56639,56838,56880,59930,59966,60932,61441,63391,63507,65072,66771,66840,68890,69061,56682,56683,35107,36873,36966,38175,38220,39064,39126,39160,39333,39842,40068,40393,40721,40798,40956,41004,41517,41797,42286,42315,42622,42629,43220,43685,43689,45073,46385,46387,46757,46901,48678,48747,48858,50667,51110,51111,51115,51119,51274,51275,51276,51277,51740,51741,51850,53059,53901,54458,55134,55978,55979,55993,57182,57183,57184,57185,57186,57187,57188,57189,57190,57396,57598,57630,57709,58340,58511,59330,59839,59846,60724,61533,62152,63017,63201,63202,63547,63635,64183,64188,65624,66080,66242,66323,67566,67824,68464,68752,68753,68770,68927,69630,31111,31112,31113,31114,31115,31116,31117,31118,31119,31120,31121,36668,37574,38183,39047,39073,39275,39345,39357,40689,41086,41403,41996,42256,42369,42547,42590,42805,42955,42956,43319,43763,44022,44191,44212,44239,44763,44768,45072,45380,45457,46197,46211,46316,46577,47034,48134,48830,50210,50390,50445,50635,51012,51013,51014,51015,51016,51017,51018,51023,51024,51076,51077,51078,51079,51080,51096,51097,51098,51099,51100,51108,51109,51410,52028,52358,52554,53033,53058,54478,54702,55319,55553,56098,57134,57162,57163,57164,57165,57166,57167,57168,57169,57170,57171,57172,57173,57174,57416,58711,59108,59212,59241,59482,59548,59993,59994,60136,60365,60734,60768,61077,61612,62483,62522,62642,62943,63304,63738,64934,65608,65710,65836,65918,66006,66042,66294,66328,66492,66744,67501,67820,68693,68776,68882,69062,69134,69362,69461,69476,69503,36516,39961,41220,41221,43132,43137,45781,46985,47901,48681,49793,49794,50927,51736,55045,55138,56029,56088,57175,57176,57177,57178,57179,57198,57642,58044,58827,58831,59221,60881,62153,62355,62356,63136,64250,66545,34511,34512,34513,34514,34515,34516,34530,34531,34532,34533,42904,44199,47117,47235,47477,49395,50068,50069,50070,50071,50072,50073,50074,50075,50076,50077,50078,50079,50080,50081,50082,50083,50084,50085,50086,50087,50088,50089,50090,50091,50092,50093,50094,55009,57180,57181,57191,57192,57193,57195,57646,58040,59195,60882,61043,61044,61110,61168,62423,63051,63586,63638,64756,65167,65763,66275,66276,66576,68956,69410,69475,31524,31525,31526,34924,37678,39760,41862,42759,43603,46462,46500,46677,50668,52277,52282,55194,56867,59388,61105,64190,65027,65028,65432,66116,66645,67122,53645,35036,35037,35038,35041,35042,35043,35044,35045,35046,35047,35048,35049,35050,35051,35052,35053,35054,35055,35303,35307,35312,35314,35315,35316,35317,35321,35324,36534,36541,36555,36567,36622,37027,37028,37031,37116,38147,38630,39543,40199,40339,40404,41101,41289,41751,42029,42074,42075,42077,42313,43576,43577,43901,44277,44644,44650,45091,45101,45154,45353,45404,46345,46346,46431,46681,46916,47005,47028,47029,47485,47531,47713,48151,48359,48878,49344,49357,49358,49562,49805,49827,49847,50137,50147,50148,50662,50663,51088,51530,51698,51905,52027,52029,52036,52037,52038,52065,52066,52068,52675,53133,53313,53401,53402,53540,53565,54173,54596,54666,54668,54671,54941,55023,55026,55080,55655,55690,55695,55696,55736,55992,56026,56118,56155,56169,56170,56184,56258,56294,56419,56640,56920,57759,57760,57761,57975,57976,58045,58071,58220,58445,58552,58573,58593,58626,58663,58664,58813,58814,58815,58816,58817,58936,59120,59236,59374,59375,59752,59755,59787,60214,60278,60656,60811,60822,60855,60885,61068,61408,61503,61568,61834,62093,62567,62697,63052,63601,63743,63744,63745,63746,63747,63748,63749,63763,63764,63765,63767,63768,64138,64411,64424,64446,64677,64956,64998,65058,65060,65257,65262,65294,65295,65296,65297,65298,65299,65300,65301,65302,65303,65304,65305,65306,65307,65308,65309,65647,65670,65848,65937,66039,66040,66268,66270,66271,66286,66551,66552,66563,66564,66646,66693,66694,66695,66703,66704,66705,66706,66748,66844,66905,66906,66931,67121,67282,67323,67348,67509,67757,67759,67903,67937,68079,68233,68425,68599,68934,69120,69504,69505,69582) AND `attr_value` <> '' [ RunTime:0.075148s ]
SHOW FULL COLUMNS FROM `tp_goods_attribute` [ RunTime:0.012036s ]
SELECT `attr_id`,`attr_id`,`attr_name`,`attr_index` FROM `tp_goods_attribute` WHERE ( attr_index = 1 ) [ RunTime:0.004218s ]
SELECT * FROM `tp_goods` WHERE `goods_id` IN (31139,31140,31141,31143,31145,31147,31148,31149,31151,31152,31153,31154,31155,31156,31158,31159,33996,33997,33998,33999,34000,34001,34002,34003,34004,34005,34006,34007,34008,34009,34010,34011,34012,34013,34014,34015,34016,34018,34019,34020,34021,34022,34023,34024,34025,34028,34029,34030,34031,34032,34033,34034,34035,34037,34038,34039,34040,34041,34042,34043,34044,34045,34049,34050,34052,34053,34054,34649,34658,34660,34661,34662,34664,34665,34666,34667,34668,34669,34670,34671,34672,34673,34674,34675,34676,34677,34678,36441,36560,36882,37098,37342,37788,38324,39045,39434,39703,40229,40400,40696,41125,41980,42993,43355,43356,43999,46343,46949,46984,47070,47103,47159,47676,47929,48105,48175,48929,49370,49380,51027,52157,52497,52498,52504,52508,52530,52531,52618,52619,52620,52623,52831,52832,52834,52843,53502,53828,54329,55285,55898,57340,57658,58844,59016,59064,60853,62510,63273,63274,63290,64913,65609,65851,67231,67331,67332,67340,36540,37148,37215,37220,37263,37264,37411,37772,38109,38609,39046,39201,39634,39715,39916,40225,40230,40401,41100,41126,41127,41128,41158,41468,43177,44386,44387,45089,45151,45775,46153,46344,46562,46694,48373,48735,48932,49019,50116,50134,50601,50775,51028,51881,51969,51970,51973,51975,51977,51980,51981,51982,51984,51986,51992,51994,51997,51999,52209,52210,52211,53504,53505,53762,54048,55911,56223,57146,57945,59011,62374,64472,64671,67333,67979,67986,68466,31163,31164,31167,31172,31173,31623,31653,31662,31667,31671,31673,31676,31678,31679,31686,31688,31689,31692,31696,31697,31712,31714,31715,31719,31725,31731,31993,31994,31995,34724,35396,35413,35415,35420,35422,35426,35429,36077,36079,36080,36081,36082,36083,36084,36085,36086,36146,36156,36667,37095,37279,37346,37688,37708,37714,37807,38210,38283,38284,38285,38287,38288,38323,38384,38635,38791,38792,38888,39120,39161,39257,39277,39538,39558,39764,40460,40506,40543,40600,40668,40859,40884,41258,41259,41368,41576,42293,42322,42366,42390,42416,42588,42597,42620,42857,43000,43143,43282,44117,44313,44886,44900,44901,44902,44903,44904,44905,44906,44907,44962,46334,46671,46974,47105,47284,47677,47721,47957,48006,48594,48859,49340,49684,50824,51177,51542,51636,52024,52276,52468,52769,53604,54689,54690,54691,54693,54694,54699,54700,55409,56039,56691,57161,57211,57289,57341,57588,57589,57590,57591,57592,57593,57832,57833,57953,58832,59305,60157,60763,60787,60858,61085,61115,61116,61237,61539,62014,62101,62880,63219,64831,64832,65723,66914,67499,68113,68307,68345,68572,34833,37666,38994,41076,41868,41973,42594,43425,43775,44092,45408,45986,46126,46304,46702,47420,48212,48213,49254,49255,50105,50488,51021,51105,51846,51879,51880,53333,53750,53765,54901,54960,55021,55170,55813,57793,58738,58873,60452,61351,61868,62422,64050,67266,68203,68918,69397,39765,43055,46942,49094,49095,51008,54604,55551,55552,56639,56838,56880,59930,59966,60932,61441,63391,63507,65072,66771,66840,68890,69061,56682,56683,35107,36873,36966,38175,38220,39064,39126,39160,39333,39842,40068,40393,40721,40798,40956,41004,41517,41797,42286,42315,42622,42629,43220,43685,43689,45073,46385,46387,46757,46901,48678,48747,48858,50667,51110,51111,51115,51119,51274,51275,51276,51277,51740,51741,51850,53059,53901,54458,55134,55978,55979,55993,57182,57183,57184,57185,57186,57187,57188,57189,57190,57396,57598,57630,57709,58340,58511,59330,59839,59846,60724,61533,62152,63017,63201,63202,63547,63635,64183,64188,65624,66080,66242,66323,67566,67824,68464,68752,68753,68770,68927,69630,31111,31112,31113,31114,31115,31116,31117,31118,31119,31120,31121,36668,37574,38183,39047,39073,39275,39345,39357,40689,41086,41403,41996,42256,42369,42547,42590,42805,42955,42956,43319,43763,44022,44191,44212,44239,44763,44768,45072,45380,45457,46197,46211,46316,46577,47034,48134,48830,50210,50390,50445,50635,51012,51013,51014,51015,51016,51017,51018,51023,51024,51076,51077,51078,51079,51080,51096,51097,51098,51099,51100,51108,51109,51410,52028,52358,52554,53033,53058,54478,54702,55319,55553,56098,57134,57162,57163,57164,57165,57166,57167,57168,57169,57170,57171,57172,57173,57174,57416,58711,59108,59212,59241,59482,59548,59993,59994,60136,60365,60734,60768,61077,61612,62483,62522,62642,62943,63304,63738,64934,65608,65710,65836,65918,66006,66042,66294,66328,66492,66744,67501,67820,68693,68776,68882,69062,69134,69362,69461,69476,69503,36516,39961,41220,41221,43132,43137,45781,46985,47901,48681,49793,49794,50927,51736,55045,55138,56029,56088,57175,57176,57177,57178,57179,57198,57642,58044,58827,58831,59221,60881,62153,62355,62356,63136,64250,66545,34511,34512,34513,34514,34515,34516,34530,34531,34532,34533,42904,44199,47117,47235,47477,49395,50068,50069,50070,50071,50072,50073,50074,50075,50076,50077,50078,50079,50080,50081,50082,50083,50084,50085,50086,50087,50088,50089,50090,50091,50092,50093,50094,55009,57180,57181,57191,57192,57193,57195,57646,58040,59195,60882,61043,61044,61110,61168,62423,63051,63586,63638,64756,65167,65763,66275,66276,66576,68956,69410,69475,31524,31525,31526,34924,37678,39760,41862,42759,43603,46462,46500,46677,50668,52277,52282,55194,56867,59388,61105,64190,65027,65028,65432,66116,66645,67122,53645,35036,35037,35038,35041,35042,35043,35044,35045,35046,35047,35048,35049,35050,35051,35052,35053,35054,35055,35303,35307,35312,35314,35315,35316,35317,35321,35324,36534,36541,36555,36567,36622,37027,37028,37031,37116,38147,38630,39543,40199,40339,40404,41101,41289,41751,42029,42074,42075,42077,42313,43576,43577,43901,44277,44644,44650,45091,45101,45154,45353,45404,46345,46346,46431,46681,46916,47005,47028,47029,47485,47531,47713,48151,48359,48878,49344,49357,49358,49562,49805,49827,49847,50137,50147,50148,50662,50663,51088,51530,51698,51905,52027,52029,52036,52037,52038,52065,52066,52068,52675,53133,53313,53401,53402,53540,53565,54173,54596,54666,54668,54671,54941,55023,55026,55080,55655,55690,55695,55696,55736,55992,56026,56118,56155,56169,56170,56184,56258,56294,56419,56640,56920,57759,57760,57761,57975,57976,58045,58071,58220,58445,58552,58573,58593,58626,58663,58664,58813,58814,58815,58816,58817,58936,59120,59236,59374,59375,59752,59755,59787,60214,60278,60656,60811,60822,60855,60885,61068,61408,61503,61568,61834,62093,62567,62697,63052,63601,63743,63744,63745,63746,63747,63748,63749,63763,63764,63765,63767,63768,64138,64411,64424,64446,64677,64956,64998,65058,65060,65257,65262,65294,65295,65296,65297,65298,65299,65300,65301,65302,65303,65304,65305,65306,65307,65308,65309,65647,65670,65848,65937,66039,66040,66268,66270,66271,66286,66551,66552,66563,66564,66646,66693,66694,66695,66703,66704,66705,66706,66748,66844,66905,66906,66931,67121,67282,67323,67348,67509,67757,67759,67903,67937,68079,68233,68425,68599,68934,69120,69504,69505,69582) ORDER BY `sort` ASC LIMIT 0,10 [ RunTime:0.046934s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.011612s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (31111,31112,31113,31114,31115,31116,31117,31118,31119,31120) [ RunTime:0.012004s ]
SHOW FULL COLUMNS FROM `tp_goods_label` [ RunTime:0.003198s ]
SELECT `label_id`,`label_name` FROM `tp_goods_label` [ RunTime:0.007538s ]
SELECT `id`,`id`,`name`,`parent_id`,`level` FROM `tp_goods_category` WHERE ( is_show=1 ) [ RunTime:0.003658s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 31111 LIMIT 1 [ RunTime:0.000426s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 31112 LIMIT 1 [ RunTime:0.001308s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 31113 LIMIT 1 [ RunTime:0.002665s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 31114 LIMIT 1 [ RunTime:0.000938s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 31115 LIMIT 1 [ RunTime:0.001083s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 31116 LIMIT 1 [ RunTime:0.002704s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 31117 LIMIT 1 [ RunTime:0.000585s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 31118 LIMIT 1 [ RunTime:0.001027s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 31119 LIMIT 1 [ RunTime:0.000659s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 31120 LIMIT 1 [ RunTime:0.001393s ]
