SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 218099 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 218099 [ RunTime:0.001581s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (32306,993629,716174,837514,630686,223646,44031,991640,879144,414041,402821,451492,462384,722905,981214,112713,497372,147853,825807,297969,217201,159414,407850,621266,275539,467634,396674,276334,200143,852727,993349,180081,966740,70958,356143,2397,17241,1022393,32727,493377,365146,440583,670370,496338,160430,503299,116627,238225,465270,939040,757630,816889,43547,801420,247106,962532,1001516,397803,360970,194933) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000940s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 218099 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000304s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 218099 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]