SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.026014s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 968 LIMIT 1 [ RunTime:0.011290s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 958 ORDER BY `sort_order` DESC LIMIT 1 [ RunTime:0.079225s ]
SELECT `id`,`parent_id` FROM `tp_goods_category` [ RunTime:0.011208s ]
SELECT `id` FROM `tp_goods_category` WHERE `parent_id` = 968 [ RunTime:0.014459s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.006299s ]
SELECT `goods_id` FROM `tp_goods` WHERE `is_on_sale` = 1 AND `exchange_integral` = 0 AND `cat_id` = 968 [ RunTime:0.005650s ]
SELECT `zs_price` FROM `tp_goods` WHERE `goods_id` IN (32570,32571,32574,32576,32578,32579,32584,32590,32592,32595,32597,32598,32601,32616,32619,32622,32623,32625,35129,35130,35206,36124,36311,36317,36318,36325,36554,36617,36618,36644,36955,36964,37149,37158,37186,37802,37803,37804,37805,37824,38064,38090,38152,38176,38177,38235,38824,39038,39070,39071,39077,39137,39148,39347,39358,39464,39465,39984,40044,40168,40203,40206,40329,40685,40870,40934,40935,41053,41054,41056,41462,41940,41962,41970,42353,42651,42652,42836,42903,42942,43192,43200,43201,43317,43359,43388,43585,43586,43587,43802,43884,43891,43960,44208,44291,44369,44731,44779,44970,45219,45223,45329,45333,45334,45348,45427,45491,45562,45653,45777,45851,45947,45996,46279,46363,46364,46372,46373,46688,47077,47078,47146,47147,47402,47518,47545,47619,47771,47945,48214,48352,48364,48732,48763,48871,48873,48976,49170,49598,49840,50456,50492,50506,51089,51201,51287,51425,51625,51738,51812,51835,51921,51935,51936,51937,51938,51939,51940,51946,51948,51949,51953,51955,51956,51957,51959,51960,51961,51962,51963,51964,51965,51966,51967,51968,51971,51974,51976,51979,51983,51985,51987,51988,51989,51990,53085,53212,53639,53780,53843,54155,54193,54297,54412,54450,54781,54809,54879,55171,55783,55954,56046,56064,56166,56203,56362,56484,56565,56742,56746,56748,56754,56808,56911,57064,57088,57107,57230,57714,57790,57962,58142,58301,58405,58645,59033,59071,59072,59181,59550,59725,60635,60889,61083,61084,61708,61913,61985,62017,62020,62283,62733,62792,62885,63110,63111,63328,63351,63913,64145,65411,65661,66178,66232,66390,66422,66472,66765,66876,66913,68141,68271,68668,68906,68907,68953,69021,69238,69324,69378,69379,69513) [ RunTime:0.010380s ]
SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` IN (32570,32571,32574,32576,32578,32579,32584,32590,32592,32595,32597,32598,32601,32616,32619,32622,32623,32625,35129,35130,35206,36124,36311,36317,36318,36325,36554,36617,36618,36644,36955,36964,37149,37158,37186,37802,37803,37804,37805,37824,38064,38090,38152,38176,38177,38235,38824,39038,39070,39071,39077,39137,39148,39347,39358,39464,39465,39984,40044,40168,40203,40206,40329,40685,40870,40934,40935,41053,41054,41056,41462,41940,41962,41970,42353,42651,42652,42836,42903,42942,43192,43200,43201,43317,43359,43388,43585,43586,43587,43802,43884,43891,43960,44208,44291,44369,44731,44779,44970,45219,45223,45329,45333,45334,45348,45427,45491,45562,45653,45777,45851,45947,45996,46279,46363,46364,46372,46373,46688,47077,47078,47146,47147,47402,47518,47545,47619,47771,47945,48214,48352,48364,48732,48763,48871,48873,48976,49170,49598,49840,50456,50492,50506,51089,51201,51287,51425,51625,51738,51812,51835,51921,51935,51936,51937,51938,51939,51940,51946,51948,51949,51953,51955,51956,51957,51959,51960,51961,51962,51963,51964,51965,51966,51967,51968,51971,51974,51976,51979,51983,51985,51987,51988,51989,51990,53085,53212,53639,53780,53843,54155,54193,54297,54412,54450,54781,54809,54879,55171,55783,55954,56046,56064,56166,56203,56362,56484,56565,56742,56746,56748,56754,56808,56911,57064,57088,57107,57230,57714,57790,57962,58142,58301,58405,58645,59033,59071,59072,59181,59550,59725,60635,60889,61083,61084,61708,61913,61985,62017,62020,62283,62733,62792,62885,63110,63111,63328,63351,63913,64145,65411,65661,66178,66232,66390,66422,66472,66765,66876,66913,68141,68271,68668,68906,68907,68953,69021,69238,69324,69378,69379,69513) AND `brand_id` > 0 [ RunTime:0.023057s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.020782s ]
SELECT * FROM `tp_brand` WHERE `id` IN (4532,4479,5023,4902,5092,5391,4435,5230,5231,4536,5457,5029,6065,6629,5103,4847,4535,6544,4738,4480,6713,5085,4440,5763,4534,6634,7737,4568,5275,4541,7362,6054,5237,7139,5054) GROUP BY `name` LIMIT 30 [ RunTime:0.008557s ]
select group_concat(`key` separator '_') as `key` from tp_spec_goods_price where goods_id in(32570,32571,32574,32576,32578,32579,32584,32590,32592,32595,32597,32598,32601,32616,32619,32622,32623,32625,35129,35130,35206,36124,36311,36317,36318,36325,36554,36617,36618,36644,36955,36964,37149,37158,37186,37802,37803,37804,37805,37824,38064,38090,38152,38176,38177,38235,38824,39038,39070,39071,39077,39137,39148,39347,39358,39464,39465,39984,40044,40168,40203,40206,40329,40685,40870,40934,40935,41053,41054,41056,41462,41940,41962,41970,42353,42651,42652,42836,42903,42942,43192,43200,43201,43317,43359,43388,43585,43586,43587,43802,43884,43891,43960,44208,44291,44369,44731,44779,44970,45219,45223,45329,45333,45334,45348,45427,45491,45562,45653,45777,45851,45947,45996,46279,46363,46364,46372,46373,46688,47077,47078,47146,47147,47402,47518,47545,47619,47771,47945,48214,48352,48364,48732,48763,48871,48873,48976,49170,49598,49840,50456,50492,50506,51089,51201,51287,51425,51625,51738,51812,51835,51921,51935,51936,51937,51938,51939,51940,51946,51948,51949,51953,51955,51956,51957,51959,51960,51961,51962,51963,51964,51965,51966,51967,51968,51971,51974,51976,51979,51983,51985,51987,51988,51989,51990,53085,53212,53639,53780,53843,54155,54193,54297,54412,54450,54781,54809,54879,55171,55783,55954,56046,56064,56166,56203,56362,56484,56565,56742,56746,56748,56754,56808,56911,57064,57088,57107,57230,57714,57790,57962,58142,58301,58405,58645,59033,59071,59072,59181,59550,59725,60635,60889,61083,61084,61708,61913,61985,62017,62020,62283,62733,62792,62885,63110,63111,63328,63351,63913,64145,65411,65661,66178,66232,66390,66422,66472,66765,66876,66913,68141,68271,68668,68906,68907,68953,69021,69238,69324,69378,69379,69513) [ RunTime:0.008697s ]
SHOW FULL COLUMNS FROM `tp_goods_attr` [ RunTime:0.006103s ]
SELECT * FROM `tp_goods_attr` WHERE `goods_id` IN (32570,32571,32574,32576,32578,32579,32584,32590,32592,32595,32597,32598,32601,32616,32619,32622,32623,32625,35129,35130,35206,36124,36311,36317,36318,36325,36554,36617,36618,36644,36955,36964,37149,37158,37186,37802,37803,37804,37805,37824,38064,38090,38152,38176,38177,38235,38824,39038,39070,39071,39077,39137,39148,39347,39358,39464,39465,39984,40044,40168,40203,40206,40329,40685,40870,40934,40935,41053,41054,41056,41462,41940,41962,41970,42353,42651,42652,42836,42903,42942,43192,43200,43201,43317,43359,43388,43585,43586,43587,43802,43884,43891,43960,44208,44291,44369,44731,44779,44970,45219,45223,45329,45333,45334,45348,45427,45491,45562,45653,45777,45851,45947,45996,46279,46363,46364,46372,46373,46688,47077,47078,47146,47147,47402,47518,47545,47619,47771,47945,48214,48352,48364,48732,48763,48871,48873,48976,49170,49598,49840,50456,50492,50506,51089,51201,51287,51425,51625,51738,51812,51835,51921,51935,51936,51937,51938,51939,51940,51946,51948,51949,51953,51955,51956,51957,51959,51960,51961,51962,51963,51964,51965,51966,51967,51968,51971,51974,51976,51979,51983,51985,51987,51988,51989,51990,53085,53212,53639,53780,53843,54155,54193,54297,54412,54450,54781,54809,54879,55171,55783,55954,56046,56064,56166,56203,56362,56484,56565,56742,56746,56748,56754,56808,56911,57064,57088,57107,57230,57714,57790,57962,58142,58301,58405,58645,59033,59071,59072,59181,59550,59725,60635,60889,61083,61084,61708,61913,61985,62017,62020,62283,62733,62792,62885,63110,63111,63328,63351,63913,64145,65411,65661,66178,66232,66390,66422,66472,66765,66876,66913,68141,68271,68668,68906,68907,68953,69021,69238,69324,69378,69379,69513) AND `attr_value` <> '' [ RunTime:0.012178s ]
SHOW FULL COLUMNS FROM `tp_goods_attribute` [ RunTime:0.054775s ]
SELECT `attr_id`,`attr_id`,`attr_name`,`attr_index` FROM `tp_goods_attribute` WHERE ( attr_index = 1 ) [ RunTime:0.009217s ]
SELECT * FROM `tp_goods` WHERE `goods_id` IN (32570,32571,32574,32576,32578,32579,32584,32590,32592,32595,32597,32598,32601,32616,32619,32622,32623,32625,35129,35130,35206,36124,36311,36317,36318,36325,36554,36617,36618,36644,36955,36964,37149,37158,37186,37802,37803,37804,37805,37824,38064,38090,38152,38176,38177,38235,38824,39038,39070,39071,39077,39137,39148,39347,39358,39464,39465,39984,40044,40168,40203,40206,40329,40685,40870,40934,40935,41053,41054,41056,41462,41940,41962,41970,42353,42651,42652,42836,42903,42942,43192,43200,43201,43317,43359,43388,43585,43586,43587,43802,43884,43891,43960,44208,44291,44369,44731,44779,44970,45219,45223,45329,45333,45334,45348,45427,45491,45562,45653,45777,45851,45947,45996,46279,46363,46364,46372,46373,46688,47077,47078,47146,47147,47402,47518,47545,47619,47771,47945,48214,48352,48364,48732,48763,48871,48873,48976,49170,49598,49840,50456,50492,50506,51089,51201,51287,51425,51625,51738,51812,51835,51921,51935,51936,51937,51938,51939,51940,51946,51948,51949,51953,51955,51956,51957,51959,51960,51961,51962,51963,51964,51965,51966,51967,51968,51971,51974,51976,51979,51983,51985,51987,51988,51989,51990,53085,53212,53639,53780,53843,54155,54193,54297,54412,54450,54781,54809,54879,55171,55783,55954,56046,56064,56166,56203,56362,56484,56565,56742,56746,56748,56754,56808,56911,57064,57088,57107,57230,57714,57790,57962,58142,58301,58405,58645,59033,59071,59072,59181,59550,59725,60635,60889,61083,61084,61708,61913,61985,62017,62020,62283,62733,62792,62885,63110,63111,63328,63351,63913,64145,65411,65661,66178,66232,66390,66422,66472,66765,66876,66913,68141,68271,68668,68906,68907,68953,69021,69238,69324,69378,69379,69513) ORDER BY `sort` ASC LIMIT 0,10 [ RunTime:0.049016s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.036926s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (32570,32571,32574,32576,32578,32579,32584,32590,32592,32595) [ RunTime:0.011101s ]
SHOW FULL COLUMNS FROM `tp_goods_label` [ RunTime:0.008185s ]
SELECT `label_id`,`label_name` FROM `tp_goods_label` [ RunTime:0.004938s ]
SELECT `id`,`id`,`name`,`parent_id`,`level` FROM `tp_goods_category` WHERE ( is_show=1 ) [ RunTime:0.004108s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32570 LIMIT 1 [ RunTime:0.025767s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32571 LIMIT 1 [ RunTime:0.014560s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32574 LIMIT 1 [ RunTime:0.008250s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32576 LIMIT 1 [ RunTime:0.006692s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32578 LIMIT 1 [ RunTime:0.005343s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32579 LIMIT 1 [ RunTime:0.004098s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32584 LIMIT 1 [ RunTime:0.007394s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32590 LIMIT 1 [ RunTime:0.004276s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32592 LIMIT 1 [ RunTime:0.005083s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32595 LIMIT 1 [ RunTime:0.008251s ]
