SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 261037 LIMIT 1 [ RunTime:0.002085s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 261037 [ RunTime:0.004151s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (492388,383945,629707,1013810,201198,46887,97256,821770,806365,803307,898614,235489,471855,717119,405059,657334,19046,524389,986260,115045,632852,1028342,328026,617291,312798,61675,411764,559875,956980,68831,505980,525487,274003,875598,822350,475651,998097,472016,987846,445468,985437,147998,137069,733458,344818,379743,832014,735965,355414,286214,106718,526010,1014591,1009551,975131,298197,448890,540848,580996,620168) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 261037 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 261037 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]