SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195423 LIMIT 1 [ RunTime:0.000439s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195423 [ RunTime:0.002599s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (267456,481792,3481,613171,380121,906102,362382,961778,944691,366895,782707,951312,747033,792824,620148,422097,638609,401931,860673,449245,269320,622821,474177,354403,731687,593234,957285,496866,234795,181791,160609,1019761,622402,1024502,1046363,594464,4168,462179,585943,964679,112042,761194,729521,796000,930571,802454,624282,549207,900428,608110,515914,196607,417711,549969,838662,690199,151331,39003,469810,488586) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195423 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000960s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195423 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000928s ]