SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.000458s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 1138 LIMIT 1 [ RunTime:0.000176s ]
SELECT `id`,`parent_id` FROM `tp_goods_category` [ RunTime:0.000366s ]
SELECT `id` FROM `tp_goods_category` WHERE `parent_id` = 1138 [ RunTime:0.000142s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.000546s ]
SELECT `goods_id` FROM `tp_goods` WHERE `is_on_sale` = 1 AND `exchange_integral` = 0 AND `cat_id` IN (1138,1143,1144,1145,1146) [ RunTime:0.001064s ]
SELECT `zs_price` FROM `tp_goods` WHERE `goods_id` IN (33145,35777,35778,35781,35783,35795,35800,35804,35813,35821,36356,36967,36971,36973,37224,37225,37547,37649,38351,41741,41792,42216,42359,42501,42672,43076,43078,44042,44234,31264,31269,31272,31273,31276,31279,31565,31567,31569,34116,34117,36466,36968,36969,36975,36985,37223,37528,37529,37654,37681,38187,38200,38350,38802,39340,39545,39763,39772,39773,40219,40244,40342,40343,40344,40500,41222,41223,41318,41319,41325,41337,41356,41357,41360,41361,41364,41366,41805,41808,41809,41864,41865,41990,42360,42504,42505,42508,42715,42967,42968,42969,42970,42971,42972,43014,43015,43016,43050,43051,43203,43204,43205,43206,43207,43208,43209,43210,43459,43463,43464,43469,43472,43530,43532,43552,43602,43605,43618,43624,43626,43628,44095,44131,44162,44249,45103,45148,46033,46048,46049,46050,46204,46206,46212,46392,46495,46497,46529,46660,46661,48058,48063,48074,48088,48286,48287,48289,48290,48494,48495,48499,48526,48568,48959,49071,49073,49077,49661,49662,49729,49730,49731,49777,49778,50152,50490,50491,50685,50686,50687,50688,50689,50719,50720,50723,50724,50795,50977,51040,51050,51255,51321,51381,51753,51809,52102,52297,52304,52406,52490,52519,53741,54254,54294,54423,54424,54561,54635,54641,54821,54973,54974,54975,54976,54985,54993,55188,55436,55546,55881,56381,56518,56860,56862,57024,57025,57029,57225,57226,57227,57228,57229,57310,57334,57335,57337,57342,57343,57344,57345,57351,57471,57568,57849,57990,58086,58150,58503,58567,58901,58909,58971,59151,59152,59175,59179,59215,59216,59266,59382,59383,59558,59559,59560,59732,59733,59941,59982,60283,60355,60357,60884,61074,61098,61184,61339,61340,61461,61462,61463,61504,61505,61551,61552,61553,61554,61578,61614,61756,61899,61900,61922,61923,61984,62065,62076,62077,62086,62118,62269,62270,62292,62296,62332,62413,62415,62485,62572,62574,62592,62593,62612,62667,62749,62766,62767,62801,62856,63204,63365,63366,63367,63368,63380,63599,63627,63692,63794,64093,64094,64182,64184,64618,65026,65043,65047,65057,65160,65450,65451,65475,65476,65477,65487,65543,65718,65731,65978,66008,66009,66010,66155,66156,66157,66158,66557,66653,66654,66655,66724,66725,66726,66730,66946,66947,67002,67022,67027,67028,67082,67191,67192,67260,68153,68158,68159,68537,68754,68879,69334) [ RunTime:0.001937s ]
SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` IN (33145,35777,35778,35781,35783,35795,35800,35804,35813,35821,36356,36967,36971,36973,37224,37225,37547,37649,38351,41741,41792,42216,42359,42501,42672,43076,43078,44042,44234,31264,31269,31272,31273,31276,31279,31565,31567,31569,34116,34117,36466,36968,36969,36975,36985,37223,37528,37529,37654,37681,38187,38200,38350,38802,39340,39545,39763,39772,39773,40219,40244,40342,40343,40344,40500,41222,41223,41318,41319,41325,41337,41356,41357,41360,41361,41364,41366,41805,41808,41809,41864,41865,41990,42360,42504,42505,42508,42715,42967,42968,42969,42970,42971,42972,43014,43015,43016,43050,43051,43203,43204,43205,43206,43207,43208,43209,43210,43459,43463,43464,43469,43472,43530,43532,43552,43602,43605,43618,43624,43626,43628,44095,44131,44162,44249,45103,45148,46033,46048,46049,46050,46204,46206,46212,46392,46495,46497,46529,46660,46661,48058,48063,48074,48088,48286,48287,48289,48290,48494,48495,48499,48526,48568,48959,49071,49073,49077,49661,49662,49729,49730,49731,49777,49778,50152,50490,50491,50685,50686,50687,50688,50689,50719,50720,50723,50724,50795,50977,51040,51050,51255,51321,51381,51753,51809,52102,52297,52304,52406,52490,52519,53741,54254,54294,54423,54424,54561,54635,54641,54821,54973,54974,54975,54976,54985,54993,55188,55436,55546,55881,56381,56518,56860,56862,57024,57025,57029,57225,57226,57227,57228,57229,57310,57334,57335,57337,57342,57343,57344,57345,57351,57471,57568,57849,57990,58086,58150,58503,58567,58901,58909,58971,59151,59152,59175,59179,59215,59216,59266,59382,59383,59558,59559,59560,59732,59733,59941,59982,60283,60355,60357,60884,61074,61098,61184,61339,61340,61461,61462,61463,61504,61505,61551,61552,61553,61554,61578,61614,61756,61899,61900,61922,61923,61984,62065,62076,62077,62086,62118,62269,62270,62292,62296,62332,62413,62415,62485,62572,62574,62592,62593,62612,62667,62749,62766,62767,62801,62856,63204,63365,63366,63367,63368,63380,63599,63627,63692,63794,64093,64094,64182,64184,64618,65026,65043,65047,65057,65160,65450,65451,65475,65476,65477,65487,65543,65718,65731,65978,66008,66009,66010,66155,66156,66157,66158,66557,66653,66654,66655,66724,66725,66726,66730,66946,66947,67002,67022,67027,67028,67082,67191,67192,67260,68153,68158,68159,68537,68754,68879,69334) AND `brand_id` > 0 [ RunTime:0.002405s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.000488s ]
SELECT * FROM `tp_brand` WHERE `id` IN (4750,5030,4625,6503,6513,5095,4588,4626,4635,4634,4627,6505,6514,5925,6506,6504,6496,6266,4450,5546,4640,6629,4632,7139,6930,7561,7330,5854,7508,7946,5041,6572,8058,8089) GROUP BY `name` LIMIT 30 [ RunTime:0.000761s ]
select group_concat(`key` separator '_') as `key` from tp_spec_goods_price where goods_id in(33145,35777,35778,35781,35783,35795,35800,35804,35813,35821,36356,36967,36971,36973,37224,37225,37547,37649,38351,41741,41792,42216,42359,42501,42672,43076,43078,44042,44234,31264,31269,31272,31273,31276,31279,31565,31567,31569,34116,34117,36466,36968,36969,36975,36985,37223,37528,37529,37654,37681,38187,38200,38350,38802,39340,39545,39763,39772,39773,40219,40244,40342,40343,40344,40500,41222,41223,41318,41319,41325,41337,41356,41357,41360,41361,41364,41366,41805,41808,41809,41864,41865,41990,42360,42504,42505,42508,42715,42967,42968,42969,42970,42971,42972,43014,43015,43016,43050,43051,43203,43204,43205,43206,43207,43208,43209,43210,43459,43463,43464,43469,43472,43530,43532,43552,43602,43605,43618,43624,43626,43628,44095,44131,44162,44249,45103,45148,46033,46048,46049,46050,46204,46206,46212,46392,46495,46497,46529,46660,46661,48058,48063,48074,48088,48286,48287,48289,48290,48494,48495,48499,48526,48568,48959,49071,49073,49077,49661,49662,49729,49730,49731,49777,49778,50152,50490,50491,50685,50686,50687,50688,50689,50719,50720,50723,50724,50795,50977,51040,51050,51255,51321,51381,51753,51809,52102,52297,52304,52406,52490,52519,53741,54254,54294,54423,54424,54561,54635,54641,54821,54973,54974,54975,54976,54985,54993,55188,55436,55546,55881,56381,56518,56860,56862,57024,57025,57029,57225,57226,57227,57228,57229,57310,57334,57335,57337,57342,57343,57344,57345,57351,57471,57568,57849,57990,58086,58150,58503,58567,58901,58909,58971,59151,59152,59175,59179,59215,59216,59266,59382,59383,59558,59559,59560,59732,59733,59941,59982,60283,60355,60357,60884,61074,61098,61184,61339,61340,61461,61462,61463,61504,61505,61551,61552,61553,61554,61578,61614,61756,61899,61900,61922,61923,61984,62065,62076,62077,62086,62118,62269,62270,62292,62296,62332,62413,62415,62485,62572,62574,62592,62593,62612,62667,62749,62766,62767,62801,62856,63204,63365,63366,63367,63368,63380,63599,63627,63692,63794,64093,64094,64182,64184,64618,65026,65043,65047,65057,65160,65450,65451,65475,65476,65477,65487,65543,65718,65731,65978,66008,66009,66010,66155,66156,66157,66158,66557,66653,66654,66655,66724,66725,66726,66730,66946,66947,67002,67022,67027,67028,67082,67191,67192,67260,68153,68158,68159,68537,68754,68879,69334) [ RunTime:0.000429s ]
SHOW FULL COLUMNS FROM `tp_goods_attr` [ RunTime:0.000425s ]
SELECT * FROM `tp_goods_attr` WHERE `goods_id` IN (33145,35777,35778,35781,35783,35795,35800,35804,35813,35821,36356,36967,36971,36973,37224,37225,37547,37649,38351,41741,41792,42216,42359,42501,42672,43076,43078,44042,44234,31264,31269,31272,31273,31276,31279,31565,31567,31569,34116,34117,36466,36968,36969,36975,36985,37223,37528,37529,37654,37681,38187,38200,38350,38802,39340,39545,39763,39772,39773,40219,40244,40342,40343,40344,40500,41222,41223,41318,41319,41325,41337,41356,41357,41360,41361,41364,41366,41805,41808,41809,41864,41865,41990,42360,42504,42505,42508,42715,42967,42968,42969,42970,42971,42972,43014,43015,43016,43050,43051,43203,43204,43205,43206,43207,43208,43209,43210,43459,43463,43464,43469,43472,43530,43532,43552,43602,43605,43618,43624,43626,43628,44095,44131,44162,44249,45103,45148,46033,46048,46049,46050,46204,46206,46212,46392,46495,46497,46529,46660,46661,48058,48063,48074,48088,48286,48287,48289,48290,48494,48495,48499,48526,48568,48959,49071,49073,49077,49661,49662,49729,49730,49731,49777,49778,50152,50490,50491,50685,50686,50687,50688,50689,50719,50720,50723,50724,50795,50977,51040,51050,51255,51321,51381,51753,51809,52102,52297,52304,52406,52490,52519,53741,54254,54294,54423,54424,54561,54635,54641,54821,54973,54974,54975,54976,54985,54993,55188,55436,55546,55881,56381,56518,56860,56862,57024,57025,57029,57225,57226,57227,57228,57229,57310,57334,57335,57337,57342,57343,57344,57345,57351,57471,57568,57849,57990,58086,58150,58503,58567,58901,58909,58971,59151,59152,59175,59179,59215,59216,59266,59382,59383,59558,59559,59560,59732,59733,59941,59982,60283,60355,60357,60884,61074,61098,61184,61339,61340,61461,61462,61463,61504,61505,61551,61552,61553,61554,61578,61614,61756,61899,61900,61922,61923,61984,62065,62076,62077,62086,62118,62269,62270,62292,62296,62332,62413,62415,62485,62572,62574,62592,62593,62612,62667,62749,62766,62767,62801,62856,63204,63365,63366,63367,63368,63380,63599,63627,63692,63794,64093,64094,64182,64184,64618,65026,65043,65047,65057,65160,65450,65451,65475,65476,65477,65487,65543,65718,65731,65978,66008,66009,66010,66155,66156,66157,66158,66557,66653,66654,66655,66724,66725,66726,66730,66946,66947,67002,67022,67027,67028,67082,67191,67192,67260,68153,68158,68159,68537,68754,68879,69334) AND `attr_value` <> '' [ RunTime:0.002356s ]
SHOW FULL COLUMNS FROM `tp_goods_attribute` [ RunTime:0.000464s ]
SELECT `attr_id`,`attr_id`,`attr_name`,`attr_index` FROM `tp_goods_attribute` WHERE ( attr_index = 1 ) [ RunTime:0.000162s ]
SELECT * FROM `tp_goods` WHERE `goods_id` IN (33145,35777,35778,35781,35783,35795,35800,35804,35813,35821,36356,36967,36971,36973,37224,37225,37547,37649,38351,41741,41792,42216,42359,42501,42672,43076,43078,44042,44234,31264,31269,31272,31273,31276,31279,31565,31567,31569,34116,34117,36466,36968,36969,36975,36985,37223,37528,37529,37654,37681,38187,38200,38350,38802,39340,39545,39763,39772,39773,40219,40244,40342,40343,40344,40500,41222,41223,41318,41319,41325,41337,41356,41357,41360,41361,41364,41366,41805,41808,41809,41864,41865,41990,42360,42504,42505,42508,42715,42967,42968,42969,42970,42971,42972,43014,43015,43016,43050,43051,43203,43204,43205,43206,43207,43208,43209,43210,43459,43463,43464,43469,43472,43530,43532,43552,43602,43605,43618,43624,43626,43628,44095,44131,44162,44249,45103,45148,46033,46048,46049,46050,46204,46206,46212,46392,46495,46497,46529,46660,46661,48058,48063,48074,48088,48286,48287,48289,48290,48494,48495,48499,48526,48568,48959,49071,49073,49077,49661,49662,49729,49730,49731,49777,49778,50152,50490,50491,50685,50686,50687,50688,50689,50719,50720,50723,50724,50795,50977,51040,51050,51255,51321,51381,51753,51809,52102,52297,52304,52406,52490,52519,53741,54254,54294,54423,54424,54561,54635,54641,54821,54973,54974,54975,54976,54985,54993,55188,55436,55546,55881,56381,56518,56860,56862,57024,57025,57029,57225,57226,57227,57228,57229,57310,57334,57335,57337,57342,57343,57344,57345,57351,57471,57568,57849,57990,58086,58150,58503,58567,58901,58909,58971,59151,59152,59175,59179,59215,59216,59266,59382,59383,59558,59559,59560,59732,59733,59941,59982,60283,60355,60357,60884,61074,61098,61184,61339,61340,61461,61462,61463,61504,61505,61551,61552,61553,61554,61578,61614,61756,61899,61900,61922,61923,61984,62065,62076,62077,62086,62118,62269,62270,62292,62296,62332,62413,62415,62485,62572,62574,62592,62593,62612,62667,62749,62766,62767,62801,62856,63204,63365,63366,63367,63368,63380,63599,63627,63692,63794,64093,64094,64182,64184,64618,65026,65043,65047,65057,65160,65450,65451,65475,65476,65477,65487,65543,65718,65731,65978,66008,66009,66010,66155,66156,66157,66158,66557,66653,66654,66655,66724,66725,66726,66730,66946,66947,67002,67022,67027,67028,67082,67191,67192,67260,68153,68158,68159,68537,68754,68879,69334) ORDER BY `sort` ASC LIMIT 0,10 [ RunTime:0.005841s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.000457s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (31264,31269,31272,31273,31276,31279,31565,31567,31569,33145) [ RunTime:0.000552s ]
SHOW FULL COLUMNS FROM `tp_goods_label` [ RunTime:0.000416s ]
SELECT `label_id`,`label_name` FROM `tp_goods_label` [ RunTime:0.000136s ]
SELECT `id`,`id`,`name`,`parent_id`,`level` FROM `tp_goods_category` WHERE ( is_show=1 ) [ RunTime:0.000218s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 31264 LIMIT 1 [ RunTime:0.000254s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 31269 LIMIT 1 [ RunTime:0.000213s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 31272 LIMIT 1 [ RunTime:0.000233s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 31273 LIMIT 1 [ RunTime:0.000212s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 31276 LIMIT 1 [ RunTime:0.000230s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 31279 LIMIT 1 [ RunTime:0.000227s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 31565 LIMIT 1 [ RunTime:0.000457s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 31567 LIMIT 1 [ RunTime:0.000259s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 31569 LIMIT 1 [ RunTime:0.000245s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 33145 LIMIT 1 [ RunTime:0.000225s ]
