SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001358s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 267992 LIMIT 1 [ RunTime:0.001947s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 267992 [ RunTime:0.005132s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (402009,188501,31296,188841,577518,110981,564308,818942,420160,486355,806070,392433,202113,975585,273012,664509,284160,135454,253803,899647,315490,760754,324848,578030,408478,422044,860561,151207,786793,445769,475431,760159,374332,614606,994074,895443,780924,759895,274556,589231,385484,1034174,913133,488735,458902,514706,603116,377700,348759,867356,838666,665794,84391,554182,77288,686611,231974,374326,492454,586357) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 267992 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000652s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 267992 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001918s ]