SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200832 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200832 [ RunTime:0.001734s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (410167,748175,130936,968372,101169,338170,785140,926531,925128,552199,698460,622871,961126,110280,404881,369545,961831,656172,1028152,102681,715622,152807,662060,809825,715586,301734,423726,150442,791584,142517,466564,310641,1022357,39572,428102,460926,1013983,985237,827218,625351,550460,1382,1031133,742370,551519,679973,673070,299573,839045,333263,1010256,245030,1034346,478124,243356,733292,200141,201947,324876,941043) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200832 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200832 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]