SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 293796 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 293796 [ RunTime:0.001850s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (575275,661896,201590,101447,1022965,1045741,907423,1000512,987351,208309,948170,672513,119378,214056,602922,772337,1004877,787572,725672,351352,377597,770205,114222,678183,234137,940245,668085,1046600,826491,868695,571084,597756,533911,954595,627443,736229,651975,508326,769045,27403,702764,614303,666200,1034030,826274,424939,623775,459822,746545,249488,759520,82488,328050,34224,474981,992786,660671,279907,1004586,462056) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 293796 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 293796 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000394s ]