SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 425122 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 425122 [ RunTime:0.001543s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (114252,832803,764755,416826,753470,327866,932519,543239,811900,1025997,165481,762650,677741,720604,716273,324805,359389,672609,198907,868821,605765,327333,155682,477608,380504,839568,532702,633083,596487,118812,580085,82329,480791,426856,437768,683891,897994,370347,977085,473713,450967,774916,1005134,226841,159339,252318,760170,226786,253236,357624,304930,654009,20520,638846,993765,1020142,845618,831270,912632,1005260) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 425122 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 425122 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000453s ]