SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027883 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027883 [ RunTime:0.002159s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (768441,765484,699734,711426,791242,897808,265351,167066,732385,706733,231568,208407,596368,990793,378314,819123,181312,479759,996852,456128,1043307,230846,736632,241047,922865,439288,617116,625273,528871,343096,805328,605374,1004677,884212,762059,145675,102513,183455,265631,762786,489201,709809,716033,677907,552256,985608,787555,685890,88647,855722,738471,318216,215545,878415,772864,1031531,389369,19994,297043,546584) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027883 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027883 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000644s ]