SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 199523 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 199523 [ RunTime:0.004789s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1040485,742252,235858,345194,224627,159718,324394,184038,539077,107490,1018506,692250,1048893,899584,319166,229883,534880,843902,1008237,48213,242148,275096,186530,442167,993965,969760,369980,338644,553531,472918,269204,241172,198099,798564,431950,575651,166048,1039501,389710,508383,633119,1043435,47396,338573,296057,493655,733166,356574,178433,160855,414637,105385,149692,196336,660629,1028840,1022004,962516,904184,779468) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 199523 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000526s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 199523 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001597s ]