SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 913896 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 913896 [ RunTime:0.002362s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (748844,389923,1036043,575412,301756,741540,296618,816407,248887,40789,755872,1031995,411893,239471,413061,448907,240437,145174,652945,127397,649685,258644,448531,330617,346045,62066,742544,999042,202502,562009,977445,271601,786271,306709,633226,551157,97310,19033,479795,138182,408333,647416,284607,611081,188947,372149,631242,318420,924312,422245,491213,273753,631936,224003,80491,212317,175139,355537,736910,42796) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 913896 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 913896 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]