SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 306513 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 306513 [ RunTime:0.003138s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (281167,80816,819387,81282,338541,487096,431580,949355,598328,849586,8708,27779,402781,570709,634229,479183,214476,357901,1025857,300364,522032,468629,957853,43053,201245,470921,694830,835939,334440,116398,230021,631424,791191,360776,906182,631405,582077,810326,795089,226638,243498,298526,823310,171054,6364,288746,765758,271014,629814,710684,298485,810308,834694,615798,381129,522401,854683,569764,755743,333761) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 306513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 306513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000756s ]