SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 462062 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 462062 [ RunTime:0.001512s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (618568,723532,867162,763393,268485,631513,423083,284471,203199,1037555,1005140,50808,896223,254606,77463,910988,963125,327104,455013,703164,845628,374985,681383,1010605,201636,648442,942410,133299,135257,915673,383624,152024,866223,687400,268633,898413,1039020,728331,418862,524514,606605,154590,384890,603592,1012873,1046081,500023,278104,21706,708461,574502,1001438,341737,876952,333918,810787,334875,832345,157720,386380) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 462062 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 462062 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]