SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401236 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401236 [ RunTime:0.001682s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (698809,37849,892408,687800,884589,770133,954924,406133,531150,710123,798640,484751,830061,566887,807640,497062,999350,453296,977465,693268,234094,460391,526858,122878,139196,743164,292690,971285,952563,210817,848174,47199,708065,1015948,386933,854063,790707,404187,677710,748032,540793,590067,259143,442690,700955,375320,821858,339498,75954,898267,22319,71574,25569,364188,8082,28024,842442,928475,106352,287213) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002968s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401236 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401236 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]