SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003336s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543508 LIMIT 1 [ RunTime:0.000696s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543508 [ RunTime:0.002044s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (34404,908678,222255,35800,128620,711831,596680,351637,747432,772916,350707,92818,76470,821458,88523,602675,350384,385631,344170,899001,451680,998453,106891,379643,534956,466130,606643,710211,206396,59226,233413,949111,571895,468473,674647,934122,734204,317371,229929,486911,30315,212088,200856,875584,189311,814803,644839,651013,801608,632522,518299,800887,245336,238822,961982,274105,478890,213232,851437,419664) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543508 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000508s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543508 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]