SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801401 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801401 [ RunTime:0.001954s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (308489,1045815,47021,260528,284049,554292,117686,720815,947086,481918,896898,790396,168659,693607,960837,359435,742729,212729,493546,963499,150878,851594,620516,95544,958147,599220,131262,293110,462406,288920,247886,418995,971101,826370,816061,489469,938817,13398,744984,436545,605226,574001,206495,734373,519596,961678,908509,585047,746699,1042006,246482,537483,906771,659430,642948,532859,330284,28290,720065,122233) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000462s ]