SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 745671 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 745671 [ RunTime:0.002651s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (164298,43761,809921,590755,191002,139217,470277,870006,202522,819400,596786,1018808,554221,870778,261074,185557,400502,151986,348690,674340,942010,370336,715781,537744,467481,480910,687967,895818,231458,487173,102129,253046,781550,298050,433508,104325,793632,414620,319225,29118,620447,614058,1043400,579555,109952,629919,791191,289431,998314,738313,430219,582059,232952,425115,106135,505882,70461,110075,1037368,630927) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 745671 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003181s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 745671 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001372s ]