SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505188 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505188 [ RunTime:0.002664s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (553869,976672,822055,457138,537019,889354,589872,1023587,321791,304484,377280,867433,124987,613329,526870,658334,159739,269688,585499,705335,240452,864489,755046,62257,1001526,458734,379715,1011910,917872,524060,805075,164729,866733,989434,790027,920297,890794,478889,26036,26587,780209,525295,744383,220305,579023,813433,797035,499910,115393,598228,427387,850379,539968,391447,406326,615270,853327,46173,421191,372143) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505188 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505188 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000443s ]