SHOW FULL COLUMNS FROM `tp_goods_category` [ RunTime:0.000559s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 1131 LIMIT 1 [ RunTime:0.000211s ]
SELECT * FROM `tp_goods_category` WHERE `id` = 1130 ORDER BY `sort_order` DESC LIMIT 1 [ RunTime:0.000221s ]
SELECT `id`,`parent_id` FROM `tp_goods_category` [ RunTime:0.000423s ]
SELECT `id` FROM `tp_goods_category` WHERE `parent_id` = 1131 [ RunTime:0.000191s ]
SHOW FULL COLUMNS FROM `tp_goods` [ RunTime:0.000693s ]
SELECT `goods_id` FROM `tp_goods` WHERE `is_on_sale` = 1 AND `exchange_integral` = 0 AND `cat_id` = 1131 [ RunTime:0.000802s ]
SELECT `zs_price` FROM `tp_goods` WHERE `goods_id` IN (33108,33123,33128,33130,33149,33151,33154,34058,34059,34060,34061,34062,34063,34064,34065,34067,34068,34071,34072,34073,34074,34542,34543,34582,34610,34679,34680,34835,34836,34837,34838,34839,34840,34915,34917,34918,34919,34920,34921,34937,34938,34939,34940,34941,34942,34943,34944,34945,34946,34947,34948,34949,34950,34951,34952,34953,34954,34955,35068,35839,35843,35854,35855,35856,35857,35858,35859,35860,35862,35863,35864,35866,36089,36259,36265,36428,36429,36430,36526,36530,36531,36851,36853,36854,36855,36991,36993,36994,36995,36996,36999,37000,37001,37002,37003,37004,37005,37006,37007,37009,37010,37011,37012,37013,37014,37016,37017,37022,37023,37026,37029,37032,37034,37038,37039,37041,37066,37067,37072,37079,37080,37082,37083,37183,37184,37530,37646,38336,38388,38523,38573,38575,38690,38808,38943,38984,38986,38987,38988,39239,39283,39338,39391,39397,39398,39399,39400,39475,39476,39533,39562,39711,40148,40865,41026,41027,41028,41107,41139,41156,41244,41263,41322,41436,41507,41508,41694,42209,42210,42495,42497,42621,42965,42966,43079,43193,43194,43196,43197,43198,43199,43259,43261,43286,43736,43940,43976,43984,44121,44160,44163,44185,44227,44228,44289,44361,44433,44493,44498,44499,44500,44509,44510,44511,44512,44513,44545,44546,44547,44589,44617,44826,44846,45106,45107,45108,45117,45231,45232) [ RunTime:0.001431s ]
SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` IN (33108,33123,33128,33130,33149,33151,33154,34058,34059,34060,34061,34062,34063,34064,34065,34067,34068,34071,34072,34073,34074,34542,34543,34582,34610,34679,34680,34835,34836,34837,34838,34839,34840,34915,34917,34918,34919,34920,34921,34937,34938,34939,34940,34941,34942,34943,34944,34945,34946,34947,34948,34949,34950,34951,34952,34953,34954,34955,35068,35839,35843,35854,35855,35856,35857,35858,35859,35860,35862,35863,35864,35866,36089,36259,36265,36428,36429,36430,36526,36530,36531,36851,36853,36854,36855,36991,36993,36994,36995,36996,36999,37000,37001,37002,37003,37004,37005,37006,37007,37009,37010,37011,37012,37013,37014,37016,37017,37022,37023,37026,37029,37032,37034,37038,37039,37041,37066,37067,37072,37079,37080,37082,37083,37183,37184,37530,37646,38336,38388,38523,38573,38575,38690,38808,38943,38984,38986,38987,38988,39239,39283,39338,39391,39397,39398,39399,39400,39475,39476,39533,39562,39711,40148,40865,41026,41027,41028,41107,41139,41156,41244,41263,41322,41436,41507,41508,41694,42209,42210,42495,42497,42621,42965,42966,43079,43193,43194,43196,43197,43198,43199,43259,43261,43286,43736,43940,43976,43984,44121,44160,44163,44185,44227,44228,44289,44361,44433,44493,44498,44499,44500,44509,44510,44511,44512,44513,44545,44546,44547,44589,44617,44826,44846,45106,45107,45108,45117,45231,45232) AND `brand_id` > 0 [ RunTime:0.001344s ]
SHOW FULL COLUMNS FROM `tp_brand` [ RunTime:0.000452s ]
SELECT * FROM `tp_brand` WHERE `id` IN (6367,6369,6377,4591,6370,6395,6372,6390,4614,6371,6378,4606,6368,4728,4938,4929,6388,4910,5136,4604,6387,6396,5493,6385,5228,6402,6374,6401,6399,6394,6062,6403,6397,6383,6221,6407,6382,6389,5292) GROUP BY `name` LIMIT 30 [ RunTime:0.000851s ]
select group_concat(`key` separator '_') as `key` from tp_spec_goods_price where goods_id in(33108,33123,33128,33130,33149,33151,33154,34058,34059,34060,34061,34062,34063,34064,34065,34067,34068,34071,34072,34073,34074,34542,34543,34582,34610,34679,34680,34835,34836,34837,34838,34839,34840,34915,34917,34918,34919,34920,34921,34937,34938,34939,34940,34941,34942,34943,34944,34945,34946,34947,34948,34949,34950,34951,34952,34953,34954,34955,35068,35839,35843,35854,35855,35856,35857,35858,35859,35860,35862,35863,35864,35866,36089,36259,36265,36428,36429,36430,36526,36530,36531,36851,36853,36854,36855,36991,36993,36994,36995,36996,36999,37000,37001,37002,37003,37004,37005,37006,37007,37009,37010,37011,37012,37013,37014,37016,37017,37022,37023,37026,37029,37032,37034,37038,37039,37041,37066,37067,37072,37079,37080,37082,37083,37183,37184,37530,37646,38336,38388,38523,38573,38575,38690,38808,38943,38984,38986,38987,38988,39239,39283,39338,39391,39397,39398,39399,39400,39475,39476,39533,39562,39711,40148,40865,41026,41027,41028,41107,41139,41156,41244,41263,41322,41436,41507,41508,41694,42209,42210,42495,42497,42621,42965,42966,43079,43193,43194,43196,43197,43198,43199,43259,43261,43286,43736,43940,43976,43984,44121,44160,44163,44185,44227,44228,44289,44361,44433,44493,44498,44499,44500,44509,44510,44511,44512,44513,44545,44546,44547,44589,44617,44826,44846,45106,45107,45108,45117,45231,45232) [ RunTime:0.000338s ]
SHOW FULL COLUMNS FROM `tp_goods_attr` [ RunTime:0.000400s ]
SELECT * FROM `tp_goods_attr` WHERE `goods_id` IN (33108,33123,33128,33130,33149,33151,33154,34058,34059,34060,34061,34062,34063,34064,34065,34067,34068,34071,34072,34073,34074,34542,34543,34582,34610,34679,34680,34835,34836,34837,34838,34839,34840,34915,34917,34918,34919,34920,34921,34937,34938,34939,34940,34941,34942,34943,34944,34945,34946,34947,34948,34949,34950,34951,34952,34953,34954,34955,35068,35839,35843,35854,35855,35856,35857,35858,35859,35860,35862,35863,35864,35866,36089,36259,36265,36428,36429,36430,36526,36530,36531,36851,36853,36854,36855,36991,36993,36994,36995,36996,36999,37000,37001,37002,37003,37004,37005,37006,37007,37009,37010,37011,37012,37013,37014,37016,37017,37022,37023,37026,37029,37032,37034,37038,37039,37041,37066,37067,37072,37079,37080,37082,37083,37183,37184,37530,37646,38336,38388,38523,38573,38575,38690,38808,38943,38984,38986,38987,38988,39239,39283,39338,39391,39397,39398,39399,39400,39475,39476,39533,39562,39711,40148,40865,41026,41027,41028,41107,41139,41156,41244,41263,41322,41436,41507,41508,41694,42209,42210,42495,42497,42621,42965,42966,43079,43193,43194,43196,43197,43198,43199,43259,43261,43286,43736,43940,43976,43984,44121,44160,44163,44185,44227,44228,44289,44361,44433,44493,44498,44499,44500,44509,44510,44511,44512,44513,44545,44546,44547,44589,44617,44826,44846,45106,45107,45108,45117,45231,45232) AND `attr_value` <> '' [ RunTime:0.001461s ]
SHOW FULL COLUMNS FROM `tp_goods_attribute` [ RunTime:0.000445s ]
SELECT `attr_id`,`attr_id`,`attr_name`,`attr_index` FROM `tp_goods_attribute` WHERE ( attr_index = 1 ) [ RunTime:0.000155s ]
SELECT * FROM `tp_goods` WHERE `goods_id` IN (33108,33123,33128,33130,33149,33151,33154,34058,34059,34060,34061,34062,34063,34064,34065,34067,34068,34071,34072,34073,34074,34542,34543,34582,34610,34679,34680,34835,34836,34837,34838,34839,34840,34915,34917,34918,34919,34920,34921,34937,34938,34939,34940,34941,34942,34943,34944,34945,34946,34947,34948,34949,34950,34951,34952,34953,34954,34955,35068,35839,35843,35854,35855,35856,35857,35858,35859,35860,35862,35863,35864,35866,36089,36259,36265,36428,36429,36430,36526,36530,36531,36851,36853,36854,36855,36991,36993,36994,36995,36996,36999,37000,37001,37002,37003,37004,37005,37006,37007,37009,37010,37011,37012,37013,37014,37016,37017,37022,37023,37026,37029,37032,37034,37038,37039,37041,37066,37067,37072,37079,37080,37082,37083,37183,37184,37530,37646,38336,38388,38523,38573,38575,38690,38808,38943,38984,38986,38987,38988,39239,39283,39338,39391,39397,39398,39399,39400,39475,39476,39533,39562,39711,40148,40865,41026,41027,41028,41107,41139,41156,41244,41263,41322,41436,41507,41508,41694,42209,42210,42495,42497,42621,42965,42966,43079,43193,43194,43196,43197,43198,43199,43259,43261,43286,43736,43940,43976,43984,44121,44160,44163,44185,44227,44228,44289,44361,44433,44493,44498,44499,44500,44509,44510,44511,44512,44513,44545,44546,44547,44589,44617,44826,44846,45106,45107,45108,45117,45231,45232) ORDER BY `sort` ASC LIMIT 0,10 [ RunTime:0.001534s ]
SHOW FULL COLUMNS FROM `tp_goods_images` [ RunTime:0.000419s ]
SELECT * FROM `tp_goods_images` WHERE `goods_id` IN (42497,44289,44545,44546,35843,44547,34058,34059,34060,34061) [ RunTime:0.000446s ]
SHOW FULL COLUMNS FROM `tp_goods_label` [ RunTime:0.000421s ]
SELECT `label_id`,`label_name` FROM `tp_goods_label` [ RunTime:0.000146s ]
SELECT `id`,`id`,`name`,`parent_id`,`level` FROM `tp_goods_category` WHERE ( is_show=1 ) [ RunTime:0.000205s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 42497 LIMIT 1 [ RunTime:0.000250s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 44289 LIMIT 1 [ RunTime:0.000211s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 44545 LIMIT 1 [ RunTime:0.000227s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 44546 LIMIT 1 [ RunTime:0.000206s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 35843 LIMIT 1 [ RunTime:0.000223s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 44547 LIMIT 1 [ RunTime:0.000210s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 34058 LIMIT 1 [ RunTime:0.000296s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 34059 LIMIT 1 [ RunTime:0.000234s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 34060 LIMIT 1 [ RunTime:0.000386s ]
SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 34061 LIMIT 1 [ RunTime:0.000234s ]
