SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001362s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1032397 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1032397 [ RunTime:0.001966s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (412966,689447,96844,1032714,738281,791301,775418,544822,320476,350426,355125,243942,249647,358689,846312,438886,641092,466536,366639,973387,589231,166180,115681,458246,548611,841402,343289,516706,1044741,474901,626949,50377,318787,541866,44231,889932,349188,572368,795656,496623,935912,906799,229811,927721,102722,366057,633536,651359,718882,456177,927521,215387,23545,716404,522241,622,648628,34132,406505,442188) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1032397 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1032397 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]