SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517440 LIMIT 1 [ RunTime:0.000292s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517440 [ RunTime:0.001392s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (241307,117611,639419,138792,855157,695980,1014300,923322,80755,745755,516310,420401,531893,974991,720340,824786,554591,117081,164738,750943,923428,73494,309090,546076,356134,717563,453706,644181,329478,183090,880374,261096,193160,356636,989617,765018,1012950,863114,891305,1013377,265856,627844,58661,455227,215441,639253,697795,1005164,277728,724362,603297,999836,840337,712071,98361,207688,34160,375832,915052,921486) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517440 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517440 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]