SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.000613s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 984 LIMIT 1 [ RunTime:0.000189s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 960 ORDER BY `sort_order` DESC LIMIT 1 [ RunTime:0.000221s ]
SELECT `id`,`parent_id` FROM `tp_goods_category` [ RunTime:0.000383s ]
SELECT `id` FROM `tp_goods_category` WHERE `parent_id` = 984 [ RunTime:0.000563s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.000906s ]
SELECT `goods_id` FROM `tp_goods` WHERE `is_on_sale` = 1 AND `exchange_integral` = 0 AND `cat_id` = 984 [ RunTime:0.001040s ]
SELECT `zs_price` FROM `tp_goods` WHERE `goods_id` IN (30962,30963,34150,34577,34841,34879,34883,35003,36240,36250,36319,36536,36671,36789,36937,36945,37045,37143,37268,37427,37722,37832,38056,38238,38244,38281,38357,38385,38432,38858,39061,39076,39098,39152,39240,39389,39428,39518,40047,40104,40121,40130,40208,40272,40354,40383,40526,40590,40599,40621,40875,40877,40921,40966,41061,41063,41089,41370,41371,41493,41826,41997,42033,42361,42568,42706,42888,43265,43270,43283,43366,43392,43490,43591,43592,43593,43731,43732,43743,43926,43932,43998,44027,44081,44084,44305,44330,44790,44791,45028,45169,45355,45402,45456,45960,46000,46119,46120,46137,46430,46528,46579,46844,46914,46920,47110,47194,47195,47418,47448,47513,47552,47671,47989,48117,48118,48152,48187,48259,48271,48339,48402,48456,48619,48701,48832,48931,48941,49093,49199,49208,49227,49247,49373,49485,49750,49776,49816,49871,49957,50242,50352,50929,50971,51217,51708,51833,51839,51840,51941,52047,52057,52058,52059,52139,52179,52180,52200,52281,52324,52512,52676,52761,52798,53010,53218,53328,53438,53532,53783,53784,53785,53786,53787,53807,53808,53809,53810,53811,53823,53894,54231,54289,54291,54292,54375,54376,54377,54378,54379,54380,54381,54394,54523,54524,54768,54913,55022,55114,55132,55529,55578,55579,55582,55634,55711,55737,55738,55741,55745,55797,55899,55902,55904,55907,55908,55913,55926,55947,56249,56292,56645,56646,56658,56732,56734,56822,56932,57116,57388,57391,57428,57570,57621,57641,57670,57703,57866,57919,58037,58038,58114,58280,58281,58695,59189,59325,59428,59434,59727,59799,60033,60240,60264,60292,60418,60780,60785,60999,61265,61322,61889,62316,62847,62924,63393,63413,63519,63732,63733,63734,64078,64079,64319,64321,64322,64325,64327,64328,64329,64330,64334,64335,64430,64468,64475,64482,64553,64614,64624,64625,64744,64745,65075,65077,65143,65255,65374,65821,65893,65977,65992,65994,66064,66321,66322,66577,66606,67119,67342,67424,67484,67497,67517,67590,67672,67746,68021,68285,68418,68419,68504,68505,68506,68507,68511,68512,68513,68514,68515,68517,68524,68525,68531,68538,68641,68669,68673,68703,68704,68705,68706,68708,68709,68710,68891,68892,68994,68996,69002,69047,69069,69075,69252,69267,69343,69368,69369,69370,69371,69372,69373,69421,69422,69423,69424,69425,69490,69528) [ RunTime:0.002588s ]
SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` IN (30962,30963,34150,34577,34841,34879,34883,35003,36240,36250,36319,36536,36671,36789,36937,36945,37045,37143,37268,37427,37722,37832,38056,38238,38244,38281,38357,38385,38432,38858,39061,39076,39098,39152,39240,39389,39428,39518,40047,40104,40121,40130,40208,40272,40354,40383,40526,40590,40599,40621,40875,40877,40921,40966,41061,41063,41089,41370,41371,41493,41826,41997,42033,42361,42568,42706,42888,43265,43270,43283,43366,43392,43490,43591,43592,43593,43731,43732,43743,43926,43932,43998,44027,44081,44084,44305,44330,44790,44791,45028,45169,45355,45402,45456,45960,46000,46119,46120,46137,46430,46528,46579,46844,46914,46920,47110,47194,47195,47418,47448,47513,47552,47671,47989,48117,48118,48152,48187,48259,48271,48339,48402,48456,48619,48701,48832,48931,48941,49093,49199,49208,49227,49247,49373,49485,49750,49776,49816,49871,49957,50242,50352,50929,50971,51217,51708,51833,51839,51840,51941,52047,52057,52058,52059,52139,52179,52180,52200,52281,52324,52512,52676,52761,52798,53010,53218,53328,53438,53532,53783,53784,53785,53786,53787,53807,53808,53809,53810,53811,53823,53894,54231,54289,54291,54292,54375,54376,54377,54378,54379,54380,54381,54394,54523,54524,54768,54913,55022,55114,55132,55529,55578,55579,55582,55634,55711,55737,55738,55741,55745,55797,55899,55902,55904,55907,55908,55913,55926,55947,56249,56292,56645,56646,56658,56732,56734,56822,56932,57116,57388,57391,57428,57570,57621,57641,57670,57703,57866,57919,58037,58038,58114,58280,58281,58695,59189,59325,59428,59434,59727,59799,60033,60240,60264,60292,60418,60780,60785,60999,61265,61322,61889,62316,62847,62924,63393,63413,63519,63732,63733,63734,64078,64079,64319,64321,64322,64325,64327,64328,64329,64330,64334,64335,64430,64468,64475,64482,64553,64614,64624,64625,64744,64745,65075,65077,65143,65255,65374,65821,65893,65977,65992,65994,66064,66321,66322,66577,66606,67119,67342,67424,67484,67497,67517,67590,67672,67746,68021,68285,68418,68419,68504,68505,68506,68507,68511,68512,68513,68514,68515,68517,68524,68525,68531,68538,68641,68669,68673,68703,68704,68705,68706,68708,68709,68710,68891,68892,68994,68996,69002,69047,69069,69075,69252,69267,69343,69368,69369,69370,69371,69372,69373,69421,69422,69423,69424,69425,69490,69528) AND `brand_id` > 0 [ RunTime:0.002599s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.000462s ]
SELECT * FROM `tp_brand` WHERE `id` IN (4460,5068,4619,5002,4482,4462,4949,4575,4917,4450,5165,5504,4449,4476,5297,4769,4944,4629,5523,4478,5603,5630,5207,5679,6375,5455,4517,4911,6082,6266,6272,5326,6319,6485,4738,7035,5348,4524,5516,7182,6714,6809,6820,5489,6840,4576,6857,6879,5044,7455,4466,7139,6994,6995,7631,7629,6998,4569,7011,5098,6749,4437,7654,6050,7216,7745,5825,6654,7930,7988,4538,4793,6089,6661,8035,5292,6993,5783,8080,6412,7338,7895,8122,5201,8137,4474,8139,8140) GROUP BY `name` LIMIT 30 [ RunTime:0.001202s ]
select group_concat(`key` separator '_') as `key` from tp_spec_goods_price where goods_id in(30962,30963,34150,34577,34841,34879,34883,35003,36240,36250,36319,36536,36671,36789,36937,36945,37045,37143,37268,37427,37722,37832,38056,38238,38244,38281,38357,38385,38432,38858,39061,39076,39098,39152,39240,39389,39428,39518,40047,40104,40121,40130,40208,40272,40354,40383,40526,40590,40599,40621,40875,40877,40921,40966,41061,41063,41089,41370,41371,41493,41826,41997,42033,42361,42568,42706,42888,43265,43270,43283,43366,43392,43490,43591,43592,43593,43731,43732,43743,43926,43932,43998,44027,44081,44084,44305,44330,44790,44791,45028,45169,45355,45402,45456,45960,46000,46119,46120,46137,46430,46528,46579,46844,46914,46920,47110,47194,47195,47418,47448,47513,47552,47671,47989,48117,48118,48152,48187,48259,48271,48339,48402,48456,48619,48701,48832,48931,48941,49093,49199,49208,49227,49247,49373,49485,49750,49776,49816,49871,49957,50242,50352,50929,50971,51217,51708,51833,51839,51840,51941,52047,52057,52058,52059,52139,52179,52180,52200,52281,52324,52512,52676,52761,52798,53010,53218,53328,53438,53532,53783,53784,53785,53786,53787,53807,53808,53809,53810,53811,53823,53894,54231,54289,54291,54292,54375,54376,54377,54378,54379,54380,54381,54394,54523,54524,54768,54913,55022,55114,55132,55529,55578,55579,55582,55634,55711,55737,55738,55741,55745,55797,55899,55902,55904,55907,55908,55913,55926,55947,56249,56292,56645,56646,56658,56732,56734,56822,56932,57116,57388,57391,57428,57570,57621,57641,57670,57703,57866,57919,58037,58038,58114,58280,58281,58695,59189,59325,59428,59434,59727,59799,60033,60240,60264,60292,60418,60780,60785,60999,61265,61322,61889,62316,62847,62924,63393,63413,63519,63732,63733,63734,64078,64079,64319,64321,64322,64325,64327,64328,64329,64330,64334,64335,64430,64468,64475,64482,64553,64614,64624,64625,64744,64745,65075,65077,65143,65255,65374,65821,65893,65977,65992,65994,66064,66321,66322,66577,66606,67119,67342,67424,67484,67497,67517,67590,67672,67746,68021,68285,68418,68419,68504,68505,68506,68507,68511,68512,68513,68514,68515,68517,68524,68525,68531,68538,68641,68669,68673,68703,68704,68705,68706,68708,68709,68710,68891,68892,68994,68996,69002,69047,69069,69075,69252,69267,69343,69368,69369,69370,69371,69372,69373,69421,69422,69423,69424,69425,69490,69528) [ RunTime:0.000383s ]
SHOW FULL COLUMNS FROM `tp_goods_attr` [ RunTime:0.000651s ]
SELECT * FROM `tp_goods_attr` WHERE `goods_id` IN (30962,30963,34150,34577,34841,34879,34883,35003,36240,36250,36319,36536,36671,36789,36937,36945,37045,37143,37268,37427,37722,37832,38056,38238,38244,38281,38357,38385,38432,38858,39061,39076,39098,39152,39240,39389,39428,39518,40047,40104,40121,40130,40208,40272,40354,40383,40526,40590,40599,40621,40875,40877,40921,40966,41061,41063,41089,41370,41371,41493,41826,41997,42033,42361,42568,42706,42888,43265,43270,43283,43366,43392,43490,43591,43592,43593,43731,43732,43743,43926,43932,43998,44027,44081,44084,44305,44330,44790,44791,45028,45169,45355,45402,45456,45960,46000,46119,46120,46137,46430,46528,46579,46844,46914,46920,47110,47194,47195,47418,47448,47513,47552,47671,47989,48117,48118,48152,48187,48259,48271,48339,48402,48456,48619,48701,48832,48931,48941,49093,49199,49208,49227,49247,49373,49485,49750,49776,49816,49871,49957,50242,50352,50929,50971,51217,51708,51833,51839,51840,51941,52047,52057,52058,52059,52139,52179,52180,52200,52281,52324,52512,52676,52761,52798,53010,53218,53328,53438,53532,53783,53784,53785,53786,53787,53807,53808,53809,53810,53811,53823,53894,54231,54289,54291,54292,54375,54376,54377,54378,54379,54380,54381,54394,54523,54524,54768,54913,55022,55114,55132,55529,55578,55579,55582,55634,55711,55737,55738,55741,55745,55797,55899,55902,55904,55907,55908,55913,55926,55947,56249,56292,56645,56646,56658,56732,56734,56822,56932,57116,57388,57391,57428,57570,57621,57641,57670,57703,57866,57919,58037,58038,58114,58280,58281,58695,59189,59325,59428,59434,59727,59799,60033,60240,60264,60292,60418,60780,60785,60999,61265,61322,61889,62316,62847,62924,63393,63413,63519,63732,63733,63734,64078,64079,64319,64321,64322,64325,64327,64328,64329,64330,64334,64335,64430,64468,64475,64482,64553,64614,64624,64625,64744,64745,65075,65077,65143,65255,65374,65821,65893,65977,65992,65994,66064,66321,66322,66577,66606,67119,67342,67424,67484,67497,67517,67590,67672,67746,68021,68285,68418,68419,68504,68505,68506,68507,68511,68512,68513,68514,68515,68517,68524,68525,68531,68538,68641,68669,68673,68703,68704,68705,68706,68708,68709,68710,68891,68892,68994,68996,69002,69047,69069,69075,69252,69267,69343,69368,69369,69370,69371,69372,69373,69421,69422,69423,69424,69425,69490,69528) AND `attr_value` <> '' [ RunTime:0.002764s ]
SHOW FULL COLUMNS FROM `tp_goods_attribute` [ RunTime:0.000420s ]
SELECT `attr_id`,`attr_id`,`attr_name`,`attr_index` FROM `tp_goods_attribute` WHERE ( attr_index = 1 ) [ RunTime:0.000148s ]
SELECT * FROM `tp_goods` WHERE `goods_id` IN (30962,30963,34150,34577,34841,34879,34883,35003,36240,36250,36319,36536,36671,36789,36937,36945,37045,37143,37268,37427,37722,37832,38056,38238,38244,38281,38357,38385,38432,38858,39061,39076,39098,39152,39240,39389,39428,39518,40047,40104,40121,40130,40208,40272,40354,40383,40526,40590,40599,40621,40875,40877,40921,40966,41061,41063,41089,41370,41371,41493,41826,41997,42033,42361,42568,42706,42888,43265,43270,43283,43366,43392,43490,43591,43592,43593,43731,43732,43743,43926,43932,43998,44027,44081,44084,44305,44330,44790,44791,45028,45169,45355,45402,45456,45960,46000,46119,46120,46137,46430,46528,46579,46844,46914,46920,47110,47194,47195,47418,47448,47513,47552,47671,47989,48117,48118,48152,48187,48259,48271,48339,48402,48456,48619,48701,48832,48931,48941,49093,49199,49208,49227,49247,49373,49485,49750,49776,49816,49871,49957,50242,50352,50929,50971,51217,51708,51833,51839,51840,51941,52047,52057,52058,52059,52139,52179,52180,52200,52281,52324,52512,52676,52761,52798,53010,53218,53328,53438,53532,53783,53784,53785,53786,53787,53807,53808,53809,53810,53811,53823,53894,54231,54289,54291,54292,54375,54376,54377,54378,54379,54380,54381,54394,54523,54524,54768,54913,55022,55114,55132,55529,55578,55579,55582,55634,55711,55737,55738,55741,55745,55797,55899,55902,55904,55907,55908,55913,55926,55947,56249,56292,56645,56646,56658,56732,56734,56822,56932,57116,57388,57391,57428,57570,57621,57641,57670,57703,57866,57919,58037,58038,58114,58280,58281,58695,59189,59325,59428,59434,59727,59799,60033,60240,60264,60292,60418,60780,60785,60999,61265,61322,61889,62316,62847,62924,63393,63413,63519,63732,63733,63734,64078,64079,64319,64321,64322,64325,64327,64328,64329,64330,64334,64335,64430,64468,64475,64482,64553,64614,64624,64625,64744,64745,65075,65077,65143,65255,65374,65821,65893,65977,65992,65994,66064,66321,66322,66577,66606,67119,67342,67424,67484,67497,67517,67590,67672,67746,68021,68285,68418,68419,68504,68505,68506,68507,68511,68512,68513,68514,68515,68517,68524,68525,68531,68538,68641,68669,68673,68703,68704,68705,68706,68708,68709,68710,68891,68892,68994,68996,69002,69047,69069,69075,69252,69267,69343,69368,69369,69370,69371,69372,69373,69421,69422,69423,69424,69425,69490,69528) ORDER BY `sort` ASC LIMIT 0,10 [ RunTime:0.020221s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.000531s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (30962,30963,34150,34577,34841,34879,34883,35003,36240,36250) [ RunTime:0.000611s ]
SHOW FULL COLUMNS FROM `tp_goods_label` [ RunTime:0.000451s ]
SELECT `label_id`,`label_name` FROM `tp_goods_label` [ RunTime:0.000133s ]
SELECT `id`,`id`,`name`,`parent_id`,`level` FROM `tp_goods_category` WHERE ( is_show=1 ) [ RunTime:0.000218s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30962 LIMIT 1 [ RunTime:0.000272s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 30963 LIMIT 1 [ RunTime:0.000203s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 34150 LIMIT 1 [ RunTime:0.000195s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 34577 LIMIT 1 [ RunTime:0.000192s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 34841 LIMIT 1 [ RunTime:0.000223s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 34879 LIMIT 1 [ RunTime:0.000215s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 34883 LIMIT 1 [ RunTime:0.000677s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 35003 LIMIT 1 [ RunTime:0.000222s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 36240 LIMIT 1 [ RunTime:0.000200s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 36250 LIMIT 1 [ RunTime:0.000197s ]
