SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001392s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 689759 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 689759 [ RunTime:0.002087s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (59912,499751,321680,266533,793158,264391,684696,282295,231998,991141,447748,492949,778410,239941,104113,241672,914059,940706,435824,946527,506724,278208,742423,121956,351333,391729,372040,118217,9214,226227,164079,452635,53457,849794,804437,408893,411916,845724,320382,509565,859647,663368,720145,961858,20577,616292,890402,950946,65264,974044,288300,972748,675062,1002973,194656,666180,66626,392811,565555,32541) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004164s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 689759 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000553s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 689759 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]