SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002112s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 285975 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 285975 [ RunTime:0.001690s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (510204,1041044,813673,1043716,167360,922623,802928,260351,991851,247633,391135,631732,199861,535737,46267,465716,965741,845891,519507,238020,1007802,727334,761537,953050,491452,1005223,255378,936316,221084,865934,193411,684043,214701,148743,672836,614576,795116,987592,732928,590605,36968,215592,42586,426388,243941,73427,944501,556543,731175,581447,334394,391730,692807,45420,723285,20092,507025,826025,935447,972773) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 285975 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000322s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 285975 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]