SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545826 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545826 [ RunTime:0.001833s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (569457,703784,344801,600342,355874,1019296,737869,917208,15056,266125,740428,320331,776326,854810,844598,986173,791402,266653,659832,295338,134187,475989,774780,879254,204070,264122,29727,1019376,775075,511505,372214,758304,567441,849110,678413,350148,168398,528759,134065,529010,644253,529875,279273,785246,888691,800716,964350,240952,388390,351866,222446,432505,540637,1006910,242549,147281,328398,56722,94211,902553) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004036s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545826 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545826 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]