SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002928s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520694 LIMIT 1 [ RunTime:0.000901s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520694 [ RunTime:0.002164s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (5779,546119,465610,630462,283720,319895,410780,634115,552029,570606,139792,892149,893614,382986,405201,194292,962218,824827,126585,662342,760687,345933,422126,928130,871425,550285,540340,482842,188740,371134,291033,1046865,163647,161677,402501,167358,221605,468557,826442,49005,286421,325035,895489,18677,662791,138672,35325,1031386,172850,847786,628401,1002539,509063,357523,41505,504897,250781,69705,1009640,966368) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520694 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000545s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520694 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]