SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.000688s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 1095 LIMIT 1 [ RunTime:0.000322s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 1094 ORDER BY `sort_order` DESC LIMIT 1 [ RunTime:0.000221s ]
SELECT `id`,`parent_id` FROM `tp_goods_category` [ RunTime:0.000691s ]
SELECT `id` FROM `tp_goods_category` WHERE `parent_id` = 1095 [ RunTime:0.000178s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.000730s ]
SELECT `goods_id` FROM `tp_goods` WHERE `is_on_sale` = 1 AND `exchange_integral` = 0 AND `cat_id` = 1095 [ RunTime:0.000634s ]
SELECT `zs_price` FROM `tp_goods` WHERE `goods_id` IN (41577,47919,49100,51902,52138,53818,54016,54128,54181,54205,54487,54488,54489,54490,54491,54492,54493,54494,54495,54496,54497,54498,54499,54500,54501,54502,54503,54504,54505,54723,54724,54725,54726,55042,55044,58422,58912,60764,61114,62523,62524,62525,62526,62527,62528,62529,62531,62532,62534,62535,62536,62537,62570,63466,63467,63468,63469,63470,63471,63472,63473,63474,63476,63477,63481,63491,63492,63493,63494,63498,63499,63693,63694,63695,63696,63697,63698,63699,63702,63703,63704,63705,63706,63707,63708,63709,63710,63711,63712,63713,63714,63715,63716,63717,63718,63719,63720,63721,63723,63724,63725,63726,63727,63728,63750,63751,63752,63753,63754,63755,63756,63757,63758,63759,63785,63917,64760,65265,65266,65616,65618,65619,65620,66331,67655,69043,69050,69430,69557,69558,69559,69560,69561,69562,69563,69564,69565,69566,69567,69568,69569,69570,69571,69572,69573,69580,69588,69589,69590,69591,69592,69593,69594,69595,69596,69597,69598,69599,69600,69601,69602,69603,69604,69605) [ RunTime:0.001140s ]
SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` IN (41577,47919,49100,51902,52138,53818,54016,54128,54181,54205,54487,54488,54489,54490,54491,54492,54493,54494,54495,54496,54497,54498,54499,54500,54501,54502,54503,54504,54505,54723,54724,54725,54726,55042,55044,58422,58912,60764,61114,62523,62524,62525,62526,62527,62528,62529,62531,62532,62534,62535,62536,62537,62570,63466,63467,63468,63469,63470,63471,63472,63473,63474,63476,63477,63481,63491,63492,63493,63494,63498,63499,63693,63694,63695,63696,63697,63698,63699,63702,63703,63704,63705,63706,63707,63708,63709,63710,63711,63712,63713,63714,63715,63716,63717,63718,63719,63720,63721,63723,63724,63725,63726,63727,63728,63750,63751,63752,63753,63754,63755,63756,63757,63758,63759,63785,63917,64760,65265,65266,65616,65618,65619,65620,66331,67655,69043,69050,69430,69557,69558,69559,69560,69561,69562,69563,69564,69565,69566,69567,69568,69569,69570,69571,69572,69573,69580,69588,69589,69590,69591,69592,69593,69594,69595,69596,69597,69598,69599,69600,69601,69602,69603,69604,69605) AND `brand_id` > 0 [ RunTime:0.000998s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.000400s ]
SELECT * FROM `tp_brand` WHERE `id` IN (6081,4450,7139,6661,7647,6236,6099) GROUP BY `name` LIMIT 30 [ RunTime:0.000395s ]
select group_concat(`key` separator '_') as `key` from tp_spec_goods_price where goods_id in(41577,47919,49100,51902,52138,53818,54016,54128,54181,54205,54487,54488,54489,54490,54491,54492,54493,54494,54495,54496,54497,54498,54499,54500,54501,54502,54503,54504,54505,54723,54724,54725,54726,55042,55044,58422,58912,60764,61114,62523,62524,62525,62526,62527,62528,62529,62531,62532,62534,62535,62536,62537,62570,63466,63467,63468,63469,63470,63471,63472,63473,63474,63476,63477,63481,63491,63492,63493,63494,63498,63499,63693,63694,63695,63696,63697,63698,63699,63702,63703,63704,63705,63706,63707,63708,63709,63710,63711,63712,63713,63714,63715,63716,63717,63718,63719,63720,63721,63723,63724,63725,63726,63727,63728,63750,63751,63752,63753,63754,63755,63756,63757,63758,63759,63785,63917,64760,65265,65266,65616,65618,65619,65620,66331,67655,69043,69050,69430,69557,69558,69559,69560,69561,69562,69563,69564,69565,69566,69567,69568,69569,69570,69571,69572,69573,69580,69588,69589,69590,69591,69592,69593,69594,69595,69596,69597,69598,69599,69600,69601,69602,69603,69604,69605) [ RunTime:0.000760s ]
SHOW FULL COLUMNS FROM `tp_goods_attr` [ RunTime:0.000345s ]
SELECT * FROM `tp_goods_attr` WHERE `goods_id` IN (41577,47919,49100,51902,52138,53818,54016,54128,54181,54205,54487,54488,54489,54490,54491,54492,54493,54494,54495,54496,54497,54498,54499,54500,54501,54502,54503,54504,54505,54723,54724,54725,54726,55042,55044,58422,58912,60764,61114,62523,62524,62525,62526,62527,62528,62529,62531,62532,62534,62535,62536,62537,62570,63466,63467,63468,63469,63470,63471,63472,63473,63474,63476,63477,63481,63491,63492,63493,63494,63498,63499,63693,63694,63695,63696,63697,63698,63699,63702,63703,63704,63705,63706,63707,63708,63709,63710,63711,63712,63713,63714,63715,63716,63717,63718,63719,63720,63721,63723,63724,63725,63726,63727,63728,63750,63751,63752,63753,63754,63755,63756,63757,63758,63759,63785,63917,64760,65265,65266,65616,65618,65619,65620,66331,67655,69043,69050,69430,69557,69558,69559,69560,69561,69562,69563,69564,69565,69566,69567,69568,69569,69570,69571,69572,69573,69580,69588,69589,69590,69591,69592,69593,69594,69595,69596,69597,69598,69599,69600,69601,69602,69603,69604,69605) AND `attr_value` <> '' [ RunTime:0.000984s ]
SHOW FULL COLUMNS FROM `tp_goods_attribute` [ RunTime:0.000373s ]
SELECT `attr_id`,`attr_id`,`attr_name`,`attr_index` FROM `tp_goods_attribute` WHERE ( attr_index = 1 ) [ RunTime:0.000122s ]
SELECT * FROM `tp_goods` WHERE `goods_id` IN (41577,47919,49100,51902,52138,53818,54016,54128,54181,54205,54487,54488,54489,54490,54491,54492,54493,54494,54495,54496,54497,54498,54499,54500,54501,54502,54503,54504,54505,54723,54724,54725,54726,55042,55044,58422,58912,60764,61114,62523,62524,62525,62526,62527,62528,62529,62531,62532,62534,62535,62536,62537,62570,63466,63467,63468,63469,63470,63471,63472,63473,63474,63476,63477,63481,63491,63492,63493,63494,63498,63499,63693,63694,63695,63696,63697,63698,63699,63702,63703,63704,63705,63706,63707,63708,63709,63710,63711,63712,63713,63714,63715,63716,63717,63718,63719,63720,63721,63723,63724,63725,63726,63727,63728,63750,63751,63752,63753,63754,63755,63756,63757,63758,63759,63785,63917,64760,65265,65266,65616,65618,65619,65620,66331,67655,69043,69050,69430,69557,69558,69559,69560,69561,69562,69563,69564,69565,69566,69567,69568,69569,69570,69571,69572,69573,69580,69588,69589,69590,69591,69592,69593,69594,69595,69596,69597,69598,69599,69600,69601,69602,69603,69604,69605) ORDER BY `sort` ASC LIMIT 0,10 [ RunTime:0.001000s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.000340s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (54016,55042,63491,55044,63492,63493,63494,63750,63751,63752) [ RunTime:0.001988s ]
SHOW FULL COLUMNS FROM `tp_goods_label` [ RunTime:0.000369s ]
SELECT `label_id`,`label_name` FROM `tp_goods_label` [ RunTime:0.000113s ]
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` = 54016 LIMIT 1 [ RunTime:0.000324s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 55042 LIMIT 1 [ RunTime:0.000242s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 63491 LIMIT 1 [ RunTime:0.000250s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 55044 LIMIT 1 [ RunTime:0.000221s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 63492 LIMIT 1 [ RunTime:0.000225s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 63493 LIMIT 1 [ RunTime:0.000222s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 63494 LIMIT 1 [ RunTime:0.000210s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 63750 LIMIT 1 [ RunTime:0.000341s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 63751 LIMIT 1 [ RunTime:0.000349s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 63752 LIMIT 1 [ RunTime:0.001298s ]
