SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1030298 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1030298 [ RunTime:0.001424s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (882145,555835,693488,78120,826476,914504,922522,330052,776689,189410,820149,932910,230738,89218,341674,505381,652813,872617,678827,947546,630588,161021,344946,94151,499184,973250,518102,283481,224767,1000731,484176,86228,919868,996541,660966,678712,715909,806321,347346,489281,119896,705291,406530,88467,314914,582709,164485,649260,178441,992401,217766,429409,12644,150468,69351,448807,502420,481174,279213,834036) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000983s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1030298 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1030298 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]