SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001872s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 48188 LIMIT 1 [ RunTime:0.001144s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 48188 [ RunTime:0.002315s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (208689,949710,469048,549429,771523,894567,218541,690093,417406,980357,816073,1037544,324899,460291,741206,795669,241049,305891,707160,721486,1007092,610211,170032,975511,250427,409117,352431,732350,427480,517325,468488,295678,108232,937379,317724,143284,660944,300303,851425,643694,760839,884918,322203,452681,257722,740328,197188,233253,414502,1019343,449689,234409,175650,469465,37540,535835,994107,599064,361208,1047049) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007207s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 48188 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000797s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 48188 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000650s ]