SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480157 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480157 [ RunTime:0.002428s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (218670,742561,219707,214532,91050,985433,757600,722765,639771,644427,371326,522011,507261,274166,688793,30448,171538,292168,200316,99619,347310,660061,178313,113248,558933,310339,887005,896823,811304,109391,313875,952402,731613,501162,684863,357982,280385,47061,54857,876495,485568,778210,556474,950557,153944,11904,774298,56868,644150,464740,592527,1038272,64264,1025652,305716,447894,247819,58374,61532,337506) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480157 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480157 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]