SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 181999 LIMIT 1 [ RunTime:0.003242s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 181999 [ RunTime:0.001505s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (821818,446096,435807,433526,915090,514454,666374,612109,236776,737219,761893,732038,44200,753053,679483,611169,908949,557367,342300,608672,21422,409955,764470,77891,121061,256777,19705,868189,891912,517909,972449,868743,175038,1014741,247601,415014,252734,970233,661581,813996,221064,181426,47244,726485,837811,860649,94458,540562,938714,747285,944694,94151,963194,432502,661456,791806,102376,991942,915550,293546) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 181999 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 181999 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003035s ]