SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 585506 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 585506 [ RunTime:0.002353s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (151011,1027139,556453,799748,10453,738317,754188,508617,586381,739468,959450,2290,980874,153568,90765,486362,1003995,1029982,449349,400928,975650,794307,1024503,261518,464078,848129,985310,739850,256597,361043,752532,961230,693025,541600,887954,529334,1031075,568223,736404,1039851,701922,129446,1026917,528351,1044727,972850,960195,13918,402949,409010,1010354,932901,95262,510083,359685,601944,459418,422468,3124,212844) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001680s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 585506 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 585506 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000375s ]