SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 581881 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 581881 [ RunTime:0.001783s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (193077,1003566,440432,601331,943465,585557,605391,428948,681075,376441,899122,1048342,481295,521780,962861,219007,389060,143140,822335,927244,975362,1001611,371445,613124,119207,754687,257444,369038,735205,619495,319986,1045702,259081,560205,783251,381728,961001,198933,928319,462948,721575,349600,628264,138735,219229,367711,889021,392562,1012017,427150,420557,601997,830384,224441,258740,295516,1033220,973709,226653,402405) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 581881 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 581881 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000663s ]