SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.000436s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 959 LIMIT 1 [ RunTime:0.000180s ]
SELECT `id`,`parent_id` FROM `tp_goods_category` [ RunTime:0.000350s ]
SELECT `id` FROM `tp_goods_category` WHERE `parent_id` = 959 [ RunTime:0.000134s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.000562s ]
SELECT `goods_id` FROM `tp_goods` WHERE `is_on_sale` = 1 AND `exchange_integral` = 0 AND `cat_id` IN (959,974,975,976) [ RunTime:0.001028s ]
SELECT `zs_price` FROM `tp_goods` WHERE `goods_id` IN (32509,32511,32513,32529,32530,32531,32535,32538,32541,32542,32544,32545,36183,36345,37277,38141,39043,39044,39348,39351,39352,39360,40046,40103,42787,42788,45235,45366,46104,46335,46909,47075,47577,47584,47661,47717,49384,50251,50408,52551,52808,53941,54812,54813,54814,54815,56765,57252,57506,58370,59909,60783,61079,61297,61577,62294,62663,62664,65049,65849,66650,67330,32091,32095,32097,32100,32103,32104,32105,32114,32119,32121,32123,32125,32126,32127,32128,32130,32139,32140,32142,32143,32147,32148,32150,36246,36813,37191,37677,37692,37734,37792,37801,37814,37816,38219,38221,38403,38603,38607,38624,38821,39013,39053,39570,39705,39718,39780,39853,40085,40161,40162,40420,40454,40455,40588,40633,40649,41200,41429,41639,42233,42559,42709,42776,42864,43568,43657,43742,43753,43832,43833,44036,44078,44109,44112,44128,44204,44225,44345,44428,44429,44518,44548,44674,44958,45275,45282,45630,45639,45640,45641,45643,45702,45769,46037,46199,46239,46286,46299,46551,46596,46636,46753,46770,46771,46793,46796,46805,46845,47429,47446,47745,47927,47928,47938,47944,48375,48430,48589,48597,48822,48829,48892,49007,49044,49201,49399,49463,49500,49519,49524,49645,49800,49823,49824,49870,50467,50468,50557,50558,50654,50838,50867,50942,51453,51564,51797,52043,52064,52075,52114,52129,52223,52302,52336,52573,52648,52707,52919,53092,53094,53098,53099,53102,53126,53127,53128,53129,53130,53131,53137,53138,53139,53140,53149,53150,53151,53152,53162,53163,53176,53187,53211,53230,53383,53450,53453,53609,53656,53691,54003,54011,54183,54326,54481,54919,54926,54978,55297,56326,56352,56477,56511,56873,56902,56903,56909,57412,57583,57954,57958,57970,57971,57983,58003,58342,58344,58345,58431,58642,58650,58782,58808,59206,59858,60192,60222,60661,61164,61456,61589,62383,63143,63146,63263,63506,63664,63782,64326,64653,65348,65370,65777,66072,66194,66269,66770,66792,66928,67583,67771,67799,67815,68120,68656,68932,68947,69034,69135,69295,69478) [ RunTime:0.001771s ]
SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` IN (32509,32511,32513,32529,32530,32531,32535,32538,32541,32542,32544,32545,36183,36345,37277,38141,39043,39044,39348,39351,39352,39360,40046,40103,42787,42788,45235,45366,46104,46335,46909,47075,47577,47584,47661,47717,49384,50251,50408,52551,52808,53941,54812,54813,54814,54815,56765,57252,57506,58370,59909,60783,61079,61297,61577,62294,62663,62664,65049,65849,66650,67330,32091,32095,32097,32100,32103,32104,32105,32114,32119,32121,32123,32125,32126,32127,32128,32130,32139,32140,32142,32143,32147,32148,32150,36246,36813,37191,37677,37692,37734,37792,37801,37814,37816,38219,38221,38403,38603,38607,38624,38821,39013,39053,39570,39705,39718,39780,39853,40085,40161,40162,40420,40454,40455,40588,40633,40649,41200,41429,41639,42233,42559,42709,42776,42864,43568,43657,43742,43753,43832,43833,44036,44078,44109,44112,44128,44204,44225,44345,44428,44429,44518,44548,44674,44958,45275,45282,45630,45639,45640,45641,45643,45702,45769,46037,46199,46239,46286,46299,46551,46596,46636,46753,46770,46771,46793,46796,46805,46845,47429,47446,47745,47927,47928,47938,47944,48375,48430,48589,48597,48822,48829,48892,49007,49044,49201,49399,49463,49500,49519,49524,49645,49800,49823,49824,49870,50467,50468,50557,50558,50654,50838,50867,50942,51453,51564,51797,52043,52064,52075,52114,52129,52223,52302,52336,52573,52648,52707,52919,53092,53094,53098,53099,53102,53126,53127,53128,53129,53130,53131,53137,53138,53139,53140,53149,53150,53151,53152,53162,53163,53176,53187,53211,53230,53383,53450,53453,53609,53656,53691,54003,54011,54183,54326,54481,54919,54926,54978,55297,56326,56352,56477,56511,56873,56902,56903,56909,57412,57583,57954,57958,57970,57971,57983,58003,58342,58344,58345,58431,58642,58650,58782,58808,59206,59858,60192,60222,60661,61164,61456,61589,62383,63143,63146,63263,63506,63664,63782,64326,64653,65348,65370,65777,66072,66194,66269,66770,66792,66928,67583,67771,67799,67815,68120,68656,68932,68947,69034,69135,69295,69478) AND `brand_id` > 0 [ RunTime:0.001777s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.000404s ]
SELECT * FROM `tp_brand` WHERE `id` IN (4794,4619,4796,4515,4797,4520,4463,4523,4518,4519,4767,4853,4854,4826,5103,4513,5065,4902,4514,5390,4517,5439,4941,5610,4576,5682,6014,6203,6556,5902,4830,6586,6223,5574,7182,5265,6874,6878,4911,4454,7437,4508,7499,5133,6753,7004,7066,5209,7441,5236,5300,5051,6634,5275,6633,4769,5057,8083,4460,4521) GROUP BY `name` LIMIT 30 [ RunTime:0.000915s ]
select group_concat(`key` separator '_') as `key` from tp_spec_goods_price where goods_id in(32509,32511,32513,32529,32530,32531,32535,32538,32541,32542,32544,32545,36183,36345,37277,38141,39043,39044,39348,39351,39352,39360,40046,40103,42787,42788,45235,45366,46104,46335,46909,47075,47577,47584,47661,47717,49384,50251,50408,52551,52808,53941,54812,54813,54814,54815,56765,57252,57506,58370,59909,60783,61079,61297,61577,62294,62663,62664,65049,65849,66650,67330,32091,32095,32097,32100,32103,32104,32105,32114,32119,32121,32123,32125,32126,32127,32128,32130,32139,32140,32142,32143,32147,32148,32150,36246,36813,37191,37677,37692,37734,37792,37801,37814,37816,38219,38221,38403,38603,38607,38624,38821,39013,39053,39570,39705,39718,39780,39853,40085,40161,40162,40420,40454,40455,40588,40633,40649,41200,41429,41639,42233,42559,42709,42776,42864,43568,43657,43742,43753,43832,43833,44036,44078,44109,44112,44128,44204,44225,44345,44428,44429,44518,44548,44674,44958,45275,45282,45630,45639,45640,45641,45643,45702,45769,46037,46199,46239,46286,46299,46551,46596,46636,46753,46770,46771,46793,46796,46805,46845,47429,47446,47745,47927,47928,47938,47944,48375,48430,48589,48597,48822,48829,48892,49007,49044,49201,49399,49463,49500,49519,49524,49645,49800,49823,49824,49870,50467,50468,50557,50558,50654,50838,50867,50942,51453,51564,51797,52043,52064,52075,52114,52129,52223,52302,52336,52573,52648,52707,52919,53092,53094,53098,53099,53102,53126,53127,53128,53129,53130,53131,53137,53138,53139,53140,53149,53150,53151,53152,53162,53163,53176,53187,53211,53230,53383,53450,53453,53609,53656,53691,54003,54011,54183,54326,54481,54919,54926,54978,55297,56326,56352,56477,56511,56873,56902,56903,56909,57412,57583,57954,57958,57970,57971,57983,58003,58342,58344,58345,58431,58642,58650,58782,58808,59206,59858,60192,60222,60661,61164,61456,61589,62383,63143,63146,63263,63506,63664,63782,64326,64653,65348,65370,65777,66072,66194,66269,66770,66792,66928,67583,67771,67799,67815,68120,68656,68932,68947,69034,69135,69295,69478) [ RunTime:0.000376s ]
SHOW FULL COLUMNS FROM `tp_goods_attr` [ RunTime:0.000329s ]
SELECT * FROM `tp_goods_attr` WHERE `goods_id` IN (32509,32511,32513,32529,32530,32531,32535,32538,32541,32542,32544,32545,36183,36345,37277,38141,39043,39044,39348,39351,39352,39360,40046,40103,42787,42788,45235,45366,46104,46335,46909,47075,47577,47584,47661,47717,49384,50251,50408,52551,52808,53941,54812,54813,54814,54815,56765,57252,57506,58370,59909,60783,61079,61297,61577,62294,62663,62664,65049,65849,66650,67330,32091,32095,32097,32100,32103,32104,32105,32114,32119,32121,32123,32125,32126,32127,32128,32130,32139,32140,32142,32143,32147,32148,32150,36246,36813,37191,37677,37692,37734,37792,37801,37814,37816,38219,38221,38403,38603,38607,38624,38821,39013,39053,39570,39705,39718,39780,39853,40085,40161,40162,40420,40454,40455,40588,40633,40649,41200,41429,41639,42233,42559,42709,42776,42864,43568,43657,43742,43753,43832,43833,44036,44078,44109,44112,44128,44204,44225,44345,44428,44429,44518,44548,44674,44958,45275,45282,45630,45639,45640,45641,45643,45702,45769,46037,46199,46239,46286,46299,46551,46596,46636,46753,46770,46771,46793,46796,46805,46845,47429,47446,47745,47927,47928,47938,47944,48375,48430,48589,48597,48822,48829,48892,49007,49044,49201,49399,49463,49500,49519,49524,49645,49800,49823,49824,49870,50467,50468,50557,50558,50654,50838,50867,50942,51453,51564,51797,52043,52064,52075,52114,52129,52223,52302,52336,52573,52648,52707,52919,53092,53094,53098,53099,53102,53126,53127,53128,53129,53130,53131,53137,53138,53139,53140,53149,53150,53151,53152,53162,53163,53176,53187,53211,53230,53383,53450,53453,53609,53656,53691,54003,54011,54183,54326,54481,54919,54926,54978,55297,56326,56352,56477,56511,56873,56902,56903,56909,57412,57583,57954,57958,57970,57971,57983,58003,58342,58344,58345,58431,58642,58650,58782,58808,59206,59858,60192,60222,60661,61164,61456,61589,62383,63143,63146,63263,63506,63664,63782,64326,64653,65348,65370,65777,66072,66194,66269,66770,66792,66928,67583,67771,67799,67815,68120,68656,68932,68947,69034,69135,69295,69478) AND `attr_value` <> '' [ RunTime:0.002135s ]
SHOW FULL COLUMNS FROM `tp_goods_attribute` [ RunTime:0.000390s ]
SELECT `attr_id`,`attr_id`,`attr_name`,`attr_index` FROM `tp_goods_attribute` WHERE ( attr_index = 1 ) [ RunTime:0.000124s ]
SELECT * FROM `tp_goods` WHERE `goods_id` IN (32509,32511,32513,32529,32530,32531,32535,32538,32541,32542,32544,32545,36183,36345,37277,38141,39043,39044,39348,39351,39352,39360,40046,40103,42787,42788,45235,45366,46104,46335,46909,47075,47577,47584,47661,47717,49384,50251,50408,52551,52808,53941,54812,54813,54814,54815,56765,57252,57506,58370,59909,60783,61079,61297,61577,62294,62663,62664,65049,65849,66650,67330,32091,32095,32097,32100,32103,32104,32105,32114,32119,32121,32123,32125,32126,32127,32128,32130,32139,32140,32142,32143,32147,32148,32150,36246,36813,37191,37677,37692,37734,37792,37801,37814,37816,38219,38221,38403,38603,38607,38624,38821,39013,39053,39570,39705,39718,39780,39853,40085,40161,40162,40420,40454,40455,40588,40633,40649,41200,41429,41639,42233,42559,42709,42776,42864,43568,43657,43742,43753,43832,43833,44036,44078,44109,44112,44128,44204,44225,44345,44428,44429,44518,44548,44674,44958,45275,45282,45630,45639,45640,45641,45643,45702,45769,46037,46199,46239,46286,46299,46551,46596,46636,46753,46770,46771,46793,46796,46805,46845,47429,47446,47745,47927,47928,47938,47944,48375,48430,48589,48597,48822,48829,48892,49007,49044,49201,49399,49463,49500,49519,49524,49645,49800,49823,49824,49870,50467,50468,50557,50558,50654,50838,50867,50942,51453,51564,51797,52043,52064,52075,52114,52129,52223,52302,52336,52573,52648,52707,52919,53092,53094,53098,53099,53102,53126,53127,53128,53129,53130,53131,53137,53138,53139,53140,53149,53150,53151,53152,53162,53163,53176,53187,53211,53230,53383,53450,53453,53609,53656,53691,54003,54011,54183,54326,54481,54919,54926,54978,55297,56326,56352,56477,56511,56873,56902,56903,56909,57412,57583,57954,57958,57970,57971,57983,58003,58342,58344,58345,58431,58642,58650,58782,58808,59206,59858,60192,60222,60661,61164,61456,61589,62383,63143,63146,63263,63506,63664,63782,64326,64653,65348,65370,65777,66072,66194,66269,66770,66792,66928,67583,67771,67799,67815,68120,68656,68932,68947,69034,69135,69295,69478) ORDER BY `sort` ASC LIMIT 0,10 [ RunTime:0.002807s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.000370s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (32091,32095,32097,32100,32103,32104,32105,32114,32119,32121) [ RunTime:0.000617s ]
SHOW FULL COLUMNS FROM `tp_goods_label` [ RunTime:0.000333s ]
SELECT `label_id`,`label_name` FROM `tp_goods_label` [ RunTime:0.000105s ]
SELECT `id`,`id`,`name`,`parent_id`,`level` FROM `tp_goods_category` WHERE ( is_show=1 ) [ RunTime:0.000173s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32091 LIMIT 1 [ RunTime:0.000231s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32095 LIMIT 1 [ RunTime:0.000151s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32097 LIMIT 1 [ RunTime:0.000149s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32100 LIMIT 1 [ RunTime:0.000152s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32103 LIMIT 1 [ RunTime:0.000156s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32104 LIMIT 1 [ RunTime:0.000148s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32105 LIMIT 1 [ RunTime:0.000169s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32114 LIMIT 1 [ RunTime:0.000398s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32119 LIMIT 1 [ RunTime:0.000210s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32121 LIMIT 1 [ RunTime:0.000152s ]
