SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002434s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506790 LIMIT 1 [ RunTime:0.000452s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506790 [ RunTime:0.002698s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (339136,208265,289284,630838,650151,964388,152384,50980,132201,40415,399880,454937,670830,931375,275654,13626,237319,552066,21369,772563,995965,376832,194148,305969,878511,411226,621765,529498,732500,898797,166273,294886,350995,255909,359256,844388,492866,662810,309230,648897,296663,132116,75530,116313,390810,107608,213912,550728,902237,157553,755247,637894,116849,249181,1041608,509887,351610,475214,366367,684403) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506790 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506790 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]