SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540980 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540980 [ RunTime:0.001483s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (126300,824012,197201,818623,522266,619584,1035971,74848,654188,556870,449946,270999,992722,341416,486280,253280,237379,151429,112783,634649,638604,732653,1021930,143033,801078,339424,902663,1035770,184309,895002,190908,304487,42096,189311,212054,355752,733648,590976,278375,455594,981869,1033401,264660,573887,366518,609127,961462,40222,715864,639771,627765,78169,955478,502839,870936,878253,559816,950406,713753,366163) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540980 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540980 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]