SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.000611s ]
SELECT `zs_price` FROM `tp_goods` WHERE `goods_id` IN (33995,35847,36699,36721,36737,36795,38563,38890,38898,39401,39441,39461,39616,39626,39637,39694,39767,40245,40291,41113,41349,41350,41542,41739,41740,43400,43806,44551,46148,46670,47032,48379,48380,49113,50287,50392,50537,50702,51258,52292,52574,52678,52679,53217,53338,53873,54644,55176,55426,55948,55949,55950,55951,55952,55953,55956,55957,55958,55976,56056,56130,56161,56198,56199,56238,56289,56360,56361,56383,56412,56629,56630,56631,56632,56633,56634,56635,56636,56637,56644,56724,56725,56726,56727,56730,56891,56892,56893,56895,56896,56897,56898,56899,56900,56901,57352,57353,57382,57383,57498,57872,57873,57874,58442,58660,58661,58667,58668,58809,58811,58984,58985,59009,59129,59233,59234,59235,59238,59248,59249,59334,59380,59381,59409,59707,59933,59986,60163,60165,60167,60293,60294,60295,60296,60297,60298,60373,60511,60512,60936,60937,60938,60939,60940,61362,61363,61364,61365,62133,62233,62966,63215,63565,63566,63567,63568,63569,63570,64218,64456,64550,64551,64552,65874,65875,65876,65877,65878,65879,65880,65881,65885,65886,65939,65940,66026,66070,66081,66385,66451,66452,66453,66454,66455,66456,66457,66674,66773,66777,66789,66816,66817,66818,66897,66898,67345,67437,67658,67659,68146,68147,68501,68502,68503,68797,68988,68989,69059,69403,69420,69452,69453) [ RunTime:0.001191s ]
SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` IN (33995,35847,36699,36721,36737,36795,38563,38890,38898,39401,39441,39461,39616,39626,39637,39694,39767,40245,40291,41113,41349,41350,41542,41739,41740,43400,43806,44551,46148,46670,47032,48379,48380,49113,50287,50392,50537,50702,51258,52292,52574,52678,52679,53217,53338,53873,54644,55176,55426,55948,55949,55950,55951,55952,55953,55956,55957,55958,55976,56056,56130,56161,56198,56199,56238,56289,56360,56361,56383,56412,56629,56630,56631,56632,56633,56634,56635,56636,56637,56644,56724,56725,56726,56727,56730,56891,56892,56893,56895,56896,56897,56898,56899,56900,56901,57352,57353,57382,57383,57498,57872,57873,57874,58442,58660,58661,58667,58668,58809,58811,58984,58985,59009,59129,59233,59234,59235,59238,59248,59249,59334,59380,59381,59409,59707,59933,59986,60163,60165,60167,60293,60294,60295,60296,60297,60298,60373,60511,60512,60936,60937,60938,60939,60940,61362,61363,61364,61365,62133,62233,62966,63215,63565,63566,63567,63568,63569,63570,64218,64456,64550,64551,64552,65874,65875,65876,65877,65878,65879,65880,65881,65885,65886,65939,65940,66026,66070,66081,66385,66451,66452,66453,66454,66455,66456,66457,66674,66773,66777,66789,66816,66817,66818,66897,66898,67345,67437,67658,67659,68146,68147,68501,68502,68503,68797,68988,68989,69059,69403,69420,69452,69453) AND `brand_id` > 0 [ RunTime:0.001213s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.000387s ]
SELECT * FROM `tp_brand` WHERE `id` IN (6326,6338,5377,5221,5335,5402,6355,5200,6336,6346,5985,6343,5631,6031,6327,5815,5597,4625,5519,4450,7139,6837,4986,7165,6298,7017,7422,5929,4563,7718,7650,8071,7720) GROUP BY `name` LIMIT 30 [ RunTime:0.000668s ]
SELECT `goods_id`,`goods_name`,`sales_sum`,`virtual_sales_sum`,`shop_price`,`bespeak_template_id`,`label_id` FROM `tp_goods` WHERE `goods_id` IN (33995,35847,36699,36721,36737,36795,38563,38890,38898,39401,39441,39461,39616,39626,39637,39694,39767,40245,40291,41113,41349,41350,41542,41739,41740,43400,43806,44551,46148,46670,47032,48379,48380,49113,50287,50392,50537,50702,51258,52292,52574,52678,52679,53217,53338,53873,54644,55176,55426,55948,55949,55950,55951,55952,55953,55956,55957,55958,55976,56056,56130,56161,56198,56199,56238,56289,56360,56361,56383,56412,56629,56630,56631,56632,56633,56634,56635,56636,56637,56644,56724,56725,56726,56727,56730,56891,56892,56893,56895,56896,56897,56898,56899,56900,56901,57352,57353,57382,57383,57498,57872,57873,57874,58442,58660,58661,58667,58668,58809,58811,58984,58985,59009,59129,59233,59234,59235,59238,59248,59249,59334,59380,59381,59409,59707,59933,59986,60163,60165,60167,60293,60294,60295,60296,60297,60298,60373,60511,60512,60936,60937,60938,60939,60940,61362,61363,61364,61365,62133,62233,62966,63215,63565,63566,63567,63568,63569,63570,64218,64456,64550,64551,64552,65874,65875,65876,65877,65878,65879,65880,65881,65885,65886,65939,65940,66026,66070,66081,66385,66451,66452,66453,66454,66455,66456,66457,66674,66773,66777,66789,66816,66817,66818,66897,66898,67345,67437,67658,67659,68146,68147,68501,68502,68503,68797,68988,68989,69059,69403,69420,69452,69453) ORDER BY `sort` DESC LIMIT 0,12 [ RunTime:0.001142s ]
SHOW FULL COLUMNS FROM `tp_goods_label` [ RunTime:0.000379s ]
SELECT `label_id`,`label_name` FROM `tp_goods_label` [ RunTime:0.000107s ]
SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.000346s ]
SELECT `id`,`id`,`name`,`parent_id`,`level` FROM `tp_goods_category` WHERE ( is_show=1 ) [ RunTime:0.000276s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 66816 LIMIT 1 [ RunTime:0.000248s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 66817 LIMIT 1 [ RunTime:0.000221s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 66818 LIMIT 1 [ RunTime:0.000236s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 60163 LIMIT 1 [ RunTime:0.000215s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 60165 LIMIT 1 [ RunTime:0.000239s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 35847 LIMIT 1 [ RunTime:0.000233s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 44551 LIMIT 1 [ RunTime:0.000231s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 60167 LIMIT 1 [ RunTime:0.000226s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 57352 LIMIT 1 [ RunTime:0.000227s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 60936 LIMIT 1 [ RunTime:0.000179s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 57353 LIMIT 1 [ RunTime:0.000167s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 60937 LIMIT 1 [ RunTime:0.000144s ]
