SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001366s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 551723 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 551723 [ RunTime:0.002911s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (201564,33608,770811,81650,1024672,574483,726999,143821,418438,418887,22090,501504,489388,355969,261066,23727,227795,770174,707978,879988,795406,615832,463632,4800,901757,97507,532194,782773,679550,389833,539743,406890,350477,464561,477055,89702,313099,303791,428204,791292,773774,1033331,423552,941874,453116,1020204,322853,504520,146652,989560,667948,293455,142820,798058,356769,633498,56466,965859,73496,639509) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 551723 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 551723 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000651s ]