SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 583746 LIMIT 1 [ RunTime:0.000444s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 583746 [ RunTime:0.001512s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (439298,310085,873002,453690,522149,209580,228511,77986,106375,977224,237143,489395,57382,803774,778288,224215,167042,611493,1025142,286460,103139,241665,848149,743616,793045,442604,574427,327400,430017,503335,442913,584086,797917,1048387,438910,166656,1020869,1020201,528907,246505,881530,861679,564103,309846,238797,1037047,895839,632407,316922,694542,620578,788052,827479,207448,622353,126326,183052,852945,1018389,900371) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 583746 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000783s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 583746 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]