SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 190478 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 190478 [ RunTime:0.003071s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (98656,96934,1034445,242188,965654,882797,272996,757673,386191,679726,608644,835242,106812,725354,675838,197801,912248,352629,987148,227455,62262,739,270994,800544,929912,929945,35050,842244,368175,2130,277741,380921,54929,1030912,1041946,84452,320763,378534,694278,1013173,3419,616962,72340,27550,175083,628450,494547,973546,247850,362572,161653,880829,150865,326888,206467,424512,630429,178946,844810,228300) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 190478 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 190478 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000483s ]