SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417573 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417573 [ RunTime:0.001745s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (218043,865104,774135,1046703,682621,436227,425769,981477,729797,218380,555597,548838,72356,1032328,36354,674743,297746,42165,1010375,543558,266351,449500,876455,281668,113542,479152,413452,106335,238805,906685,598119,240559,779764,1039912,114071,244886,105541,928167,603090,43239,791533,682980,373116,283324,911715,370622,615936,426683,410715,489314,196054,172379,610110,490134,142217,504797,106433,26478,241026,705618) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000956s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417573 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417573 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000362s ]