SHOW FULL COLUMNS FROM `tp_config` [ RunTime:0.000659s ]
SELECT * FROM `tp_config` [ RunTime:0.000231s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.000621s ]
SELECT `goods_id` FROM `tp_goods` WHERE `is_on_sale` = 1 AND `goods_name` LIKE '%家具%' [ RunTime:0.029258s ]
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.001258s ]
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.001168s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.000389s ]
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.002583s ]
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 `sales_sum` DESC LIMIT 0,12 [ RunTime:0.001143s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.000385s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (48380,39767,50702,50287,41542,40291,41740,46670,43400,44551,39461,41350) [ RunTime:0.004937s ]
SHOW FULL COLUMNS FROM `tp_goods_label` [ RunTime:0.002140s ]
SELECT `label_id`,`label_name` FROM `tp_goods_label` [ RunTime:0.000116s ]
SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.000357s ]
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` = 48380 LIMIT 1 [ RunTime:0.000354s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 39767 LIMIT 1 [ RunTime:0.000828s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 50702 LIMIT 1 [ RunTime:0.000276s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 50287 LIMIT 1 [ RunTime:0.000169s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 41542 LIMIT 1 [ RunTime:0.000196s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 40291 LIMIT 1 [ RunTime:0.000143s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 41740 LIMIT 1 [ RunTime:0.000160s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 46670 LIMIT 1 [ RunTime:0.000161s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 43400 LIMIT 1 [ RunTime:0.000167s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 44551 LIMIT 1 [ RunTime:0.000175s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 39461 LIMIT 1 [ RunTime:0.000147s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 41350 LIMIT 1 [ RunTime:0.000174s ]
