SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50604 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50604 [ RunTime:0.001564s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (689102,112622,915970,595036,935222,1042510,163532,982605,392017,648459,963111,4324,851688,858647,456960,815825,997821,456512,1004516,641846,128710,483901,554340,687132,210823,435732,83161,561118,75784,741569,328071,715910,389786,92059,546819,944903,859862,232568,950790,496456,165221,190359,1044010,104171,443373,950047,371719,425587,626039,583573,1017680,484359,409860,932768,644608,52309,511937,509418,568697,688365) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000960s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50604 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50604 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]