SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.000484s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 1054 LIMIT 1 [ RunTime:0.000178s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 1031 ORDER BY `sort_order` DESC LIMIT 1 [ RunTime:0.000176s ]
SELECT `id`,`parent_id` FROM `tp_goods_category` [ RunTime:0.000338s ]
SELECT `id` FROM `tp_goods_category` WHERE `parent_id` = 1054 [ RunTime:0.000132s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.000586s ]
SELECT `goods_id` FROM `tp_goods` WHERE `is_on_sale` = 1 AND `exchange_integral` = 0 AND `cat_id` = 1054 [ RunTime:0.000695s ]
SELECT `zs_price` FROM `tp_goods` WHERE `goods_id` IN (32065,32637,32644,32649,32669,32674,32680,32681,32692,32714,32716,32719,32722,32726,32728,32731,32733,32746,32749,32760,32761,32765,32770,32776,32787,32796,32798,32801,32805,32817,32821,32831,32836,32837,32840,32847,32851,32853,32854,32857,32859,32861,32862,32863,32864,32866,32869,32871,32875,32877,32879,32889,32894,32900,32903,32908,32910,32915,32917,32921,32923,32924,32926,32927,32929,32934,32937,32942,32944,32948,32954,32959,32963,32973,32978,32986,32992,32993,32999,33002,33018,33035,33036,33050,33052,33055,33059,33063,33077,33081,33084,33086,33088,33097,33098,33099,33102,33103,33105,33107,33109,33113,33117,33118,33122,33129,33135,33138,33146,33147,33150,33153,33155,33157,33160,33163,33165,33169,33176,33180,33183,33188,33198,33201,33223,33227,33230,33234,33238,33242,33246,33249,33253,33256,33258,33268,33274,33276,33277,33971,33973,33974,33975,33976,33980,33982,33983,33984,33988,33990,33991,33992,33993,33994,34695,34697,34698,34699,34700,34701,34702,34711,34712,34713,34714,34715,34716,34717,34718,34720,34721,34722,34723,34729,34732,34733,34749,34750,34751,34752,34753,34754,34756,34758,34759,34760,34761,34764,34767,34769,34770,34771,34772,34773,34774,34776,34777,34778,34779,34782,34789,34790,34791,34792,34793,34794,34795,34796,35508,35660,35661,35665,35672,35673,35680,35681,35684,35689,35690,35695,35696,35697,35698,35701,36040,37717,39020,39130,44188,44929) [ RunTime:0.001452s ]
SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` IN (32065,32637,32644,32649,32669,32674,32680,32681,32692,32714,32716,32719,32722,32726,32728,32731,32733,32746,32749,32760,32761,32765,32770,32776,32787,32796,32798,32801,32805,32817,32821,32831,32836,32837,32840,32847,32851,32853,32854,32857,32859,32861,32862,32863,32864,32866,32869,32871,32875,32877,32879,32889,32894,32900,32903,32908,32910,32915,32917,32921,32923,32924,32926,32927,32929,32934,32937,32942,32944,32948,32954,32959,32963,32973,32978,32986,32992,32993,32999,33002,33018,33035,33036,33050,33052,33055,33059,33063,33077,33081,33084,33086,33088,33097,33098,33099,33102,33103,33105,33107,33109,33113,33117,33118,33122,33129,33135,33138,33146,33147,33150,33153,33155,33157,33160,33163,33165,33169,33176,33180,33183,33188,33198,33201,33223,33227,33230,33234,33238,33242,33246,33249,33253,33256,33258,33268,33274,33276,33277,33971,33973,33974,33975,33976,33980,33982,33983,33984,33988,33990,33991,33992,33993,33994,34695,34697,34698,34699,34700,34701,34702,34711,34712,34713,34714,34715,34716,34717,34718,34720,34721,34722,34723,34729,34732,34733,34749,34750,34751,34752,34753,34754,34756,34758,34759,34760,34761,34764,34767,34769,34770,34771,34772,34773,34774,34776,34777,34778,34779,34782,34789,34790,34791,34792,34793,34794,34795,34796,35508,35660,35661,35665,35672,35673,35680,35681,35684,35689,35690,35695,35696,35697,35698,35701,36040,37717,39020,39130,44188,44929) AND `brand_id` > 0 [ RunTime:0.001324s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.000432s ]
SELECT * FROM `tp_brand` WHERE `id` IN (6460,6467,6459,6456,6463,4670,4736,6472,4651,6471,4547,6465,4478,4665,4511) GROUP BY `name` LIMIT 30 [ RunTime:0.000335s ]
select group_concat(`key` separator '_') as `key` from tp_spec_goods_price where goods_id in(32065,32637,32644,32649,32669,32674,32680,32681,32692,32714,32716,32719,32722,32726,32728,32731,32733,32746,32749,32760,32761,32765,32770,32776,32787,32796,32798,32801,32805,32817,32821,32831,32836,32837,32840,32847,32851,32853,32854,32857,32859,32861,32862,32863,32864,32866,32869,32871,32875,32877,32879,32889,32894,32900,32903,32908,32910,32915,32917,32921,32923,32924,32926,32927,32929,32934,32937,32942,32944,32948,32954,32959,32963,32973,32978,32986,32992,32993,32999,33002,33018,33035,33036,33050,33052,33055,33059,33063,33077,33081,33084,33086,33088,33097,33098,33099,33102,33103,33105,33107,33109,33113,33117,33118,33122,33129,33135,33138,33146,33147,33150,33153,33155,33157,33160,33163,33165,33169,33176,33180,33183,33188,33198,33201,33223,33227,33230,33234,33238,33242,33246,33249,33253,33256,33258,33268,33274,33276,33277,33971,33973,33974,33975,33976,33980,33982,33983,33984,33988,33990,33991,33992,33993,33994,34695,34697,34698,34699,34700,34701,34702,34711,34712,34713,34714,34715,34716,34717,34718,34720,34721,34722,34723,34729,34732,34733,34749,34750,34751,34752,34753,34754,34756,34758,34759,34760,34761,34764,34767,34769,34770,34771,34772,34773,34774,34776,34777,34778,34779,34782,34789,34790,34791,34792,34793,34794,34795,34796,35508,35660,35661,35665,35672,35673,35680,35681,35684,35689,35690,35695,35696,35697,35698,35701,36040,37717,39020,39130,44188,44929) [ RunTime:0.000236s ]
SHOW FULL COLUMNS FROM `tp_goods_attr` [ RunTime:0.000337s ]
SELECT * FROM `tp_goods_attr` WHERE `goods_id` IN (32065,32637,32644,32649,32669,32674,32680,32681,32692,32714,32716,32719,32722,32726,32728,32731,32733,32746,32749,32760,32761,32765,32770,32776,32787,32796,32798,32801,32805,32817,32821,32831,32836,32837,32840,32847,32851,32853,32854,32857,32859,32861,32862,32863,32864,32866,32869,32871,32875,32877,32879,32889,32894,32900,32903,32908,32910,32915,32917,32921,32923,32924,32926,32927,32929,32934,32937,32942,32944,32948,32954,32959,32963,32973,32978,32986,32992,32993,32999,33002,33018,33035,33036,33050,33052,33055,33059,33063,33077,33081,33084,33086,33088,33097,33098,33099,33102,33103,33105,33107,33109,33113,33117,33118,33122,33129,33135,33138,33146,33147,33150,33153,33155,33157,33160,33163,33165,33169,33176,33180,33183,33188,33198,33201,33223,33227,33230,33234,33238,33242,33246,33249,33253,33256,33258,33268,33274,33276,33277,33971,33973,33974,33975,33976,33980,33982,33983,33984,33988,33990,33991,33992,33993,33994,34695,34697,34698,34699,34700,34701,34702,34711,34712,34713,34714,34715,34716,34717,34718,34720,34721,34722,34723,34729,34732,34733,34749,34750,34751,34752,34753,34754,34756,34758,34759,34760,34761,34764,34767,34769,34770,34771,34772,34773,34774,34776,34777,34778,34779,34782,34789,34790,34791,34792,34793,34794,34795,34796,35508,35660,35661,35665,35672,35673,35680,35681,35684,35689,35690,35695,35696,35697,35698,35701,36040,37717,39020,39130,44188,44929) AND `attr_value` <> '' [ RunTime:0.000611s ]
SHOW FULL COLUMNS FROM `tp_goods_attribute` [ RunTime:0.000355s ]
SELECT `attr_id`,`attr_id`,`attr_name`,`attr_index` FROM `tp_goods_attribute` WHERE ( attr_index = 1 ) [ RunTime:0.000119s ]
SELECT * FROM `tp_goods` WHERE `goods_id` IN (32065,32637,32644,32649,32669,32674,32680,32681,32692,32714,32716,32719,32722,32726,32728,32731,32733,32746,32749,32760,32761,32765,32770,32776,32787,32796,32798,32801,32805,32817,32821,32831,32836,32837,32840,32847,32851,32853,32854,32857,32859,32861,32862,32863,32864,32866,32869,32871,32875,32877,32879,32889,32894,32900,32903,32908,32910,32915,32917,32921,32923,32924,32926,32927,32929,32934,32937,32942,32944,32948,32954,32959,32963,32973,32978,32986,32992,32993,32999,33002,33018,33035,33036,33050,33052,33055,33059,33063,33077,33081,33084,33086,33088,33097,33098,33099,33102,33103,33105,33107,33109,33113,33117,33118,33122,33129,33135,33138,33146,33147,33150,33153,33155,33157,33160,33163,33165,33169,33176,33180,33183,33188,33198,33201,33223,33227,33230,33234,33238,33242,33246,33249,33253,33256,33258,33268,33274,33276,33277,33971,33973,33974,33975,33976,33980,33982,33983,33984,33988,33990,33991,33992,33993,33994,34695,34697,34698,34699,34700,34701,34702,34711,34712,34713,34714,34715,34716,34717,34718,34720,34721,34722,34723,34729,34732,34733,34749,34750,34751,34752,34753,34754,34756,34758,34759,34760,34761,34764,34767,34769,34770,34771,34772,34773,34774,34776,34777,34778,34779,34782,34789,34790,34791,34792,34793,34794,34795,34796,35508,35660,35661,35665,35672,35673,35680,35681,35684,35689,35690,35695,35696,35697,35698,35701,36040,37717,39020,39130,44188,44929) ORDER BY `sort` ASC LIMIT 0,10 [ RunTime:0.001378s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.000376s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (32770,32776,33035,33036,32787,33050,32796,33052,32798,33055) [ RunTime:0.000544s ]
SHOW FULL COLUMNS FROM `tp_goods_label` [ RunTime:0.000313s ]
SELECT `label_id`,`label_name` FROM `tp_goods_label` [ RunTime:0.000099s ]
SELECT `id`,`id`,`name`,`parent_id`,`level` FROM `tp_goods_category` WHERE ( is_show=1 ) [ RunTime:0.000158s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32770 LIMIT 1 [ RunTime:0.000201s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32776 LIMIT 1 [ RunTime:0.000146s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 33035 LIMIT 1 [ RunTime:0.000181s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 33036 LIMIT 1 [ RunTime:0.000319s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32787 LIMIT 1 [ RunTime:0.000165s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 33050 LIMIT 1 [ RunTime:0.000151s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32796 LIMIT 1 [ RunTime:0.000212s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 33052 LIMIT 1 [ RunTime:0.000216s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32798 LIMIT 1 [ RunTime:0.000224s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 33055 LIMIT 1 [ RunTime:0.000226s ]
