SHOW FULL COLUMNS FROM `life_site_goods` [ RunTime:0.012953s ]
SHOW FULL COLUMNS FROM `life_site_goods_category` [ RunTime:0.007790s ]
SELECT * FROM `life_site_goods_category` WHERE `region_id` = 20 AND `site_id` = 79 AND `is_show` = 1 AND `is_delete` = 0 AND `pid` = 115 ORDER BY `sort` DESC [ RunTime:0.006845s ]
SELECT `rg`.`name`,`rg`.`picture`,rg.id goodsid,`sg`.* FROM `life_site_goods` `sg` INNER JOIN `life_region_goods` `rg` ON `rg`.`id`=`sg`.`goods_id` WHERE `sg`.`region_id` = 20 AND `sg`.`site_id` = 79 AND `sg`.`is_shelf` = 1 AND `sg`.`is_delete` = 0 AND `sg`.`third_status` = 1 AND `rg`.`is_delete` = 0 AND ( sg.id > 0 ) ORDER BY `sg`.`sort` DESC,`sg`.`id` DESC [ RunTime:0.023551s ]
SHOW FULL COLUMNS FROM `life_region_goods_share` [ RunTime:0.006223s ]
SELECT `goods_id`,`id`,`price`,`offlinetime`,`marketprice` FROM `life_region_goods_share` WHERE `goods_id` IN (16145,16144,16122,16121,16119,16117,16116,16115,16092,16075,16076,16073,16070,16069,16068,16064,16063,16062,16061,15967,16057,16037,16036,16033,16031,16030,16023,16028,16027,16025,16021,16020,16019,16015,16013,16012,16011,16007,16006,16005,16003,16001,16002,16000,15999,15910,15911,15998,15994,15971,15963,15962,15933,15929,15927,15926,15925,15924,15906,15905,15904,15903,15892,15884,15890,15881,15879,15876,15873,15858,15856,15851,15839,15835,15829,15828,15827,15813,15803,15802,15797,15791,15787,15781,15786,15785,15784,15782,15777,15772,15763,15743,15741,15721,15522,15724,15714,15708,15704,15682,15681,15680,15677,4162,15654,15637,15616,14447,14900,14901,15594,15593,15581,15570,15569,15568,15565,15564,15563,15559,15557,15558,15556,15540,15474,15472,15456,15449,15448,15429,15426,15331,15330,15320,15162,15293,15292,15240,15202,15201,15200,15199,15198,15197,15196,15195,15194,15193,15183,15182,15167,15166,15165,14572,15108,15097,15078,14994,15065,15063,14990,14972,14960,14949,14948,14858,14863,14841,14793,14791,14781,14710,14575,14469,14465,14464,14309,14308,14040,14041,13029,14039,14012,13919,13910,13914,13913,13909,13874,13873,13860,13859,13856,13855,13854,13846,13787,13743,13721,13702,13623,13510,13509,13491,13489,13488,13375,13295,13243,13241,13239,13237,13221,13218,13216,13215,13173,13172,13162,13160,13159,12785,12973,12947,12944,12919,12918,12915,12914,12912,12909,12908,12781,12777,12766,12732,12731,12728,12688,12679,12552,12551,12550,12485,12462,12399,12398,11408,12351,12350,12349,12348,12202,12198,12035,12033,12032,12031,11987,11986,11984,11981,11834,11833,11792,11789,11774,11663,11664,11662,11492,11468,11465,11412,11411,11407,11257,11132,10979,10977,10978,10976,10611,9908,9857,9856,9855,9825,9819,9619,9014,9016,9017,8959,8809,8610,8559,8555,8335,7785,6523,6124,5752,5749,5740,5512,5224,5221,4978,4977,4976,4950,4928,4161,4137,4110,4107,4106,4060,4059,4055,4054,4053,4051,3074,3073,3072,3071,3069,3060,3058,3057,3056,3055,3032,3031,3029,3028,3172,3246,3247,3303,3302,3179,3047,3218,3339,3337,3336,3335,3334,3333,3165,3176,3289,3367,3412,3413,3414,3181,3167,3280,3281,3282,3284,3240,3241,3242,3266,3267,3268,3270,3277,3276,3275,3274,3273,3364,3041,3318,3319,3135,3136,3137,3448,3446,3445,3138,3139,3140,3141,3142,3263,3264,3265,3480,3411,3410,3252,3239,3238,3174) AND `region_id` = 20 AND ( ( `type` = 1 AND `related_id` = 46 ) OR ( `type` = 2 AND `related_id` = 79 ) ) [ RunTime:0.008893s ]
SELECT * FROM `life_site_goods_category` WHERE `region_id` = 20 AND `site_id` = 79 AND `is_show` = 1 AND `is_delete` = 0 ORDER BY `sort` DESC [ RunTime:0.004820s ]