set session sql_mode='NO_ENGINE_SUBSTITUTION' [ RunTime:0.000222s ]
SHOW FULL COLUMNS FROM `xr_1_share_category` [ RunTime:0.112657s ]
SELECT * FROM `xr_1_share_category` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000610s ]
SELECT count(*) as c FROM `xr_1_store` WHERE `xr_1_store`.`is_sale` = 0 AND `xr_1_store`.`catid` IN (10,27,28,104,112,113,114,115,116,117,118,119,120,105,121,122,123,124,125,126,127,106,128,107,129,130,131,132,133,134,135,108,136,137,138,139,109,140,141,110,142,143,144,145,146,147,148,149,111,150,151,152,29,30) ORDER BY NULL [ RunTime:0.011671s ]
SELECT * FROM `xr_1_store` WHERE `xr_1_store`.`is_sale` = 0 AND `xr_1_store`.`catid` IN (10,27,28,104,112,113,114,115,116,117,118,119,120,105,121,122,123,124,125,126,127,106,128,107,129,130,131,132,133,134,135,108,136,137,138,139,109,140,141,110,142,143,144,145,146,147,148,149,111,150,151,152,29,30) ORDER BY `xr_1_store`.`displayorder` ASC,`xr_1_store`.`id` DESC LIMIT 0,10 [ RunTime:0.012655s ]