SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 458104 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 458104 [ RunTime:0.001920s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (432219,620975,410179,667076,448375,869973,470778,546426,340650,92500,924697,928995,258516,53992,538417,772659,374695,612203,792123,165285,400247,648029,440379,288276,314468,101442,808281,1038862,787224,929511,245608,532981,307629,11486,149452,366236,576318,279428,678249,18253,61182,978585,994675,76193,903283,262218,841015,284915,779548,359946,405953,253155,276324,616452,516777,507339,116111,871155,532846,641252) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 458104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000503s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 458104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]