SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.000676s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 995 LIMIT 1 [ RunTime:0.000252s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 961 ORDER BY `sort_order` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`parent_id` FROM `tp_goods_category` [ RunTime:0.000565s ]
SELECT `id` FROM `tp_goods_category` WHERE `parent_id` = 995 [ RunTime:0.000265s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.001011s ]
SELECT `goods_id` FROM `tp_goods` WHERE `is_on_sale` = 1 AND `exchange_integral` = 0 AND `cat_id` = 995 [ RunTime:0.001177s ]
SELECT `zs_price` FROM `tp_goods` WHERE `goods_id` IN (32337,34550,35131,35931,36223,36359,36360,36361,36362,36612,38052,38053,39031,39146,39147,39254,39535,39547,39946,39994,40274,40275,40332,40333,40334,41304,41438,42036,42122,42184,42194,42195,42503,43073,43155,43751,43981,44087,44266,44595,44619,44620,44623,44646,44653,44681,44683,44684,44685,44690,44708,44784,44834,45044,45218,45790,45791,45792,45795,45796,45797,45798,45799,45800,45802,45803,45805,45806,45807,45808,45809,45811,45813,45814,45816,45818,45819,45821,45823,45825,45826,45828,45831,45832,45833,45834,45835,45836,45837,45838,45839,45840,45841,45842,45843,45844,45846,45848,45849,45850,45852,45853,45854,45855,45856,45857,45859,45861,45862,45864,45865,45867,45868,45869,45870,45871,45872,45873,45874,45877,45878,45880,45881,45883,45885,45886,45888,45923,45955,45956,45958,45959,46001,46002,46058,46061,46085,46374,46401,46410,46449,46450,46558,46560,46575,46598,46599,46600,47046,47092,47355,47532,47595,47620,47629,47673,47716,47750,47891,47892,47904,47921,47923,48127,48671,48978,49149,49345,49751,49761,49862,51022,51213,51523,51587,51695,51707,51723,51724,52636,53763,53842,53846,53858,53891,53912,53913,54182,54402,54459,54527,54658,55538,55539,55559,55567,56153,56200,56473,57051,57052,57053,57283,57284,57444,57445,57503,57671,57911,57992,58058,58276,58277,58278,58803,58804,58805,59111,59514,59529,59530,59769,59905,60232,60316,60443,61445,61446,61666,61705,61765,61766,61767,61768,61769,62746,62747,62748,62805,63411,63414,63417,63418,63833,64150,64209,64447,64448,64596,64724,65222,65263,65319,65456,65694,65737,65738,65841,66097,66193,66217,66302,66509,66510,66922,66923,67141,67142,67143,67144,67145,67146,67147,67325,67397,67399,67400,67401,67402,67403,67404,67405,67410,67412,67413,67414,67415,67416,67417,67418,67419,67420,67421,67422,67423,67478,67675,67704,67707,67866,67867,67868,67939,67947,68101,68181,68236,68458,68459,68779,68887,68888,69044,69109,69110,69210,69211,69224,69358,69364,69631) [ RunTime:0.002927s ]
SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` IN (32337,34550,35131,35931,36223,36359,36360,36361,36362,36612,38052,38053,39031,39146,39147,39254,39535,39547,39946,39994,40274,40275,40332,40333,40334,41304,41438,42036,42122,42184,42194,42195,42503,43073,43155,43751,43981,44087,44266,44595,44619,44620,44623,44646,44653,44681,44683,44684,44685,44690,44708,44784,44834,45044,45218,45790,45791,45792,45795,45796,45797,45798,45799,45800,45802,45803,45805,45806,45807,45808,45809,45811,45813,45814,45816,45818,45819,45821,45823,45825,45826,45828,45831,45832,45833,45834,45835,45836,45837,45838,45839,45840,45841,45842,45843,45844,45846,45848,45849,45850,45852,45853,45854,45855,45856,45857,45859,45861,45862,45864,45865,45867,45868,45869,45870,45871,45872,45873,45874,45877,45878,45880,45881,45883,45885,45886,45888,45923,45955,45956,45958,45959,46001,46002,46058,46061,46085,46374,46401,46410,46449,46450,46558,46560,46575,46598,46599,46600,47046,47092,47355,47532,47595,47620,47629,47673,47716,47750,47891,47892,47904,47921,47923,48127,48671,48978,49149,49345,49751,49761,49862,51022,51213,51523,51587,51695,51707,51723,51724,52636,53763,53842,53846,53858,53891,53912,53913,54182,54402,54459,54527,54658,55538,55539,55559,55567,56153,56200,56473,57051,57052,57053,57283,57284,57444,57445,57503,57671,57911,57992,58058,58276,58277,58278,58803,58804,58805,59111,59514,59529,59530,59769,59905,60232,60316,60443,61445,61446,61666,61705,61765,61766,61767,61768,61769,62746,62747,62748,62805,63411,63414,63417,63418,63833,64150,64209,64447,64448,64596,64724,65222,65263,65319,65456,65694,65737,65738,65841,66097,66193,66217,66302,66509,66510,66922,66923,67141,67142,67143,67144,67145,67146,67147,67325,67397,67399,67400,67401,67402,67403,67404,67405,67410,67412,67413,67414,67415,67416,67417,67418,67419,67420,67421,67422,67423,67478,67675,67704,67707,67866,67867,67868,67939,67947,68101,68181,68236,68458,68459,68779,68887,68888,69044,69109,69110,69210,69211,69224,69358,69364,69631) AND `brand_id` > 0 [ RunTime:0.002293s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.001129s ]
SELECT * FROM `tp_brand` WHERE `id` IN (4470,5176,5391,4714,5348,4619,5241,5437,5230,5456,5903,5489,5133,4839,6097,4450,5050,6110,5785,6266,5103,6436,5504,6611,5640,4569,4517,6270,5763,6542,5643,6543,7006,4738,6541,6545,6544,5398,5085,7139,6558,7069,6724,7234,6696,6729,6825,6877,5765,6596,6950,6730,6360,5231,6661,7153,5170,7543,5227,7897,7912,7940,7951,7953,7027,7977,4490,7237,5229,5228,5075,5310,5239) GROUP BY `name` LIMIT 30 [ RunTime:0.001847s ]
select group_concat(`key` separator '_') as `key` from tp_spec_goods_price where goods_id in(32337,34550,35131,35931,36223,36359,36360,36361,36362,36612,38052,38053,39031,39146,39147,39254,39535,39547,39946,39994,40274,40275,40332,40333,40334,41304,41438,42036,42122,42184,42194,42195,42503,43073,43155,43751,43981,44087,44266,44595,44619,44620,44623,44646,44653,44681,44683,44684,44685,44690,44708,44784,44834,45044,45218,45790,45791,45792,45795,45796,45797,45798,45799,45800,45802,45803,45805,45806,45807,45808,45809,45811,45813,45814,45816,45818,45819,45821,45823,45825,45826,45828,45831,45832,45833,45834,45835,45836,45837,45838,45839,45840,45841,45842,45843,45844,45846,45848,45849,45850,45852,45853,45854,45855,45856,45857,45859,45861,45862,45864,45865,45867,45868,45869,45870,45871,45872,45873,45874,45877,45878,45880,45881,45883,45885,45886,45888,45923,45955,45956,45958,45959,46001,46002,46058,46061,46085,46374,46401,46410,46449,46450,46558,46560,46575,46598,46599,46600,47046,47092,47355,47532,47595,47620,47629,47673,47716,47750,47891,47892,47904,47921,47923,48127,48671,48978,49149,49345,49751,49761,49862,51022,51213,51523,51587,51695,51707,51723,51724,52636,53763,53842,53846,53858,53891,53912,53913,54182,54402,54459,54527,54658,55538,55539,55559,55567,56153,56200,56473,57051,57052,57053,57283,57284,57444,57445,57503,57671,57911,57992,58058,58276,58277,58278,58803,58804,58805,59111,59514,59529,59530,59769,59905,60232,60316,60443,61445,61446,61666,61705,61765,61766,61767,61768,61769,62746,62747,62748,62805,63411,63414,63417,63418,63833,64150,64209,64447,64448,64596,64724,65222,65263,65319,65456,65694,65737,65738,65841,66097,66193,66217,66302,66509,66510,66922,66923,67141,67142,67143,67144,67145,67146,67147,67325,67397,67399,67400,67401,67402,67403,67404,67405,67410,67412,67413,67414,67415,67416,67417,67418,67419,67420,67421,67422,67423,67478,67675,67704,67707,67866,67867,67868,67939,67947,68101,68181,68236,68458,68459,68779,68887,68888,69044,69109,69110,69210,69211,69224,69358,69364,69631) [ RunTime:0.000619s ]
SHOW FULL COLUMNS FROM `tp_goods_attr` [ RunTime:0.000591s ]
SELECT * FROM `tp_goods_attr` WHERE `goods_id` IN (32337,34550,35131,35931,36223,36359,36360,36361,36362,36612,38052,38053,39031,39146,39147,39254,39535,39547,39946,39994,40274,40275,40332,40333,40334,41304,41438,42036,42122,42184,42194,42195,42503,43073,43155,43751,43981,44087,44266,44595,44619,44620,44623,44646,44653,44681,44683,44684,44685,44690,44708,44784,44834,45044,45218,45790,45791,45792,45795,45796,45797,45798,45799,45800,45802,45803,45805,45806,45807,45808,45809,45811,45813,45814,45816,45818,45819,45821,45823,45825,45826,45828,45831,45832,45833,45834,45835,45836,45837,45838,45839,45840,45841,45842,45843,45844,45846,45848,45849,45850,45852,45853,45854,45855,45856,45857,45859,45861,45862,45864,45865,45867,45868,45869,45870,45871,45872,45873,45874,45877,45878,45880,45881,45883,45885,45886,45888,45923,45955,45956,45958,45959,46001,46002,46058,46061,46085,46374,46401,46410,46449,46450,46558,46560,46575,46598,46599,46600,47046,47092,47355,47532,47595,47620,47629,47673,47716,47750,47891,47892,47904,47921,47923,48127,48671,48978,49149,49345,49751,49761,49862,51022,51213,51523,51587,51695,51707,51723,51724,52636,53763,53842,53846,53858,53891,53912,53913,54182,54402,54459,54527,54658,55538,55539,55559,55567,56153,56200,56473,57051,57052,57053,57283,57284,57444,57445,57503,57671,57911,57992,58058,58276,58277,58278,58803,58804,58805,59111,59514,59529,59530,59769,59905,60232,60316,60443,61445,61446,61666,61705,61765,61766,61767,61768,61769,62746,62747,62748,62805,63411,63414,63417,63418,63833,64150,64209,64447,64448,64596,64724,65222,65263,65319,65456,65694,65737,65738,65841,66097,66193,66217,66302,66509,66510,66922,66923,67141,67142,67143,67144,67145,67146,67147,67325,67397,67399,67400,67401,67402,67403,67404,67405,67410,67412,67413,67414,67415,67416,67417,67418,67419,67420,67421,67422,67423,67478,67675,67704,67707,67866,67867,67868,67939,67947,68101,68181,68236,68458,68459,68779,68887,68888,69044,69109,69110,69210,69211,69224,69358,69364,69631) AND `attr_value` <> '' [ RunTime:0.002753s ]
SHOW FULL COLUMNS FROM `tp_goods_attribute` [ RunTime:0.000512s ]
SELECT `attr_id`,`attr_id`,`attr_name`,`attr_index` FROM `tp_goods_attribute` WHERE ( attr_index = 1 ) [ RunTime:0.000187s ]
SELECT * FROM `tp_goods` WHERE `goods_id` IN (32337,34550,35131,35931,36223,36359,36360,36361,36362,36612,38052,38053,39031,39146,39147,39254,39535,39547,39946,39994,40274,40275,40332,40333,40334,41304,41438,42036,42122,42184,42194,42195,42503,43073,43155,43751,43981,44087,44266,44595,44619,44620,44623,44646,44653,44681,44683,44684,44685,44690,44708,44784,44834,45044,45218,45790,45791,45792,45795,45796,45797,45798,45799,45800,45802,45803,45805,45806,45807,45808,45809,45811,45813,45814,45816,45818,45819,45821,45823,45825,45826,45828,45831,45832,45833,45834,45835,45836,45837,45838,45839,45840,45841,45842,45843,45844,45846,45848,45849,45850,45852,45853,45854,45855,45856,45857,45859,45861,45862,45864,45865,45867,45868,45869,45870,45871,45872,45873,45874,45877,45878,45880,45881,45883,45885,45886,45888,45923,45955,45956,45958,45959,46001,46002,46058,46061,46085,46374,46401,46410,46449,46450,46558,46560,46575,46598,46599,46600,47046,47092,47355,47532,47595,47620,47629,47673,47716,47750,47891,47892,47904,47921,47923,48127,48671,48978,49149,49345,49751,49761,49862,51022,51213,51523,51587,51695,51707,51723,51724,52636,53763,53842,53846,53858,53891,53912,53913,54182,54402,54459,54527,54658,55538,55539,55559,55567,56153,56200,56473,57051,57052,57053,57283,57284,57444,57445,57503,57671,57911,57992,58058,58276,58277,58278,58803,58804,58805,59111,59514,59529,59530,59769,59905,60232,60316,60443,61445,61446,61666,61705,61765,61766,61767,61768,61769,62746,62747,62748,62805,63411,63414,63417,63418,63833,64150,64209,64447,64448,64596,64724,65222,65263,65319,65456,65694,65737,65738,65841,66097,66193,66217,66302,66509,66510,66922,66923,67141,67142,67143,67144,67145,67146,67147,67325,67397,67399,67400,67401,67402,67403,67404,67405,67410,67412,67413,67414,67415,67416,67417,67418,67419,67420,67421,67422,67423,67478,67675,67704,67707,67866,67867,67868,67939,67947,68101,68181,68236,68458,68459,68779,68887,68888,69044,69109,69110,69210,69211,69224,69358,69364,69631) ORDER BY `sort` ASC LIMIT 0,10 [ RunTime:0.018465s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.000464s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (32337,34550,35131,35931,36223,36359,36360,36361,36362,36612) [ RunTime:0.000656s ]
SHOW FULL COLUMNS FROM `tp_goods_label` [ RunTime:0.000453s ]
SELECT `label_id`,`label_name` FROM `tp_goods_label` [ RunTime:0.000151s ]
SELECT `id`,`id`,`name`,`parent_id`,`level` FROM `tp_goods_category` WHERE ( is_show=1 ) [ RunTime:0.000271s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 32337 LIMIT 1 [ RunTime:0.000256s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 34550 LIMIT 1 [ RunTime:0.000259s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 35131 LIMIT 1 [ RunTime:0.000233s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 35931 LIMIT 1 [ RunTime:0.000226s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 36223 LIMIT 1 [ RunTime:0.000211s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 36359 LIMIT 1 [ RunTime:0.000278s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 36360 LIMIT 1 [ RunTime:0.000255s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 36361 LIMIT 1 [ RunTime:0.000826s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 36362 LIMIT 1 [ RunTime:0.000360s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 36612 LIMIT 1 [ RunTime:0.000220s ]
