SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001390s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 382810 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 382810 [ RunTime:0.003916s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (314534,651909,546808,875723,503770,236535,164731,916388,359939,361309,771957,817367,178330,894124,105393,1036626,467895,958707,614042,929899,1029355,721952,309338,733902,444408,257979,40283,128755,355143,62576,954623,993234,908122,1008606,214689,640549,441023,17861,942334,760822,384285,876102,918353,689422,248027,765256,116136,760358,1021503,657867,842924,403858,631723,440951,334213,742524,361472,1045232,795902,368904) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 382810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 382810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]