SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001414s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426531 LIMIT 1 [ RunTime:0.001827s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426531 [ RunTime:0.004426s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (352144,504877,451306,356767,487305,153984,998454,677093,762002,578490,887120,651816,489710,895087,936909,232600,267330,72370,963759,296944,972537,330837,108825,449613,146359,701872,789816,852509,454260,446516,469157,675796,297249,198406,665390,60791,805787,328900,209957,768770,929325,164945,102995,1004609,310855,353157,629166,1039817,540407,142344,279939,797133,711135,78564,646676,323828,775614,585735,540780,677169) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001865s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426531 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426531 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]