SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002411s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407831 LIMIT 1 [ RunTime:0.000493s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407831 [ RunTime:0.001811s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (509704,874623,201418,758226,609338,43152,1396,104399,300240,324065,1025434,732901,654394,380882,596135,33694,497787,490316,135629,395501,338476,498594,850573,46102,906906,921864,468619,322710,1040139,612048,642998,956810,544033,530746,112305,231424,718401,90143,113175,288273,743641,127779,987118,92846,562385,583384,455759,605607,368061,742778,463033,200129,426354,381550,47352,572929,962813,828085,980026,704393) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001034s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407831 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407831 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000472s ]