SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001348s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 43421 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 43421 [ RunTime:0.003907s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (336481,1046051,1009010,718832,770834,551261,343830,782735,520550,793295,377731,60073,14249,595557,64918,714449,356778,159206,198135,520735,422657,620321,786848,129484,95392,138170,154193,644316,127838,246171,177653,794078,1042579,342829,955601,388277,635381,868216,878479,651077,553456,285329,653878,335474,681953,768003,723973,310840,695043,822525,788812,91551,719333,665694,4648,533420,389998,401499,380739,509080) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 43421 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 43421 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000476s ]