SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016016 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016016 [ RunTime:0.002259s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (268398,133085,1015126,507734,975245,490083,831370,994151,337590,455309,151493,180893,497502,956383,775298,658721,460212,801385,165013,799670,493011,803968,405730,349903,843457,75787,900323,920862,493705,240936,25595,542850,194795,505092,848889,532628,481187,18378,803059,479980,737797,828971,290982,145754,944082,285570,330846,223112,884051,119016,792344,652910,1047907,387238,611429,690384,759595,558622,444576,310179) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016016 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016016 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]