SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012986 LIMIT 1 [ RunTime:0.002154s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012986 [ RunTime:0.001592s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (413148,541801,172993,173568,594335,560293,387288,993129,370569,518108,851096,232356,232488,923256,909455,146113,877051,838428,756904,359524,56772,93030,384452,1027504,625456,915876,1027178,263570,796765,244560,334080,711854,207149,989151,372252,940781,406598,623529,433310,48461,684616,896331,199628,202905,974063,892058,534818,393239,259281,248836,849222,386577,1040486,789107,988250,554910,216973,485698,497853,741101) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012986 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012986 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000462s ]