SHOW FULL COLUMNS FROM `life_site_goods` [ RunTime:0.006575s ]
SHOW FULL COLUMNS FROM `life_site_goods_category` [ RunTime:0.006037s ]
SELECT * FROM `life_site_goods_category` WHERE `region_id` = 20 AND `site_id` = 79 AND `is_show` = 1 AND `is_delete` = 0 AND `pid` = 186 ORDER BY `sort` DESC [ RunTime:0.005458s ]
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.022723s ]
SHOW FULL COLUMNS FROM `life_region_goods_share` [ RunTime:0.006590s ]
SELECT `goods_id`,`id`,`price`,`offlinetime`,`marketprice` FROM `life_region_goods_share` WHERE `goods_id` IN (17505,17504,17493,17492,17491,17490,17472,17487,17482,17481,17480,17478,17471,17453,17452,17450,17449,17448,17447,17444,17442,17438,17437,17427,17389,17398,17388,17385,17345,17291,17280,17278,17279,17275,17250,17249,17248,17247,17225,17222,17221,17220,17217,17218,17209,17208,17207,17177,17174,17173,17169,17155,17154,17153,17152,17151,17146,17138,17143,17141,17140,17139,17126,17125,17124,17053,17051,17034,17025,17014,17006,16925,16924,16923,16908,16907,16885,16882,16849,16844,16843,16830,16828,16790,16829,16827,16801,16800,16799,16793,16792,16572,16783,16775,16773,16772,16771,16770,16554,16756,16755,16556,16558,16546,16547,16566,16754,16753,16742,16737,16736,16735,16695,16681,16640,16637,16632,16629,16621,16609,16608,16602,16594,16586,16585,16583,16584,16582,16581,16580,16579,16577,16575,16569,16565,16561,16557,16555,16543,16531,16525,16524,16519,16513,16451,16450,16368,16367,16359,16254,16199,16197,16075,16076,16013,16012,15929,15791,15704,14447,14900,14901,15565,15564,15563,15240,15183,15182,15167,15166,15165,15108,15078,14710,14309,14308,13029,14030,14032,14028,13914,13913,13874,13873,13860,13859,13856,13855,13854,13846,13721,13702,13510,13509,13375,13295,13239,13237,13218,13216,13173,13172,13162,13160,13159,12785,12973,12947,12944,12909,12908,12781,12777,12566,12552,12551,12550,12485,12398,11408,12351,12350,12349,12348,12202,12035,12033,12032,12031,11981,11792,11789,11774,11709,11707,11706,11662,11492,11412,11411,11407,11257,10611,9857,9856,9855,9825,9819,8559,8555,8335,7550,5752,5749,5740,5224,5221,4950,4137,4110,4107,4106,3172,3246,3247,3216,3339,3337,3336,3335,3334,3333,3165,3412,3413,3414,3167,3280,3281,3282,3284,3135,3136,3137,3448,3446,3445,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.008286s ]
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.005273s ]
