SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002369s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503918 LIMIT 1 [ RunTime:0.000786s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503918 [ RunTime:0.002065s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (817440,279024,751005,295755,307217,883511,629767,440083,589488,882739,649271,726070,131335,203308,12263,72758,29383,450517,223275,505309,505035,1022066,313561,269124,365069,617413,618705,158845,904609,424484,253188,356093,624908,82460,263423,38002,751766,609761,627792,131408,1043109,160580,801703,600857,953053,1001292,938961,454956,681536,1003830,126829,757149,931183,133414,997708,76385,767627,624205,58604,585731) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503918 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503918 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]