SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 595985 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 595985 [ RunTime:0.001531s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (869387,158617,410775,69695,447779,744387,309330,1034454,624268,714261,1004397,413926,252590,1047848,780373,742530,585335,612645,254615,679318,990168,674689,775254,342232,280483,701698,908039,103042,427799,36720,153092,941155,432914,236278,788175,313787,914152,626632,796090,611772,279482,1047511,701054,177139,106365,571047,1021913,339360,600060,747728,607528,388885,108590,291378,488555,584059,113558,540413,791525,975916) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 595985 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 595985 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]