SHOW FULL COLUMNS FROM `life_site_goods` [ RunTime:0.006187s ]
SHOW FULL COLUMNS FROM `life_site_goods_category` [ RunTime:0.005642s ]
SELECT * FROM `life_site_goods_category` WHERE `region_id` = 20 AND `site_id` = 79 AND `is_show` = 1 AND `is_delete` = 0 AND `pid` = 215 ORDER BY `sort` DESC [ RunTime:0.004847s ]
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.023130s ]
SHOW FULL COLUMNS FROM `life_region_goods_share` [ RunTime:0.006161s ]
SELECT `goods_id`,`id`,`price`,`offlinetime`,`marketprice` FROM `life_region_goods_share` WHERE `goods_id` IN (16435,16430,16429,16403,16389,16387,16386,16379,16378,16377,16376,16368,16367,16365,16360,16359,16358,16357,16356,16352,16350,16292,16291,16290,16289,16288,16287,16286,16285,16284,16271,16269,16254,16253,16252,16242,16241,16240,16239,16236,16238,16210,16206,16205,16204,16201,16199,16197,16182,16181,16180,16179,16178,16170,16168,16155,16144,16119,16117,16116,16115,16092,16075,16076,16073,16057,16030,16023,16028,16027,16025,16021,16019,16013,16012,16011,16007,16002,16000,15999,15910,15911,15998,15994,15971,15963,15962,15933,15929,15927,15926,15925,15924,15905,15904,15903,15892,15884,15890,15881,15879,15876,15873,15858,15856,15851,15840,15835,15828,15827,15813,15802,15800,15797,15796,15793,15792,15791,15787,15781,15786,15785,15784,15783,15782,15777,15772,15763,15721,15522,15724,15714,15704,15682,15681,15680,15677,15654,14447,14900,14901,15594,15593,15570,15569,15568,15565,15564,15563,15540,15456,15448,15426,15331,15330,15328,15325,15322,15320,15162,15293,15292,15240,15183,15182,15167,15166,15165,14572,15108,15078,15065,15063,15012,14990,14972,14960,14949,14948,14863,14841,14791,14710,14577,14575,14574,14469,14465,14464,14309,14308,14040,14041,13029,14012,13919,13910,13914,13913,13909,13874,13873,13860,13859,13856,13855,13854,13846,13743,13721,13702,13623,13510,13509,13489,13488,13375,13295,13243,13241,13239,13237,13221,13218,13216,13173,13172,13162,13160,13159,12785,12973,12947,12944,12919,12918,12915,12914,12912,12909,12908,12781,12777,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,9857,9856,9855,9825,9819,9014,9016,9017,8959,8809,8559,8555,8335,7785,6124,5752,5749,5740,5512,5224,5221,4950,4928,4137,4110,4107,4106,4060,4059,4055,4054,4053,4051,3074,3073,3071,3069,3058,3057,3056,3031,3029,3028,3172,3246,3247,3303,3302,3179,3339,3337,3336,3335,3334,3333,3367,3412,3413,3414,3280,3281,3282,3284,3240,3241,3242,3266,3267,3268,3270,3277,3276,3275,3274,3273,3364,3318,3319,3135,3136,3137,3448,3446,3445,3138,3139,3140,3141,3142,3263,3264,3265,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.009033s ]
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.004959s ]
