SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001345s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533113 LIMIT 1 [ RunTime:0.000464s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533113 [ RunTime:0.002532s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (722386,1027672,680152,995979,312938,452864,908234,478719,69948,291834,124713,763694,312088,182714,211650,798433,688319,106887,822835,840764,924542,955511,338007,957756,463215,583437,892635,859296,613058,787923,223543,406283,562954,539391,462888,222756,486017,719273,73210,972796,358214,799537,951375,1020736,422769,512179,603063,436240,330759,647585,407903,940954,218451,887763,879885,39062,711540,416145,313128,95038) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533113 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533113 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001693s ]