SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029605 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029605 [ RunTime:0.001527s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (115795,68676,958962,717037,568881,130710,637622,784920,475996,609585,603980,824015,902919,293110,549686,341723,50238,975322,109764,43681,336172,229181,303324,154684,113041,461160,633128,398535,831683,27056,577658,750177,994181,763782,458230,505124,104547,579853,545480,719594,471523,926425,428752,392791,113581,249944,942611,10764,912860,569189,710260,460848,426171,890958,687700,981371,693025,353802,401707,509305) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000958s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029605 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029605 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000453s ]